You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
Dates
Delivery dates
Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?

You are developing a Microsoft SQL Analysis Services (SSAS) multidimensional project
A fact table named FactHouseSales has a measure column named Area. All values in the
column are stored in square feet. Users must be able to analyze the area in different units.
You create a table named AreaUnit. Each row in the table consists of the unit name and a
square feet conversion factor value.
You need to implement the area conversion in the project.
What should you do?

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.

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.)

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.)

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?

You create a materialized reference dimension between a dimension named Regions and a
measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The
solution must NOT require that the entire cube be reprocessed.

What should you reprocess?

HOTSPOT
You are designing a dimension named Employee for a SQL Server Analysis Services
multidimensional project.
The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute.
You need to minimize the amount of time required to process the cube.
What should you do? To answer, select the appropriate relationship type for each attribute in
the answer area.

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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 BI Semantic Model (BISM) based on a simple and small dataset
sourced from SQL Server. The data size and complexity of the data relationships will not
change. The model will be used to produce reports in Power View. The reports will show the
relationship between product sales and rainfall over time.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all
that apply.)