What action below should be performed?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008 Analysis Services (SSAS).
To meet the business development, you create a (SSAS) solution and enable proactive
caching for a partition. Now you get an order from your company CIO, according to his
requirement, while updating the multidimensional storage, you should make sure that you
can use SSAS to query relational data.
What action below should be performed?

You are a database developer and you have about two years experience in creating
business intelligence (BI) solutions by using SQL Server2008. Now you are employed in a
company which is named NaproStar and work as the technical support for the company
which uses SQL Server2008 Analysis Services (SSAS).
To meet the business development, you create a (SSAS) solution and enable proactive
caching for a partition. Now you get an order from your company CIO, according to his
requirement, while updating the multidimensional storage, you should make sure that you
can use SSAS to query relational data.
What action below should be performed?

A.
To achieve this goal, the OnlineMode property for the partition should be set to
OnCacheComplete

B.
To achieve this goal, the ProcessingMode property for the partition should be set to
LazyAggregations.

C.
To achieve this goal, the OnlineMode property for the partition should be set to
Immediate.

D.
To achieve this goal, the ProcessingMode property for the partition should be set to
Regular

Explanation:

ProcessingMode
Defines the place in the cube processing at which data becomes available to users. By
default, ProcessingMode is set to Regular, and users cannot access the measure group until
processing is complete. If ProcessingMode is set to LazyAggregations, data is accessible as
soon as it is processed, but processing takes longer.



Leave a Reply 1

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


wuhoga

wuhoga

What the hell is such DB specific quesion doing in ASP.NET MVC exam?!