DP-203 · Question #256
DP-203 Question #256: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #256. The question stem and answer options stay visible for context.
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?
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.