What should you implement to optimize SQL Database for Race Central to meet the technical requirements?
A . the sp_update_statsstored procedure
B . automatic tuning
C . Query Store
D . the dbcc checkdbcommand
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_updatestatsupdates 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.
Incorrect Answers:
D: dbcc checkdchecks the logical and physical integrity of all the objects in the specified database
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestatstransact-sql?view=sql-server-ver15