Online Access Free 70-460 Exam Questions

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a Windows Azure SQL Database database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)

You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?

• A.Map gallery
• B.ESRI shape file
• C.SQL Server spatial query
• D.Bing Maps layer

You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?

• A.Rskeymgmt -i
• B.Rskeymgmt -e -f %temp%\rs.key -p Password1
• C.Rskeymgmt -a -f %temp%\rs.key -p Password1
• D.Rskeymgmt -d

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:

What should you do?

• A.Implement monthly remote partitions.
• B.Use relational OLAP (ROLAP) on all local partitions.
• C.Use multidimensional OLAP (MOLAP) on all local partitions.
• D.Implement monthly local partitions.

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