Free Microsoft 070-460 Exam Dumps Questions & Answers

You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
- Members of the role must be able to update shared data sources.
- Members of the role must not be able to consume reports or manage
subscriptions.
- The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  the Content Manager role
• B.  the Publisher role
• C.  the Read and Process role
• D.  the Browser role

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.

Correct Answer:

You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data.
Customer dimension attributes will come from the following two sources:
- An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily.
- A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly.
Most report queries against the cube use attributes from both sources. Customers in the
cube dimension will frequently be filtered by the geographic attributes.
You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.  Create one dimension table that combines data from both sources. Create a cube dimension for each source.
• B.  Create a dimension table for each source. Create one cube dimension that joins the two dimension tables together.
• C.  Create a dimension table for each source, and a cube dimension for each source.
• D.  Create one dimension table that combines data from both sources. Create one cube dimension that references the dimension table.

You are creating a Multidimensional Expressions (MDX) calculation for Projected Revenue in a cube.
For Customer A, Projected Revenue is defined as 150 percent of the Total Sales for the customer. For all other customers, Projected Revenue is defined as 110 percent of the Total Sales for the customer.
You need to calculate the Projected Revenue as efficiently as possible.
Which calculation should you use? (More than one answer choice may achieve the goal.
Select the BEST answer.)

• A.  Option C
• B.  Option D
• C.  Option A
• D.  Option B

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 ProductCategory, click Hide if Name Equals Parent
• B.  Set ProductName as the parent of ProductSubcategory and set ProductSubCategory as the parent of ProductCategory. For ProductCategory, click Hide if Name Equals Parent
• C.  Set ProductCategory as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductName. For ProductSubcategory, click Hide if Name Equals Parent.
• D.  Set ProductName as the parent of ProductSubCategory and set ProductSubcategory as the parent of ProductCategory. For ProductSubcategory, click Hide if Name Equals Parent.