Which processing option should you use?

HOTSPOT
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was
developed with default settings.
The model has one cube and the cube has one measure group. The measure group is
based on a very large fact table and is partitioned by month. The fact table is incrementally
loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing
time.
Which processing option should you use? (To answer, select the appropriate option in the answer area.)

HOTSPOT
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was
developed with default settings.
The model has one cube and the cube has one measure group. The measure group is
based on a very large fact table and is partitioned by month. The fact table is incrementally
loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing
time.
Which processing option should you use? (To answer, select the appropriate option in the answer area.)

Answer:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Carlos Escobar

Carlos Escobar

Process ADD

Ralph

Ralph

Process add, as the question suggests, we should quickly process only added data, we don’t care about any updates and so on…