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?

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 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?

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 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 install SQL Server Reporting Services (SSRS).
You need to back up a copy of the symmetric key.
Which command should you run?

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 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 are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the
Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.

How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)