Exam 70-764 topic 2 question 13 discussion

Actual exam question from Microsoft's 70-764

Question #: 13
Topic #: 2

You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistic updates are disabled.
Uses report that some Microsoft SQL Server Reporting Service (SSRS) queries take a long time to run. You determine that the issue is caused by stale statistics for Index1.
You need to update the statistics for the index.
What should you do?

A. Run the system stored procedure sp_updatestats.
B. Reorganize the index.
C. Set the value of the Database Read-Only property to True.
D. Set the value of the Auto Create Incremental Statistics property to True.

Show Suggested Answer

Suggested Answer: A 🗳️
sp_updatestats runs UPDATE STATISTICS against all user-defined and internal tables in the current database. 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.
Note: UPDATE STATISTICS would be a better option as it updates query optimization statistics on a table or indexed view, but it is not an option here.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestats-transact-sql

by JorgePabloF at April 25, 2020, 2:18 a.m.