You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft
Azure SQL Database database. The ProcessingOption property for the project is set to Do Not
Process.

Several calculated columns have been added to a table. The project has been deployed to the
production server.
You need to ensure that newly added data is processed on the production server.
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.)
Select and Place:

You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate
(SELECT DISTINCT) query for each attribute even though they all come from a single database
table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to the
underlying database, and processing must continue if any errors are encountered.
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.)

Select and Place:

You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is
configured to source data from a Microsoft Azure SQL Database database. The cube is processed
each night at midnight.
The largest partition in the cube takes 12 hours to process, and users are unable to access the
cube until noon. The partition must be available for querying as soon as possible after processing
commences.
You need to ensure that the partition is available for querying as soon as possible, without using
source data to satisfy the query.
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.)
Select and Place:

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?