You ma

nage 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 stati

stics 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.

Explanation:

Updating statistic

s ensures that queries compile with up-to-date statistics.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-2017