Home » Microsoft » 70-466 v.2 » Which processing mode should you use?
You have a tabular model hosted in SQL Server Analysis Services (SSAS).
You need to add new rows to an existing table. The solution must load only the new rows to the table.
Which processing mode should you use?
A. Process Data
B. Process Full
C. Process Add
D. Process Clear
E. Process Default
Correct Answer: C
Explanation/Reference:
Explanation:
Process Add: This processing mode is available for Dimensions, Measure Groups and Partitions. When this processing mode is applied to Dimensions, it adds new members into the dimensions from the underlying database and updates the descriptions of the attributes. When this processing mode is Groups and Partitions, it adds the incremental fact data into the cube and processes only the affected partitions.
Incorrect Answers:
B: Process Data: This processing mode is available for Dimensions, Measure Groups, Partitions, and Cubes. This processing mode is used to process the data without actually building or creating the aggregations and indexes.
References: https://www.mssqltips.com/sqlservertip/2756/ssas-interview-questions-on-deployment-processing-querying-and-accessing/