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.
Question
Options
- AProcess Clear
- BProcess Data
- CProcess Add
- DProcess Full
- EProcess Default
How the community answered
(29 responses)- B90% (26)
- C3% (1)
- D7% (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.
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.
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.
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.
Process Full rebuilds all objects including hierarchies, relationships, and calculated columns, violating the second and third requirements.
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
Community Discussion
No community discussion yet for this question.