PrepAway - Latest Free Exam Questions & Answers

Which process option should you choose?

HOTSPOT
A SQL Server Analysis Services (SSAS) cube contains billions of rows of data and is rapidly
increasing in 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.

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
Note:
ProcessAdd
ProcessAdd applies only to dimensions and partitions.
ProcessAdd is a new processing option for dimensions that did not exist in Analysis Services
2000. It essentially optimizes ProcessUpdate for the scenario where only new members are
added. ProcessAdd never deletes or updates existing members. It only adds new members.
The user can restrict the dimension table so that ProcessAdd reads only the new rows.
ProcessAdd for partitions is the equivalent of incremental partition processing in Analysis
Services 2000. The user typically specifies an alternate fact table or a filter condition pointing
to the new rows. ProcessAdd internally creates a temporary partition, processes it with the
specified fact data, and merges it into the target partition.

Analysis Services 2005 Processing Architecture


Leave a Reply