which XML for Analysis (XMLA) command should you choose?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an email from your company CIO, according to his requirement, he wants the data in a partition
to be refreshed every two hours. He has assigned this task to you. You have to implement
the incremental processing strategy. Of the following options, which XML for Analysis
(XMLA) command should you choose?

You are a database developer and you have about two years experience in creating
business Intelligence (BI) by using SQL Server2008. Now you are employed in a company
named NaproStar which uses SQL Server2008. You work as the technical support. Now you
are in charge of a SQL Server 2008 Analysis Services (SSAS) database. Now you get an email from your company CIO, according to his requirement, he wants the data in a partition
to be refreshed every two hours. He has assigned this task to you. You have to implement
the incremental processing strategy. Of the following options, which XML for Analysis
(XMLA) command should you choose?

A.
You should choose ProcessFull

B.
You should choose ProcessIndex

C.
You should choose ProcessAdd.

D.
You should choose ProcessData



Leave a Reply 0

Your email address will not be published. Required fields are marked *