Free Microsoft 070-460 Exam Dumps Questions & Answers

DRAG DROP
You are designing a dataset for a SQL Server Reporting Services (SSRS) report. The report includes the report items displayed in the following graphic.

The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

Correct Answer:

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?

• A.Add an indicator to the table.
• B.Use an expression for the TextDecoration property of the vineyard text box.
• C.Use an expression for the Style property of the vineyard text box.
• D.Use an expression for the Color property of the vineyard text box.
• E.Use an expression for the Font property of the vineyard text box.

DRAG DROP
You need to configure the attribute relationship types for the Salesperson dimension.
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (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 model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations.
You need to hide the tables and columns.
What should you do?

• A.In the Properties window for the applicable tables and columns, set the Visible property to True
• B.In the Properties window for the applicable tables and columns, set the Enabled property to False
• C.Right-click the applicable tables and columns and select the Hide from Client Tools option.
• D.Right-click the applicable tables and columns and select the Hide option.

Note: This question is part of a series of questions that use the same set of answer choices. An answer choice may be correct for more than one question in the series.
You are designing a SQL Server Analysis Services (SSAS) cube.
You need to create a measure to count unique customers.
What should you do?

• A.Add a measure that uses the DistinctCount aggregate function to an existing measure group.
• B.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• C.Add a measure group that has one measure that uses the DistinctCount aggregate function.
• D.Create a dimension. Then add a cube dimension and link it several times to the measure group.
• E.Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property.
• F.Add a measure that uses the Count aggregate function to an existing measure group.
• G.Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• H.Create several dimensions. Add each dimension to the cube.
• I.Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes.
• J.Use the Business Intelligence Wizard to define dimension intelligence.
• K.Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation.
• L.Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group.
• M.Use role playing dimensions.
• N.Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group.
• O.Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.