Which three actions should you perform?
You are creating a product dimension table and a SQL Server Integration Services (SSIS)
package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.
You need to build the following two measures in the cube: A measure named Measure1 that must contain the avera
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for
a running team.
The data warehouse used by the cube contains the time durations of taps run by each
runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
A measure named Measure1 that must contain the average time duration of the laps run by
each runner.
A measure named Measure2 that must contain the lap-time duration and the name of the
runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for
each measure in the answer area.
What should you create?
You have a database that is accessed by 300 concurrent users.
You need to log all of the queries that become deadlocked. The solution must meet the
following requirements:
Provide a representation of the deadlock in XML format.
Minimize the impact on the server.
What should you create?
Which option should you select?
HOTSPOT
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.
You need to ensure that every aggregation includes the Category attribute.
Which option should you select? To answer, select the appropriate option button in the
answer area.
Which four actions should you perform in sequence?
DRAG DROP
You are designing a business intelligence (BI) solution for a hotel booking system. Each
hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named
Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each
guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS)
for the hotel booking system.
Which four 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 need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time a
You are modifying a SQL Server Analysis Service (SSAS) cube.
The cube consist of a single measure group that contains the following measures:
Total Quantity On Hand
Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is
updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?
which three actions should you perform in sequence?
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), 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 developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a
single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements:
The cache must be updated when data is changed in the table named tbIOrders.
Changes must be notified through the use of the XML for Analysis (XMLA)
NotifyTableChange command.
You need to configure the proactive caching policy to meet the requirements.
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 need to reduce the amount of time it takes to complete the query
You have the following query on a disk-based table:
You discover that the query takes a long time to complete.
The execution plan is shown in the Execution Plan exhibit. (Click the Exhibit button.)
The index usage is show in the Index Usage exhibit. (Click the Exhibit button.)
You need to reduce the amount of time it takes to complete the query. You must achieve this
goal as quickly as possible.
What should you do?
You need to optimize the partition structure and design aggregations to improve query performance and minimize
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube
named Sales. Before the initial deployment of the cube, partition design was optimized for
processing time. The cube currently includes five partitions named FactSalesl through
FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year’s information. The other partitions contain
information from prior years; one year per partition. Currently, no aggregations are defined
on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source
and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query
performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)