Microsoft
70-466 · Question #77
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 ba
See the full explanation below for the reasoning.
Configure and maintain an analysis services database
Question
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 no 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.)
Topics
#SSAS partition processing#processing options#incremental load#multidimensional BISM
Community Discussion
No community discussion yet for this question.