70-448 · Question #59
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Currently you are employed in a company named NaproStar which…
The correct answer is A. You should choose to use Query Subcube. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Currently you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database. You get report from users saying that some queries run slowly. As the technical support, you have to check and identify the problem. You intend to use SQL Profiler to troubleshoot query performance. Of the following trace events, which one should you choose?
Options
- AYou should choose to use Query Subcube
- BYou should choose to use MDX Script End.
- CYou should choose to use Get Data from Cache
- DYou should choose to use Query Cube End
How the community answered
(62 responses)- A79% (49)
- B3% (2)
- C13% (8)
- D5% (3)
Community Discussion
No community discussion yet for this question.