Home » Microsoft » DP-200 v.2 » 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
Correct Answer: A
Explanation/Reference:
Explanation:
Scenario: The query performance of Race Central must be stable, and the administrative time it takes to perform optimizations must be minimized. sp_updatestats 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.
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-updatestats-transact-sql?view=sql-server-ver15