A multinational retailer has retail locations on several continents. A single SQL Server
Reporting Services (SSRS) instance is used for global reporting.
A SQL Server Analysis Services (SSAS) instance for each continent hosts a
multidimensional database named RetailSales. Each RetailSales database stores data only
for the continent in which it resides. All of the SSAS instances are configured identically. The
cube names and objects are identical.

Reports must meet the following requirements:
A report parameter named ServerName must be defined in each report.
When running a report, users must be prompted to select a server instance.
The report data source must use the Microsoft SQL Server Analysis Services data source
type.
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of
the data source?

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server
Analysis Services (SSAS) cube. The cube is used to measure sales growth by salesperson.
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 flag.
Which report item should you add?

HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft
Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill
through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML.
The report includes a dataset with fields named Description. Price, and Color. The report
layout includes a table that displays product details and also includes columns named
Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.

What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user. The columns and
tables cannot be removed because they are used in calculations. The calculations are used
to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines
a measure named Revenue and includes a table named Date. The table includes year,
semester, quarter, month, and date columns. The Date column is of data type Date. The
table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of revenue.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has
tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
Product Id
Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
Product Id
Maximum Sales Price
The Maximum Sales Price column is available only in the Products table.
You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced
column must store a value of TRUE if the value of the Unit Sales Price is greater than the
value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced
column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose
all that apply.)

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named DimEmployee. The table contains employee details,
including the sales territory for each employee. The table also defines a column named
EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and
logon name for each employee. You create a role named Employees.
You need to configure the Employees roles so that users can query only sales orders for
their respective sales territory.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power
View solution.
You need to grant permission for salespersons to view only the data based on their sales
territory.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise
specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?