You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method. In order to…

The correct answer is A. You should utilize ProcessAdd for Analysis (XMLA) command. BEST PRACTICES CONSIDER FULLY PROCESSING THE ENTIRE DATABASE fully processing the entire SSAS database is the cleanest and easiest solution to process all objects in the database, but it is not necessarily the fastest. Because SSAS processes objects in parallel and has a very…

Troubleshoot and Optimize Databases

Question

You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com. In order to update data in a partition each hour you should run the incremental processing method. In order to solve the problem, which is the correct answer?

Options

AYou should utilize ProcessAdd for Analysis (XMLA) command
BYou should utilize default command for Analysis (XMLA)
CYou should utilize ProcessNone for Analysis (XMLA) command
DYou should utilize ProcessView for Analysis (XMLA) command

How the community answered

(48 responses)

A
77% (37)
B
13% (6)
C
4% (2)
D
6% (3)

Explanation

BEST PRACTICES CONSIDER FULLY PROCESSING THE ENTIRE DATABASE fully processing the entire SSAS database is the cleanest and easiest solution to process all objects in the database, but it is not necessarily the fastest. Because SSAS processes objects in parallel and has a very effi cient processing architecture that can handle some 10,000 records per second, you might fi nd that you can process even large cubes within a reasonable time frame. Consider more advanced processing options, such as incremental processing (ProcessUpdate), only when fully processing the database is not an option.

Topics

#SSAS#partition processing#ProcessAdd#incremental processing

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice