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?

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

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 manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging.
Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?