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?

Simulated

Create a scheduled Azure Automation runbook to update statistics on all tables in the Azure Synapse Analytics database.

Manually update statistics on all tables in the Azure Synapse Analytics database whenever you notice performance issues.

Enable automatic statistics updates on all tables in the Azure Synapse Analytics database.

Use Azure Monitor to create alerts based on query performance metrics and manually update statistics when alerts are triggered.

Microsoft Azure Data Engineer Associate - DP-203