Home » Microsoft » 70-466 v.2 » Which processing mode should you use?
You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
The processing must load data into partitions or tables.
The processing must not rebuild hierarchies or relationships. The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?
A. Process Clear
B. Process Data
C. Process Add
D. Process Full
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 applied to Measure 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/
