How should you modify the cube?

You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS).
You have a large cube on ABC-SSAS01. The cube contains a single partition and a single
measure group. The cube contains many millions of rows of data.
You need to modify the cube to cope with the rapidly increasing amount of data.
You plan to configure a staging table that will be used to store only the data that has been
added since the last processing of the cube. The measure group will be partitioned by
month and records from the staging table will be inserted into the relevant partition. Record
deletions or updates will not be included in the staging table.
How should you modify the cube?

You work as a Database Administrator (DBA) at a company named ABC.com.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS).
You have a large cube on ABC-SSAS01. The cube contains a single partition and a single
measure group. The cube contains many millions of rows of data.
You need to modify the cube to cope with the rapidly increasing amount of data.
You plan to configure a staging table that will be used to store only the data that has been
added since the last processing of the cube. The measure group will be partitioned by
month and records from the staging table will be inserted into the relevant partition. Record
deletions or updates will not be included in the staging table.
How should you modify the cube?

A.
By configuring the Process Default option.

B.
By configuring the Process Full option.

C.
By configuring the Process Data option.

D.
By configuring the Process Clear option.

E.
By configuring the Process Add option.

F.
By configuring the Process Index option.

Explanation:



Leave a Reply 1

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


Mahmoud Ibrahim

Mahmoud Ibrahim

E correct