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?

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 users in all
company departments. The single model represents the contents of the entire companys data
warehouse and has many tables, measures, and dimensions.
The complexity of the model is daunting to some users in the Sales department. Users in the
Sales department only need to interact with a small part of the model for their business intelligence
and reporting requirements. Users in other departments need to use the complete model.
How can you simplify the view of the model so that Sales department users only see information
that is relevant to them?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are configuring
security for a tabular model on ABC-SSAS1.
You need to assign role permissions to a role to ensure that users can query the data in the
tabular model but cannot see the model database in SSMS (SQL Server Management Studio).
Which role permission should you assign to the role?