You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database. The ProcessingOption property for the project is set to Do Not Process. Several calculated…

To process newly added data on the production server for a deployed tabular project, follow these steps: 1. Open the project in SQL Server Data Tools (SSDT). 2. On the Model designer, select the table. 3. Right-click the table and then select Process Table. (This processes only…

Configure and maintain an analysis services database

Question

You are developing a SQL Server Analysis Services (SSAS) tabular project based on a SQL Azure database. The ProcessingOption property for the project is set to Do Not Process. Several calculated columns have been added to a table. The project has been deployed to the production server. You need to ensure that newly added data is processed on the production server. 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.)

Explanation

To process newly added data on the production server for a deployed tabular project, follow these steps:

Open the project in SQL Server Data Tools (SSDT).
On the Model designer, select the table.
Right-click the table and then select Process Table. (This processes only the selected table and its new data).
In the Model menu, select Process and then select Process All. (This processes the entire model, including all tables and any newly added data.)

Topics

#tabular processing#deployment#production server#ProcessingOption

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice