You need to implement the Customer Sales and Manufacturing data models.
What should you do? (Each correct answer presents a partial solution. Choose all that
apply.)

• A. Use SQL Server Integration Services (SSIS) to copy the database design to the SSAS instance, and specify tabular mode as the destination.
• B. Install a new instance of SSAS in tabular mode.
• C. Use the Database Synchronization Wizard to upgrade the database to tabular mode.
• D. Use the current SSAS instance.
• E. Use SQL Server Data Tools (SSDT) to redevelop and deploy the projects.

HOTSPOT
You are designing a SQL Server Analysis Services (SSAS) cube that contains two measure groups named Sales History and Current Sales.
The Sales History measure group has the following characteristics:
----
Data changes on a monthly basis.
The measure group contains a very high data volume.
Queries that use the measure group only reference aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
The Current Sales measure group has the following characteristics:
----
Data changes frequently.
The measure group contains a low data volume.
Queries that use the measure group often reference non-aggregate data.
The measure group includes SUM, MIN, MAX, and COUNT aggregate functions.
You need to select a storage mode for each measure group. The solution must meet the following requirements:
- For the Sales History measure group, query performance must be optimized over data latency.
- For the Current Sales measure group, data latency must be optimized over query performance.
What should you do? To answer, select the appropriate storage mode for each measure group 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 a BIGINT 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. Create a single fact dimension in each table for its flags and indicators.
• D. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.

DRAG DROP
You are developing a SQL Server Analysis Services (S5AS) cube. The cube consists of a
single measure group.
The measure group consists of one partition that uses MOLAP.
The proactive caching policy has the following requirements: - The cache must be updated when data is changed in the table named tbIOrders. - Changes must be notified through the use of the XML for Analysis (XMLA) NotifyTableChange command. You need to configure the proactive caching policy to meet the requirements.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

The Sales database includes a table named Products that contains 42 columns, and two tables that record all product sales transactions. The database does not store aggregated data. The database is continually maintained to provide optimal indexing. The database server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing product information from the Products table. You have the following requirements:
- Display the ProductID in the first column. Organize the remaining columns alphabetically by column heading.
---
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. A table-based OLE DB source; a Script component and a Flat File destination.
• B. Only a SQL command-based OLE DB source and a Flat File destination.
• C. A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat File destination.
• D. A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat File destination.