Answer-first summary for fast verification
Answer: Enable automatic statistics updates on all tables in the Azure Synapse Analytics database.
To ensure accurate and up-to-date statistics in an Azure Synapse Analytics database, you should enable automatic statistics updates on all tables. This will ensure that statistics are updated regularly and automatically, without the need for manual intervention. Option A is not the best approach because it requires manual scheduling and does not guarantee up-to-date statistics. Option B is not efficient and can lead to outdated statistics if not performed regularly. Option D is not the best approach because it relies on alerts and manual updates, which can be time-consuming and may not capture all necessary updates.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with monitoring and updating statistics about data across a system that uses Azure Synapse Analytics for data storage and processing. Which of the following steps should you take to ensure accurate and up-to-date statistics?
A
Create a scheduled Azure Automation runbook to update statistics on all tables in the Azure Synapse Analytics database.
B
Manually update statistics on all tables in the Azure Synapse Analytics database whenever you notice performance issues.
C
Enable automatic statistics updates on all tables in the Azure Synapse Analytics database.
D
Use Azure Monitor to create alerts based on query performance metrics and manually update statistics when alerts are triggered.
No comments yet.