nerdexam
Microsoft

70-466 · Question #137

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

The correct answer is B. Process Data. Process Data in SSAS loads raw data into partitions or tables without rebuilding hierarchies, relationships, or recalculating calculated columns, matching all three stated requirements.

Configure and maintain an analysis services database

Question

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?

Options

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

How the community answered

(29 responses)
  • B
    90% (26)
  • C
    3% (1)
  • D
    7% (2)

Why each option

Process Data in SSAS loads raw data into partitions or tables without rebuilding hierarchies, relationships, or recalculating calculated columns, matching all three stated requirements.

AProcess Clear

Process Clear removes all data from a partition or table but does not load new data, so it fails the first requirement of loading data.

BProcess DataCorrect

Process Data performs only the data-loading step - it populates partitions or tables with source data but intentionally skips the rebuild of hierarchies, relationships, and recalculation of calculated columns. This makes it the correct choice when you need to refresh data while avoiding the overhead of a full rebuild, exactly as specified in the requirements.

CProcess Add

Process Add incrementally appends new rows to an existing partition without clearing old data; it does not match the general data-loading intent and still triggers some recalculation steps.

DProcess Full

Process Full rebuilds all objects including hierarchies, relationships, and calculated columns, violating the second and third requirements.

EProcess Default

Process Default detects object state and performs whatever processing is needed to reach a fully processed state, which may include rebuilding hierarchies and recalculating columns, violating the stated requirements.

Concept tested: SSAS tabular processing mode - Process Data behavior

Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/process-database-table-or-partition-analysis-services

Topics

#SSAS Process Data#partition processing#processing modes#incremental processing

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice