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 dedica

Question

Options

• AEnsure that every loaded table is having at least 1 statistics object updated
• BFocus on the columns participating in ORDER BY, GROUP BY, JOIN and DISTINCT clauses
• CUpdate "ascending key" columns like order dates more frequently as these values are not
• DUpdate static distribution columns more frequently
• ENone of these

• A
  7% (2)
• B
  14% (4)
• C
  3% (1)
• D
  72% (21)
• E
  3% (1)

Explanation

The below-given guiding principles are recommended to update the statistics during the load 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 Option C is incorrect. The given one is also a guiding principle to update the statistics during the 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. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-statistics#update-

No community discussion yet for this question.