Which of the following steps should you include in your solution?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). The
company has a large data warehouse named CorpDW.
You need to create an SSAS cube to query CorpDW. The cube will use the
multidimensional OLAP (MOLAP) storage mode.
You need to recommend a solution that will automate the collection of aggregation tuning
workloads. Any manual tuning of aggregations must minimize the performance impact of
queries that have already been tuned and the effort required must be minimized.
Which of the following steps should you include in your solution?

You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A server named ABC-SSAS01 runs SQL Server 2012 Analysis Services (SSAS). The
company has a large data warehouse named CorpDW.
You need to create an SSAS cube to query CorpDW. The cube will use the
multidimensional OLAP (MOLAP) storage mode.
You need to recommend a solution that will automate the collection of aggregation tuning
workloads. Any manual tuning of aggregations must minimize the performance impact of
queries that have already been tuned and the effort required must be minimized.
Which of the following steps should you include in your solution?

A.
Set up multiple partitions.

B.
Generate aggregations using the Usage-Based Optimization Wizard.

C.
Enable query logging in SSAS.

D.
Run the Aggregation Design Wizard on each partition.

E.
Replace the current aggregation design with the results of the wizard.

F.
Merge the results of the wizard with the current aggregation design.

Explanation:



Leave a Reply 3

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


Mahmoud Ibrahim

Mahmoud Ibrahim

ok

MCSE-467

MCSE-467

Enable query logging is essential, agree with the answers.