You maintain a SQL Server 2008 Analysis Services (SSAS) database.
You are troubleshooting query performance by using SQL Profiler.
You are identifying the queries that take a long time to run. You determine the time used by the Storage
Engine.
You need to determine the time used by the Formula Engine.
What trace event should you use?

• A. Query Cube End
• B. Get Data from Cache
• C. Query Subcube
• D. MDX Script End

You create a report by using SQL Server 2008 Reporting Services (SSRS).
You plan to deploy the report on a report server. The report will be delivered on a regular basis to a dynamic
list of subscribers.
You need to create a new subscription on the report server.
What should you do?

• A. Select the My Subscriptions page, and then click the New Data-driven Subscription button.
• B. Select the report you created. Click the Subscriptions tab, and then click the New Subscription button.
• C. Select the report you created, and then click the New Subscription button.
• D. Select the report you created. Click the Subscriptions tab, and then click the New Data-driven Subscription button.

You maintain a report in a SQL Server 2008 Reporting Services (SSRS) instancE.The report contains
query parameters that allow users to filter the contents of the report. The report queries the data source
randomly.
You configure the report to be rendered from a report execution snapshot.
You need to ensure that users can continue to use parameters to filter the report.
What should you do?

• A. Remove the filters from the dataset queries. Use the parameters to filter the datasets.
• B. Add a default value to all parameters.
• C. Move the queries to the stored procedures. Use the stored procedures to populate and filter the datasets of the report.
• D. Modify the datasets to use the Table query type.

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that loads data to a SQL
Server 2008 database.
You need to ensure that the data flow updates the existing records in the SQL Server database by using
data from the rows in your data flow.
Which data flow component should you use?

• A. OLE DB Destination
• B. Data Conversion Transformation
• C. SQL Server Destination
• D. OLE DB Command Transformation

You are developing a SQL Server 2008 Integration Services (SSIS) data flow that extracts data from two sources: a Mircosoft Excel sources and ADO.net. The ADO.net source is based on a SELECT statement that uses an ORDER BY clause.
The data flow is as shown in the following exhibit. (Click the Exhibit button.)
When the paths from the two sources are connected to the Merge Join component, the following error
message is displayed:
Data Flow Task: the input is not sorted. The `input "Merge Join Left Input"(48)' must be sorted.
You need to ensure that data from each query is included in each row in the data flow.
What should you do? (Each correct answer presents part of the solution. Choose two.)

• A. Add an OLE DB Command transformation for each data flow.
• B. Replace the Merge Join transformation with a Union All transformation.
• C. Update the sorting properties in the ADO.net source component.
• D. Add a Sort transformation for the Excel source.