HOTSPOT
You create a new report in SQL Server Data Tools (SSDT). The report queries a Microsoft Azure SQL Database database table.
In a report table showing sales by cities, you need to enable users to interactively drill through to another report to show details of the customer sales within a chosen city.
Which text box property page should you use? (To answer, select the appropriate tab in the answer area.)

You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the SalesAmount measure is four digits. You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?

• A. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new column.
• B. Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.
• C. Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00
• D. Use the FormatString measure property to format SalesAmount as Currency.
• E. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new query.

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. Set the StorageMode property of the linked measure group to Rolap.
• B. Set the Type property of the partition's measure group to Forecast.
• C. Implement the local measure group as a linked measure group.
• D. Implement the linked measure group as a local measure group.

You need to configure per-user security authentication for reporting against the Sales cube.
What should you do? (Each correct answer presents part of the complete solution. Choose all that apply.)

• A. Configure account delegation.
• B. Enable forms-based authentication.
• C. Enable mixed-mode authentication.
• D. Create Service Principal Names (SPNs).

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project.
You identify that a dimension, which has a large number of attributes, is issuing a separate (SELECT DISTINCT) query for each attribute even though they all come from a single database table. The table does not have a large number of rows.
You need to configure the processing of the dimension to issue only a single SQL query to the underlying database, and processing must continue if any errors are encountered.
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.)