Free Microsoft 070-460 Exam Dumps Questions & Answers

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
• B.  Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
• C.  Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
• D.  Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.

You are troubleshooting query performance for a SQL Server Analysis Services (SSAS)
cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?

• A.  Progress Report Begin
• B.  Query Begin
• C.  Get Data From Aggregation
• D.  Query Subcube
• E.  Execute MDX Script Begin
• F.  Calculate Non Empty Begin

What should you do?

• A.  Implement monthly remote partitions.
• B.  Implement monthly local partitions.
• C.  Use multidimensional OLAP (MOLAP) on all local partitions.
• D.  Use relational OLAP (ROLAP) on all local partitions.

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.
The cube contains a Key Performance Indicator (KPD to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag.
Which report item should you add?

• A.  an Indicator
• B.  a Gauge that uses the Linear type
• C.  a Sparkline
• D.  a Data Bar
• E.  a Gauge that uses the Radial type

HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
- Users must be able to retrieve aggregate data from partition1 as quickly as
possible.
- The processing time for partition1 and partition2 must be minimized.
- The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.

Correct Answer: