Implementing Data Models and Reports with Microsoft SQL Server — Question 1

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?

Answer options

• A. Process Clear
• B. Process Data
• C. Process Add
• D. Process Full
• E. Process Default

Correct answer: C

Explanation

The correct answer is C, Process Add, as it allows for new data to be loaded into existing partitions without affecting hierarchies, relationships, or recalculating calculated columns. Options A and D, Process Clear and Process Full, would either remove existing data or rebuild all structures, which does not meet the requirements. Option B, Process Data, does not specifically address the need to avoid recalculating calculated columns, and E, Process Default, does not specify a clear processing approach.