Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are responsible for 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.
