Free Microsoft 070-460 Exam Dumps Questions & Answers

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 Measures clause on line 02 to axis 1.
• B.  Move the Product clause from line 08 to line 10.
• C.  Move the Date clause from line 10 to line 08.
• D.  Move the Date and Product clauses on line 11 to axis

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a tabular model.
Which role permission should you use?

• A.  Select
• B.  Process
• C.  Browser
• D.  Read Definition
• E.  Explorer
• F.  Read

DRAG DROP
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)

Correct Answer:

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be
used in the definition of a hierarchy. The City column exists in the Geography table that is
related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

• A.  Option E
• B.  Option B
• C.  Option C
• D.  Option A
• E.  Option F
• F.  Option D

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.

The Product dimension has three attribute hierarchies:
---
Product
Subcategory
Category
The attributes have the following relationships defined: Product > Subcategory - Category. Each attribute has a key and a name sourced from the related key and name columns in theDimProduct table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimProducf, Column: 'SubCategoryKey', Value: '23'. The attribute is Subcategory'."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?

• A.  Remove the duplicate data from the DimProduct table.
• B.  Relate the Subcategory and Category attributes directly to the Product attribute.
• C.  Delete the Products hierarchy.
• D.  Remove the Subcategory attribute.