Which three actions should you perform in sequence?
DRAG DROP
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.)
Which command should you run?
You install SQL Server Reporting Services (SSRS).
You need to restore a copy of the symmetric key.
Which command should you run?
What should you set from the index options?
You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?
You need to design an ETL process that meets the requirements
You are designing an extract, transform, load (ETL) process for loading data from a SQL
Server database into a large fact table in a data warehouse each day with the prior day’s
sales data.
The ETL process for the fact table must meet the following requirements:
Load new data in the shortest possible time.
Remove data that is more than 36 months old.
Ensure that data loads correctly.
Minimize record locking.
Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)
Which task should you add to the Folder Access Controller role?
You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role
named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task.
When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role sc that the role members can view
folders.
Which task should you add to the Folder Access Controller role?
What should you implement?
You run the following code:
You need to ensure that the root node of the XML data stored in the Details column is
<Order_Details>.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.
Which calculation should you use?
You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue
in a cube.
For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the
customer. For all other customers, Projected Revenue is defined as 110 percent of the Total
Sales for the customer.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)
Which three actions should you perform in sequence?
DRAG DROP
You are validating whether a SQL Server Integration Services (SSIS) package named
Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow
component of the 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.)
Which three actions should you perform in sequence?
DRAG DROP
You are administering a SQL Server Analysts Services (SSAS) database on a server. The
database hosts a financial cube based on a SQL Azure database.
You need to grant write access to the financial cube for 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.)
Which two actions should you perform?
You have a SQL Server Reporting Services (SSRS) instance. The instance has a report that
displays 3 million records.
Users report that they experience performance issues when they use the report.
You need to ensure that the report renders as quickly as possible.
Which two actions should you perform? Each correct answer presents part of the solution.