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?

You are designing a SQL Server Analysis Services (SSAS) cube based on a Microsoft Azure SQL Database data warehouse.
You need to implement a degenerate dimension.
What should you do?

A multidimensional SQL Server Analysis Services (SSAS) database will be tested next week.
During the test period, users will access the database for 30 days. Multidimensional Expressions (MDX) queries generated during the test period must represent the
variety of queries that will be used in the production environment.
After testing completes, you need to implement aggregations for every partition in the solution while minimizing development effort. You need to ensure that the
aggregations are optimal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

You work in the Business Intelligence (BI) department of a multinational company.
To share its sales data between the various subsidiaries, the company has requested a new
corporate BI solution that meets the following requirements:
– The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular Business Intelligence Semantic Model (BISM).
– The model must incrementally add 10 million fact rows of sales data per month.
– The model must be translated to English, German, Chinese, or Spanish based on users’ locale.
– The model must be able to contain the most recent 36 months of data, in order to let users query the data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)