What should you implement to optimize SQL Database for Race Central to meet the technical requirements?

What should you implement to optimize SQL Database for Race Central to meet the technical requirements?
A . the sp_update stored procedure
B . automatic tuning
C . Query Store
D . the dbcc checkdb command

View Answer

Answer: A

Explanation:

Scenario: The query performance of Race Central must be stable, and the administrative time it takes to

perform optimizations must be minimized.

sp_update updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.