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.)

You need to implement security in the cube to limit the sites visible to each user.
What should you do?

• A. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
• B. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
• C. Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
• D. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.

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. Add an indicator to the table.
• B. Use an expression for the Style property of the vineyard text box.
• C. Use an expression for the TextDecoration property of the vineyard text box.
• D. Use an expression for the Font property of the vineyard text box.
• E. Use an expression for the Color property of the vineyard text box.

After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?

• A. In when the report is initially run, select Show.
• B. In When the report is initially run, select Hide.
• C. In When the report is initially run, select Show or hide based on an expression. Se: The expression to =NOT (GlobalslRenderFormat.IsInteractive)
• D. In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalsIRenderFormaUsInteractive).

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. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False
• 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. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option.
• D. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option.