Microsoft Developing SQL Data Models : 070-768

You are developing a SQL Server Analysis Services (SSAS) tabular project.
The model includes a table named Sales.
The Sales table includes a single date column.
The Sales table must meet the following requirements:
- Queries must be able to return all rows.
- Must be able to support four different processing schedules for
different date ranges.
- Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.What should you do?

• A. Create four partitions for the Sales table. Create four roles. Use the same row filter queries for each role and partition.
• B. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for each of the four tables.
• C. Convert the Sales table into four smaller tables by using row filter queries. Use one perspective for all four tables.
• D. Create four partitions for the Sales table. Use row filter queries for each partition.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have an existing multidimensional cube that provides sales analysis. The users can slice by date, product, location, customer, and employee.
The management team plans to evaluate sales employee performance relative to sales targets.
You identify the following metrics for employees:
You need to implement the KPI based on the Status expression.
Solution: You design the following solution:

Does the solution meet the goal?

• A. Yes
• B. No

You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
- The processing must load data into partitions or tables.
- The processing must not rebuild hierarchies or relationships.
- The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?

• A. Process Full
• B. Process Clear
• C. Process Add
• D. Process Data
• E. Process Default

You are designing a SQL Server Analysis Services (SSAS) cube.You need to create a measure to count unique customers.What should you do?

• A. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension.
• B. Add a measure that uses the LastNonEmpty aggregate function. Use a regular relationship between the time dimension and the measure group.
• C. Create a dimension. Then add a cube dimension and link it several times to the measure group.
• D. Create several dimensions. Add each dimension to the cube.

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.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010
• B. a tabular project that uses the DirectQuery query mode
• C. a tabular project that uses the In-Memory query mode
• D. a multidimensional project that uses the ROLAP storage mode
• E. a multidimensional project that uses the MOLAP storage mode