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

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data

relationships will not change. The model will be used to produce reports in Power View. The reports will show the relationship between product sales and rainfall
over time.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders.
You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed.
What should you reprocess?

You are modifying a SQL Server Analysis Service (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 developing a Microsoft SQL Analysis Services (SSAS) multidimensional project
A fact table named FactHouseSales has a measure column named Area. All values in the column are stored in square feet. Users must be able to analyze the area
in different units.
You create a table named AreaUnit. Each row in the table consists of the unit name and a square feet conversion factor value.
You need to implement the area conversion in the project.
What should you do?

You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
– Dates
– Delivery dates
– Ship dates
You need to implement the minimum number of required SSAS objects.
What should you do?

You are managing a SQL Server Reporting Services (SSRS) instance.
A website 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?

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.

You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?