You administer a SQL Server Analysis Services (SSAS) instance.
You need to capture a continuous log of detailed event and subevent durations and custom trace events from
queries executed in the SSAS instance.
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.)

You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determinewhether any of them are running longer than usual.
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.)

You are designing a SQL Server Integration Services(SSIS) package configuration strategy.
The package configuration must meet the following requirements:
Include multiple properties in a configuration.
Force packages to load all settings in the configuration.
Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.

Hot Area:

You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that containsa Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Analysis Services (SSAS) data model on a very large data warehouse.
The fact tables in the data warehouse contain terabytes of data in tens of billions of rows. You mustsupport
the following features:
Complex attribute/column relationships
Advanced calculations in the data model definition
Advanced calculations using logic deployed in a custom assembly
You need to choose the correct SSAS design strategy.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area.(Answer
choices may be used once, more than once, or not all.)

You are administering a SQL Server Analysis Services (SSAS) database on a server.
The database hosts a financial cube based on a SQL Azure database.
You need to grant read access to the financial cubefor all users in the group USA\PowerUsers.
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.)

You are developing a SQL Server Analysis Services (SSAS) cube.
A dimension named Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.
You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.

Exhibit:
Hot Area:

You are designing a self-service business intelligence and reporting environment. Business analysts will create
and publish PowerPivot for Microsoft Excel workbooks and create reports by using SQL Server Reporting
Services (SSRS) and Power View. When the data models become more complex and the data volume
increases, the data models will be replaced by IT-hosted server-based models. You have the following
requirements:
Maintain the self-service nature of the reporting environment.
Reuse existing reports.
Add calculated columns to the data models.
You need to create a strategy for implementing thisprocess.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area.(Answer
choices may be used once, more than once, or not all.)