DRAG DROPYou 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:
Identify unused indexes.
Identify indexes that need to be defragmented.
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.)
Select and Place:

Answer:

Explanation:
Note:
* 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.
* sys.dm_db_index_physical_stats
Returns size and fragmentation information for the data and indexes of the specified table or view.
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