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?

• A. Ensure that the measure group measures only use semiadditive aggregation functions.
• B. Implement the cube as a local cube.
• C. Ensure that the measure group measures only use nonadditive aggregation functions
• D. Implement the linked measure group as a local measure group.

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?

• A. Use an expression for the Color property of the vineyard text box.
• B. Use an expression for the Font property of the vineyard text box.
• C. Add an indicator to the table.
• D. Use an expression for the Style property of the vineyard text box.
• E. Use an expression for the TextDecoration property of the vineyard text box.

You need to configure Library1 to support the planned self-service reports.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.

• A. the Report Builder report content type
• B. the Report Builder Model content type
• C. the PowerPivot Gallery Document content type
• D. the Report content type

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description, Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color.
You need to modify the report so that users can sort products by the Price column.
What should you do?

• A. Set the SortExpression property to =Fields!Price. Value for the Price text box.
• B. In the Expression dialog box for the Price text box. enter the =SortByFieldslPrice, Value expression.
• C. Set the SortExpression property to =Fields!Price. Name for the Price text box.
• D. Add a group for the Price field.