ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 155 - DP-300 discussion

Report
Export

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies that several tables are missing indexes.

You need to ensure that indexes are created for the tables.

What should you do?

A.
Run the DBCC SQLPERF command.
Answers
A.
Run the DBCC SQLPERF command.
B.
Run the DBCC DBREINDEX command.
Answers
B.
Run the DBCC DBREINDEX command.
C.
Modify the automatic tuning settings for db1.
Answers
C.
Modify the automatic tuning settings for db1.
D.
Modify the Query Store settings for db1.
Answers
D.
Modify the Query Store settings for db1.
Suggested answer: C

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-overview

asked 02/10/2024
Elham Alasmari
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first