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?

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching parameters.
Which task should you add to the Developer role?

You are modifying a SQL Server Analysis Services (SSAS) cube that aggregates order data from a Microsoft Azure SQL Database database. The existing database
contains a customer dimension.
The marketing team has requested that customer marketing categories be added to the database.
The marketing categories must meet the following requirements:
– A customer member must be able to belong to multiple category members.
– A category member must be able to group several customer members.
– The marketing team must be able to create new categories every month in the data source.
You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between
attributes.
You need to increase query and dimension processing performance.
What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube.
The cube consists of a single measure group that contains the following measures:
·Total Quantity On Hand
·Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is
updated hourly.
What should you do?

You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube
includes a dimension named Account and the dimension’s Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department has the following requirements for the cube:

– Include a year-over-year (YOY) calculation
– Include a month-over-month (MOM) calculation
You need to ensure that the calculations are implemented in the cube.
Which Multidimensional Expressions (MDX) function should you use?

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group.
Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel
2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?