nerdexam
Microsoft

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.

Build a tabular data model

Question

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?

Options

  • AProcess Data
  • BProcess Full
  • CProcess Add
  • DProcess Clear
  • EProcess Default

How the community answered

(38 responses)
  • A
    3% (1)
  • C
    92% (35)
  • D
    3% (1)
  • E
    3% (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.

AProcess Data

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.

BProcess Full

Process Full drops all existing data and aggregations and completely reprocesses the object from scratch, which is the opposite of an incremental load.

CProcess AddCorrect

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.

DProcess Clear

Process Clear removes all processed data from the object but does not load any new data, leaving the object empty.

EProcess Default

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

#tabular model#Process Add#incremental processing#SSAS processing modes

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice