Question

You work in an Azure Transformational Logics (ATL) company and you have been given the responsibility to create and update query-optimization statistics utilizing the Synapse SQL resources in a dedicated SQL pool.  The following are the guiding principles recommended for updating the statistics during the load process. Which of the following is/are not true?

A. Ensure that every loaded table is having at least 1 statistics object updated

B. Focus on the columns participating in ORDER BY, GROUP BY, JOIN and DISTINCT clauses

C. Update “ascending key” columns like order dates more frequently as these values are not considered/included in the statistics histogram

D. Update static distribution columns more frequently

E. None of these

Answer 1

Correct Answer: D

Reason:-

The below-given guiding principles are recommended to update the statistics during the load process:

Option A is incorrect. It is true that you should ensure that every loaded table is having at least 1 statistics object updated.

Option B is incorrect. The given one is also a guiding principle to update the statistics during the load process.

Option C is incorrect. The given one is also a guiding principle to update the statistics during the load process.

Option D is correct. Rather than more frequently, you need to update static distribution columns less frequently.

Option E is incorrect. Option D describes the wrong principle.