What should you do?

You administer a Microsoft SQL Server 2014 server. You plan to deploy new features to an application.

You need to evaluate existing and potential clustered and non-clustered indexes that will improve performance.

What should you do?
A . Query the sys.dm_db_index_usage_stats DM
C . Query the sys.dm_db_missing_index_details DM
E . Use the Database Engine Tuning Advisor.
F . Query the sys.dm_db_missing_index_columns DM

View Answer

Answer: C

Explanation:

The Microsoft Database Engine Tuning Advisor (DTA) analyzes databases and makes recommendations that you can use to optimize query performance. You can use the Database Engine Tuning Advisor to select and create an optimal set of indexes, indexed views, or table partitions without having an expert understanding of the database structure or the internals of SQL Server.