Online Access Free 70-460 Practice Test

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 Color property of the vineyard text box.
• C.Use an expression for the TextDecoration property of the vineyard text box.
• D.Use an expression for the Font property of the vineyard text box.
• E.Use an expression for the Style property of the vineyard text box.

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)

You need to complete the MDX statement. Which MDX function should you use in line 03? To answer, select the appropriate MDX
function in the functions list.

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 F
• B.Option B
• C.Option E
• D.Option A
• E.Option D
• F.Option C

After you deploy the RegionalSales report, you attempt to configure the subscriptions.
You discover that the subscription creation screen does not display the option to deliver the
report by email.
You need to ensure that subscriptions can be delivered by using email.
What should you do?

• A.From Central Administration, modify the SMTP settings of the SharePoint Server server farm.
• B.Modify the Rssrvrpolicy.config file.
• C.From Central Administration, modify the properties of the Reporting Service Application.
• D.Modify the Rsmgrpolicy.config file.

DRAG DROP
You have a cube named Cube1 that contains the sales data for your company.
You plan to build a report based on the cube.
You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year.
Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Correct Answer: