Microsoft Designing Business Intelligence Solutions with Microsoft SQL Server (070-467日本語版) - 070-467日本語 Exam Questions

Explanation

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.
Reference: Analysis Services 2005 Processing Architecture

Explanation

Explanation

Explanation
Box 1:

Box 2:

Box 3:

Explanation
Box 1:

Box 2:

Box 3:

Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view that provides a record of all package executions on the server and, most importantly, it contains [execution_id] - the identifier for each execution and the field to which all other objects herein will be related.