070-464 Real Exam Prep DEMO

Question 8: You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
What should you use?
To answer, drag the appropriate function to the correct management task in the answer area.
(Answer choices may be used once, more than once, or not at all.)
Correct Answer:
Explanation:
Box 1: sys.dm_db_index_usage_stats
sys.dm_db_index_usage_stats shows you how many times the index was used for user queries. It
returns counts of different types of index operations and the time each type of operation was last
performed in SQL Server.
Box 2: sys.dm_db_missing_index_details
sys.dm_db_missing_index_details returns detailed information about a missing index; for example, it
returns the name and identifier of the table where the index is missing, and the columns and column
types that should make up the missing index.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-
management-views/sys-dm-db-index-usage-stats-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-indexes-
transact-sql
https://technet.microsoft.com/en-us/library/ms345524(v=sql.105).aspx