You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the Database Engine Tuning Advisor (DTA).
Which of the following is TRUE with regards to DTA? (Choose all that apply.)
A.
DTA is able to add or drop unique indexes or indexes that enforce PRIMARY KEY or UNIQUE
constraints.
B.
DTA is able to analyze databases and makes recommendations that you can use to optimize
query performance.
C.
DTA is able to analyze a database that is set to single-user mode.
D.
Database Engine Tuning Advisor stores tuning session data and other information in the msdb
database.
Explanation: