070-460 by Microsoft Valid Free Exam Practice Test

Question 1

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A. Configure SSRS01 to use the Negotiate authentication type. B. Register a service principal name for the Analysis Services service. C. Restart the US service. D. Register a service principal name for the Report Server service. E. Configure SSRS01 to use the Custom authentication type.

Correct Answer: A,C,E

Question 2

DRAG DROP
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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:

Question 3

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

A. Set the Type property of the partition's measure group to Forecast. B. Implement the linked measure group as a local measure group. C. Implement the local measure group as a linked measure group. D. Set the StorageMode property of the linked measure group to Rolap.

Correct Answer: B

Question 4

You need to configure a hierarchy for DimProduct that meets the technical requirements.
What should you do?

A. Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent. B. Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent. C. Set ProductCategory as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductName. For ProductCategory, click Hide if Name Equals Parent D. Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

You execute the SalesbyCategory report and receive the following error message: "Members, types, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Move the Product clause from line 08 to line 10. B. Move the Date clause from line 10 to line 08. C. Move the Date and Product clauses on line 11 to axis D. Move the Measures clause on line 02 to axis 1.

Correct Answer: A,D

Question 6

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 a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension. B. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension. C. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators. D. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.

Correct Answer: B

Question 7

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. a Sparkline B. a Gauge that uses the Radial type C. a Data Bar D. an Indicator E. a Gauge that uses the Linear type

Correct Answer: D

Question 8

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
Revenue must be compared to a goal and described by a status and a trend. Revenue,
goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions.
You need to add the Revenue measure.
Which tab should you select? (To answer, select the appropriate tab in the answer area.)

Correct Answer:

Question 9

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:

Microsoft Transition Your MCITP: Business Intelligence Developer 2008 to MCSE: Business Intelligence - 070-460 Exam Practice Test