Microsoft
70-466 · Question #137
70-466 Question #137: Real Exam Question with Answer & Explanation
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
Explanation
Process Data in SSAS loads raw data into partitions or tables without rebuilding hierarchies, relationships, or recalculating calculated columns, matching all three stated requirements.
Common mistakes.
- A. 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.
- C. 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.
- D. Process Full rebuilds all objects including hierarchies, relationships, and calculated columns, violating the second and third requirements.
- E. 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
Topics
#SSAS Process Data#partition processing#processing modes#incremental processing
Community Discussion
No community discussion yet for this question.