nerdexam
Microsoft

70-466 · Question #112

FactInternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most r

The correct answer is C. Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Data processing option.. Tests knowledge of SSAS processing options to refresh only changed partitions and dimensions while minimizing total processing time.

Configure and maintain an analysis services database

Question

FactInternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time. What should you do?

Exhibit

70-466 question #112 exhibit

Options

  • AProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer cable with the Process Defrag processing option.
  • BProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.
  • CProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Data processing option.
  • DProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.
  • EProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.

How the community answered

(21 responses)
  • B
    5% (1)
  • C
    76% (16)
  • D
    5% (1)
  • E
    14% (3)

Why each option

Tests knowledge of SSAS processing options to refresh only changed partitions and dimensions while minimizing total processing time.

AProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer cable with the Process Defrag processing option.

Process Defrag reorganizes existing data segments but does not reload source data from the source system, so new records would not appear in the model.

BProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.

Process Clear wipes all data from the targeted objects before any reload is performed, forcing a full data reload on those objects and not minimizing processing effort.

CProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Data processing option.Correct

Process Data loads source data into the specified partition and dimension tables without clearing existing data in unaffected partitions, keeping the processing scope minimal. Running Process Data at the database level then synchronizes any dependent aggregations or objects across the model. This two-step approach avoids a costly full reprocess while ensuring the model reflects the latest data.

DProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.

Process Full performs a complete reprocess of every object in the entire database, which is the most expensive option and directly contradicts the requirement to minimize processing time.

EProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.

Process Recalc only recalculates aggregations and attribute hierarchies without loading new source data, so running it as the final step does not ensure new source data is loaded into the database-level objects.

Concept tested: SSAS incremental partition processing options

Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/processing-options-and-settings-analysis-services

Topics

#tabular model processing#Process Data#Process Recalc#partition processing

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice