What should you do?

You manage a large Microsoft Azure SQL database. The database contains data that changes several thousand times each day.
You need to ensure that the performance of the database stays consistent when the data changes.
What should you do?
A. Update the statistics of all the tables in the database.
B. Clear the procedure cache of the database.
C. Run a consistency check on the tables in the database.
D. Enable Extended Events for the server that contains the database.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.