Exam 70-764 topic 1 question 21 discussion

Actual exam question from Microsoft's 70-764

Question #: 21
Topic #: 1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
You have an on-premises server that runs Microsoft SQL Server 2016 Standard Edition.
You need to identify missing indexes.
What should you use?

A. Activity Monitor
B. Sp_who3
C. SQL Server Management Studio (SSMS) Object Explorer
D. SQL Server Data Collector
E. SQL Server Data Tools (SSDT)
F. SQL Server Configuration Manager

Show Suggested Answer

Suggested Answer: D 🗳️
Data Collector can gather performance information from multiple SQL Server instances and store it in a single repository. It has three built-in data collecting specifications (data collectors) designed to collect the most important performance metrics. The information collected by default is about disk usage, query statistics, and server activity.
The Query Statistics data collection set collects information about query statistics, activity, execution plans and text on the SQL Server instance.
Missing indexes can be found with the execution plans.
References: https://www.sqlshack.com/sql-server-performance-monitoring-data-collector/

by San98 at Oct. 16, 2019, 12:56 p.m.

Comments

Submit Cancel

mrn0107

5 years, 6 months ago

D is correct. You can not find missing index inside object explorer of SSMS. You can start a new query and execute DMV-s to find missing index, but that is not the case here.

upvoted 1 times

...

TheSwedishGuy

5 years, 6 months ago

Since SQL Server Data Collector has execution plans for queries, it's possible to identify the missing indexes.

upvoted 1 times

...

San98

5 years, 9 months ago

I think the correct answer is C

upvoted 2 times

...