You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers
run in native mode.
You want to back up the Reporting Services encryption keys to enable you to reuse an existing
report server database in a new installation.
You plan to back up the keys to a floppy disk drive. The backup file must be named rsdbkey.snk
and the backup protected with a password of RSKeyPass1.
Which of the following commands should you run?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers
run in native mode.
You need to configure a report server to use a different report server database. Therefore you
need to restore a copy of the Reporting Services encryption keys from backup. The backup file is
a:\rsdbkey.snk and the password for the backup is RSKeyPass1.
Which of the following commands should you run?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers
run in native mode.
You create an item-level role named Reports Config on an SSRS server.
You need to add a task to the Reports Config role to enable it to view and modify settings that
determine snapshot history limits and caching configuration.
Which task should you add to the Reports Config role?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers
run in native mode.
You create an item-level role named Reports Admin on an SSRS server.
You need to add a task to the Reports Admin role to enable it to modify report properties and view
and modify data sources that provide content to the report.
Which task should you add to the Reports Admin role?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
You are configuring servers running SQL Server Reporting Services (SSRS). All SSRS servers
run in native mode.
You modify the RStrace section of the ReportingServicesService.exe.config file to enable logging.
Which log contains the ClientIP and ServerPort fields to determine which IP address and port
numbers are used to connect to the reports server?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Reporting Services (SSRS) to create a report named Current
Performance for the Sales department.
Sales users need to be able to view the report and see if they are currently behind, on target or
ahead of a sales Key Performance Indicator (KPI).
Which of the following report items would not be appropriate for your report?

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Reporting Services (SSRS) to create a report named Quarterly Sales
Performance for the Sales department.
Sales users need to use the report to view sales trends over the last three months.
Which of the following report items could you use in your report? (Choose all that apply)

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
An Analysis Services cube you are developing for the Marketing department contains a measure
group named Customers.
You need to be able to determine the number of unique customers.
What should you include in your design?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to author a SQL Server 2012 Analysis Services
(SSAS) tabular model project.

You need to restrict which rows are visible to users based on their office department.
Which two of the following steps should you perform? (Choose two)

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A SQL Server 2012 Analysis Services (SSAS) tabular model project is used by the Marketing and
Sales departments. The Marketing department uses sales trends and forecasts to plan the
company marketing strategy and the Sales users use the sales forecasts to focus their sales
targets.
The tables used by the calculations in the model contain data that should not be visible to
company users.
How can you prevent the tables being visible to users without adversely affecting the calculations
performed by the model?