70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

DRAG DROP

You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL) statements on a SQL Azure database.

The T-SQL statements may be executed in any order. The T-SQL statements have unpredictable execution times.

You have the following requirements:

The package must maximize parallel processing of the T-SQL statements.

After all the T-SQL statements have completed, a Send Mail task must notify administrators.

You need to design the SSIS package.

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 have a business intelligence (BI) solution that uses SQL Server Integration Services (SSIS). The BI solution includes an extract transformation, and load (ETL) system.

You are designing a logging and auditing strategy for the ETL system.

You need to ensure that an ETL administrator can view the row counts of any data flow path for each package execution.

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:

HOTSPOT You administer a SQL Server Analysis Services (SSAS) cube.

You plan to optimize the cube partitions by using usage-based optimization.

You need to configure the SSAS instance.

Which properties should you configure? To answer, select the appropriate properties in the dialog box in the answer area.

Hot Area: