Exam 70-764 topic 1 question 292 discussion

Actual exam question from Microsoft's 70-764

Question #: 292
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a database that includes a table named Candidate.
You need to update the statistics for a column named Skills in the table and turn off automatic statistics updates for the column.
Solution: You run the following query:

Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
FULLSCAN: Compute statistics by scanning all rows in the table or indexed view. FULLSCAN and SAMPLE 100 PERCENT have the same results.
References: https://technet.microsoft.com/en-us/library/ms187348(v=sql.110).aspx

by SkyNet at Oct. 23, 2019, 3:15 p.m.

Comments

Submit Cancel

SkyNet

Highly Voted 5 years, 9 months ago

The question requires you to "... turn off automatic statistics updates for the column." The solution doesn't include NORECOMPUTE, which turns off the automatic statistics update on a column. I believe the answer should be B. References: https://docs.microsoft.com/en-us/sql/t-sql/statements/update-statistics-transact-sql?view=sql-server-ver15

upvoted 12 times

...

mckmck

Highly Voted 5 years, 7 months ago

I think the B Option is corect. ...and turn off automatic statistics updates for the column. We turn off automatic statistic with NORECOMPUTE. NORECOMPUTE Disable the automatic statistics update option, AUTO_UPDATE_STATISTICS, for the specified statistics. If this option is specified, the query optimizer completes this statistics update and disables future updates. To re-enable the AUTO_UPDATE_STATISTICS option behavior, run UPDATE STATISTICS again without the NORECOMPUTE option or run sp_autostats.

upvoted 8 times

...

TheSwedishGuy

Most Recent 5 years, 5 months ago

Turn off auto updating statistics = NORECOMPUTE. I.e. the correct answer is B.

upvoted 7 times

...