HOTSPOT
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and
partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
- Users must be able to retrieve aggregate data from partition1 as quickly as
possible.
- The processing time for partition1 and partition2 must be minimized.
- The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
• B. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
• C. Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
• D. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.

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?

• A. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.
• B. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True.
• C. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False
• D. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.

You have two servers named Server1 and Server2. Both servers have SQL Server 2012 installed. Both servers have a SQL Server Integration Services (SSIS) catalog.
You are preparing a disaster recovery plan for a business intelligence (BI) solution.
You need to ensure that the SSIS catalog from Server1 can be restored to Server2.
Which two actions should you perform on Server1? Each correct answer presents part of the solution.

• A. Run sp_configure 'clr enabled', 1.
• B. Back up the master database.
• C. Back up the master key of the SSISDB database.
• D. Back up the SSISDB database.
• E. Run sp.configure 'clr enabled', 0.
• F. Back up the master key of the master database.