PrepAway - Latest Free Exam Questions & Answers

Which features should you use?

DRAG DROP
Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each
report has several datasets defined with complex Multidimensional Expressions (MDX)
queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the
following requirements:
Monitor query statistics on the production server with as little server overhead as possible.
Gather, replay, and analyze statistics on the test server with as little administrative effort as
possible.
Identify the longest-running queries on both servers.
Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the
answer area. (Use only features that apply.)

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
Box 1:

Box 2:


Leave a Reply