PrepAway - Latest Free Exam Questions & Answers

Which process option should you choose?

A SQL Server Analysis Services (SSAS) cube containsbillions of rows of data and is rapidly increasingin size.
The cube consists of a single measure group and a single partition. The cube is currently processed by using
the Process Full process option.
You have the following requirements to reduce the cube processing time:
Partition the measure group by month.
Create a staging table that contains only data which is more recent than the last time the cube was
processed.
Do not include data updates or deletions in the staging table.
Insert records from the staging table into the appropriate partition.
You need to change the process option to meet the requirements. Which process option should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.

Hot Area:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:

3 Comments on “Which process option should you choose?


Leave a Reply