You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
A production application stores data in a SQL Server database. Production users want to be able
to view a report of the data stored by the production application.
You plan to create a report using SSRS (SQL Server Reporting Services) to display the production
data. Your report will include a table with three columns. The columns are named Start, Finish
and Duration.
Production users need to be able to view the report table and sort the data in the table by the
Duration column.
How should you configure the 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 Marketing Trends
for the Marketing department.
The Marketing Trends pulls data from a single SQL Server.
You need to modify the report to also pull data from a cloud database hosted on Microsoft SQL
Azure. The current SQL Server database must continue to be used by the report.
Which two of the following steps should you perform? (Choose two)

You work as a SQL Developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure and a SharePoint Server 2010 infrastructure.
A SharePoint Web application is integrated with a SQL Server Reporting Services (SSRS) server
that runs in SharePoint integrated mode. The SSRS server is configured to use the Report Server
E-mail delivery extension.
Several company users have subscriptions for reports. A shared schedule is configured to email
the reports to the users.
An Exchange Administrator has scheduled a maintenance window for the company email server to
perform maintenance on the server. The scheduled downtime means the email server will be
offline at the time of the report subscriptions shared schedule.
You need to prevent the shared schedule attempting to send the report emails during the email
server maintenance window?
Which of the following steps should you perform?

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 to pull employee
information from a database and display it in the company Intranet web site. The information will
be displayed as a table with the following columns: First Name, Last Name, Email Address,
Department.
You want users to be able to click on the email address field of an employee and automatically
open an email addressed to that employee.
You open the Text Box Properties of the EmailAddress detail text box.
Which of the following expressions should you configure?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure and a SharePoint Server 2010 infrastructure.
A server named ABC-Reports1 runs SQL Server Reporting Services (SSRS). The SSRS instance
is configured to run in Native Mode.
You want to view the report execution log to find out how often a report is requested and what
output formats are used the most on ABC-Reports1.
You discover that report execution logging is disabled on ABC-Reports1. You need to enable
report execution logging.
Which four of the following steps should you perform? (Choose four)

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure and a SharePoint Server 2010 infrastructure.
A server named ABC-Reports2 runs SQL Server Reporting Services (SSRS). The SSRS instance
is configured to run in SharePoint Integration Mode.
You want to view the report execution log to find out how often a report is requested and what
output formats are used the most on ABC-Reports2.
You discover that report execution logging is disabled on ABC-Reports2. You need to enable
report execution logging.
Which four of the following steps should you perform? (Choose four)

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 Production Costs
for the Production department.
Your report includes a table that contains two columns named Costs and Revenue. Costs will
display the production costs of each product. Revenue will display the revenue generated by
sales of the product.
You want to configure the report to display the Revenue value in black text if it is higher than the
Production Cost value and red text if it is lower.
You plan to use the following expression: =IIf(Fields!Cost.Value > Fields!Revenue.Value, “Red”, “Black”)
For which text box property should you configure the expression?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-Reports1 runs SQL Server Reporting Services (SSRS). You are configuring
security for ABC-Reports1.
You are evaluating the Browser Role to determine which users should be assigned to it.
Which of the following tasks are assigned to the Browser Role? (Choose all that apply).

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-Reports1 runs SQL Server Reporting Services (SSRS). You are configuring
security for ABC-Reports1.
You are evaluating the SSRS predefined roles to determine which users should be assigned to the
roles.
Company security policy states that all users must be assigned the minimum permissions to
perform their required tasks.
Which role should be assigned to users to enable them to manage a personal workspace for
storing and using reports and other items?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-Reports1 runs SQL Server Reporting Services (SSRS). You are configuring
security for ABC-Reports1.
A user named Mia is assigned to the Browser Role on ABC-Reports1. Mia attempts to create a
subscription but is unable to select a shared schedule.

You need to assign Mia to a role that will enable her to view shared schedules.
Which role should you assign while minimizing permissions?