Free Microsoft 070-466 Exam Dumps Questions & Answers

You need to create the KPI in the AdhocReports project.
What should you do?

• A.  Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• B.  Create a KPI based on the OrderQuantity column and then set the target value.
• C.  Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value.
• D.  Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.

You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure SQL Database data warehouse.
You need to implement a degenerate dimension.
What should you do?

• A.  Add a surrogate key to the fact table and use it as the degenerate dimension key.
• B.  Create snowflake dimension tables based on normalized views of the fact table in the data source.
• C.  Create a junk dimension table based on the fact table in the data source.
• D.  Use the fact table as the data source for the dimension.

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) 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 tblOrders.
* 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.)

Correct Answer:

Explanation:
Box 1: On the Partitions tab, Click Storage Settings
We specify the Storage Settings for the correct partition.
Box 2: Enable proactive caching.
We enable proactive caching.
Box 3: Select the Client initiated notification type, and then select the tblOrders table.
On the Notifications tab, there are three options out of which, as shown below, you can select any one at a time.
* SQL Server - With this option, SSAS uses SQL Server notification services/specialized trace mechanism to identify data changes.
* Client initiated - With this option, client can specify the XMLA (XML for Analysis) command (NotifyTableChange) to identify data changes.
* Scheduled polling - With this option, SSAS uses a series of queries to see (polling at defined interval) if there is any data change at the underlying relational database.

Note:
You use the Storage Settings dialog box in BIDS (Business Intelligence Development Studio) to set the proactive caching feature, storage location, and notification settings for a dimension, cube, measure group, or measure group partition.
* In the Cube Browser, open your cube and select the Partitions tab.
* Expand the measure group and select the partition for which you want to enable proactive caching.
* Click the Storage Setting link to open the Partition Storage Settings dialog box similar to the one as shown in below image. (Box 1)

The Custom Setting allows you to explicitly enable proactive caching (if you don't want to use Standard Setting), set storage mode, and notification options. (Box 2)

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use?

• A.  Process Clear
• B.  Process Data
• C.  Process Default
• D.  Process Index
• E.  Process Full
• F.  Process Add

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

Correct Answer:

Explanation:

Note: For Measure1 we use Average, and for Measure2 Min to get the fastest time.