Online Access Free 070-460 Exam Questions

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSAS) cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson's sales are off target, slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?

• A.Radial Gauge
• B.Data Bar
• C.Linear Gauge
• D.Sparkline
• E.Indicator

HOTSPOT
A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly increasing in size. The cube consists of a single measure group and a single partition. The cube is currently processed by using the Process Full process option.
You have the following requirements to reduce the cube processing time:
Partition the measure group by month.
Create a staging table that contains only data which is more recent than the last
time the cube was processed.
Do not include data updates or deletions in the staging table.
Insert records from the staging table into the appropriate partition.
You need to change the process option to meet the requirements.
Which process option should you choose?
-- --
To answer, select the appropriate option from the drop-down list in the dialog box.

Correct Answer:

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

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

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a Revenue measure group from a different database.
In SQL Server Data Tools (SSDT), which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

You need to implement security in the cube to limit the sites visible to each user.
What should you do?

• A.Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
• B.Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
• C.Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
• D.Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.