You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was
developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a
very large fact table and is partitioned by month. The fact table is incrementally loaded each day
with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use? (To answer, select the appropriate option in the answer
area.)
Hot Area:

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error. You identify that
the amount of physical memory in the server is insufficient. Additional physical memory cannot be
installed in the server.
You need to configure the server to allow paging to disk by using the operating system page file
(pagefile.sys).
Which four 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.)
Select and Place:

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique color scheme combination of foreground and
background colors.
You need to ensure that all of the text boxes in the table headers use the correct business unit colors.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.

Which Hidden property expression should you use for the report header? {More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a Microsoft Azure SQL Database database.
The report must display the value and status of a Key Performance Indicator (KPI).
Which report item should you use? (Each answer presents a complete solution. Choose all that apply.)

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSASJ cube.
The cube contains a Key Performance Indicator (KPI) to show if a salesperson’s sales are off target slightly off target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green circle.
Which report item should you add?

You manage a SQL Server Reporting Services (SSRS) instance.
An application 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?

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The
report includes a table that displays the number of recorded registration occurrences per year, as shown in the following table.

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column.
What should you do?

You deploy a tabular model in DirectQuery mode to a server named Server1. Server1 has SQL Server Analysis Services (SSAS) installed. The model uses a
relational data source named DB1.
You need to ensure that Server1 passes the credentials of the current user browsing the model to DB1.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant permission for salespersons to be able to view only the data based on their sales territory.

What should you do?