Exam 70-767 topic 1 question 5 discussion

Actual exam question from Microsoft's 70-767

Question #: 5
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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a data warehouse that stores information about products, sales, and orders for a manufacturing company. The instance contains a database that has two tables named SalesOrderHeader and SalesOrderDetail. SalesOrderHeader has 500,000 rows and SalesOrderDetail has 3,000,000 rows.
Users report performance degradation when they run the following stored procedure:

You need to optimize performance.
Solution: You run the following Transact-SQL statement:

Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
Microsoft recommend against specifying 0 PERCENT or 0 ROWS in a CREATE STATISTICS..WITH SAMPLE statement. When 0 PERCENT or ROWS is specified, the statistics object is created but does not contain statistics data.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-statistics-transact-sql

by Lukis92 at Oct. 11, 2020, 5:02 p.m.

Comments

Submit Cancel

larajane

4 years, 5 months ago

The answer is NO. It's correct.

upvoted 1 times

...

Lukis92

4 years, 8 months ago

We should not specify 0 PERCENT or 0 Rows to update the statistics because it just updates the statistics object, but it does not contain statistics data. Source: https://www.sqlshack.com/sql-server-statistics-and-how-to-perform-update-statistics-in-sql/

upvoted 1 times

julie2020

4 years, 5 months ago

So, What is the answer?

upvoted 1 times

...