70-466 · Question #152
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 shou
The correct answer is C. Process Add. SSAS Process Add mode appends new rows to an existing partition without clearing or reprocessing existing data, making it ideal for incremental loads.
Question
Options
- AProcess Data
- BProcess Full
- CProcess Add
- DProcess Clear
- EProcess Default
How the community answered
(38 responses)- A3% (1)
- C92% (35)
- D3% (1)
- E3% (1)
Why each option
SSAS Process Add mode appends new rows to an existing partition without clearing or reprocessing existing data, making it ideal for incremental loads.
Process Data reloads all data for the object by first dropping all existing aggregations and then reprocessing all rows from the source, not just new ones.
Process Full drops all existing data and aggregations and completely reprocesses the object from scratch, which is the opposite of an incremental load.
Process Add is specifically designed to add new members to an existing dimension or new rows to a partition without discarding existing processed data. It reads only the new records from the data source and merges them into the existing structure, satisfying the requirement to load only new rows.
Process Clear removes all processed data from the object but does not load any new data, leaving the object empty.
Process Default determines the appropriate processing type based on the object's current state, but it does not guarantee that only new rows will be added - it could trigger a full reprocess.
Concept tested: SSAS incremental partition processing with Process Add
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/processing-options-and-settings-ssas
Topics
Community Discussion
No community discussion yet for this question.