You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images. Report users require PDF exports of the
report with no bulky images of the report header.
You need to ensure that the header of the report is hidden when a user exports the report to
PDF format.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

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

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server
Data Tools (SSDT).
The report contains tables, images, charts, page breaks, gauges, and indicators.
You need to ensure that the reports can be exported to Microsoft Excel and PDF formats
and do not have any layout issues.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated
mode.
You identify a problem with the operations performed by the Report Server Web service.
You need to view the Report Server trace logs. In which directory should you view the files?

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard
names and their year-to-date (YTDJ grape yield.
Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named
VineyardName and YTDGrapeYield
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value
of the YTD grape yield values.
What should you do?

A large manufacturing company has manufacturing plants in many states. Each state has a
dedicated SQL Server instance that stores its manufacturing data. Each SQL Server
instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a stale name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You are creating a new report in SQL Server Report Builder. You add a Microsoft Azure SQL
Database data source. Then you add a dataset that has four fields named Year. Country,
Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales
amount by category. The country rows {the next six rows as shown in the diagram) must
present total sales amount by country. The total row must present the total sales for each
year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a
grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A
system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.

You need to enable members of the Developer Support role to modify the report execution
timeout period.
Which task should you add to the Developer Support role?

DRAG DROP
You are developing a SQL Server Reporting Services (SSRS) report that sources data from
a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube
contains a date dimension and other dimensions. The report design includes two report
parameters named StartDate and FinishDate as shown in the following diagram.

The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the
dataset is filtered by the existing report parameters.
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.)

You are managing a SQL Server Reporting Services (SSRS) instance.
A website must pass credentials to the local security authority for Reporting Services.

You need to configure Reporting Services to issue a challenge/response when a connection
is made without credentials.
Which authentication type should you configure in the RSReportServer.config file?