Which command should you use to assist you?

You work as a database administrator for ABC.com. The network contains a SQL Server 2008
database server named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role.
You receive an instruction from the CIO to enhance the performance of queries on ABC-DB05. To
accomplish this task you decide to make use of the Dynamic Management View (DMV).
Which command should you use to assist you?

You work as a database administrator for ABC.com. The network contains a SQL Server 2008
database server named ABC-DB05, which hosts the SQL Server Analysis Services (SSAS) role.
You receive an instruction from the CIO to enhance the performance of queries on ABC-DB05. To
accomplish this task you decide to make use of the Dynamic Management View (DMV).
Which command should you use to assist you?

A.
The Discover_Commands should be used.

B.
The ProcessIndex command should be used.

C.
The taskrun.exe command should be used.

D.
The dtutil command should be used.



Leave a Reply 0

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