DRAG DROP -You are editing a SQL Server Integration Services (SSIS) package that uses checkpoints.The package performs the following steps:✑ Download a sales transaction file by using FTP.✑ Truncate a staging table.✑ Load the contents of the file to the staging table.✑ Merge the data with another data source for loading to a data warehouse.The checkpoints are currently working such that if any of the four steps fail, the package will restart from the failed step the next time it executes.You need to modify the package to ensure that if either the Truncate Staging Table or the Load Sales to Staging task fails, the package will always restart from theTruncate Staging Table task the next time the package runs.Which three steps should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
DRAG DROP -You are building a fact table in a data warehouse.The table must have a columnstore index. The table cannot be partitioned.You need to design the fact table and load it with data.Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)Select and Place:
DRAG DROP -You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record.In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to theDimProduct table take longer than expected.You need to create a solution that uses a single command to perform an update and an insert.How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area. You may need to drag the split bar between panes or scroll to view content.)Select and Place:
You are designing a data warehouse for a fresh food distribution business that stores sales by individual product. It stores sales targets by product category.Products are classified into subcategories and categories.Each product is included in only a single product subcategory, and each subcategory is included in only a single category.The data warehouse will be a data source for an Analysis Services cube.The data warehouse contains two fact tables:✑ factSales, used to record daily sales by product✑ factProductTarget, used to record the monthly sales targets by product categoryReports must be developed against the warehouse that reports product sales by product, category and subcategory, and product sales targets.You need to design the product dimension. The solution should use as few tables as possible while supporting all the requirements.What should you do?
You are reviewing the design of a student dimension table in an existing data warehouse hosted on SQL Azure.The current dimension design does not allow the retention of historical changes to student attributes such as ParentOccupation.You need to redesign the dimension to enable the full historical reporting of changes to multiple student attributes including ParentOccupation.What should you do?
You maintain a SQL Server Integration Services (SSIS) package. The package was developed by using SQL Server 2008 Business Intelligence DevelopmentStudio (BIDS).The package includes custom scripts that must be upgraded.You need to upgrade the package to SQL Server 2012.Which tool should you use?
