Answer-first summary for fast verification
Answer: Enable automatic statistics updates on all containers in the Azure Cosmos DB database.
To ensure accurate and up-to-date statistics in an Azure Cosmos DB database, you should enable automatic statistics updates on all containers. 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 Cosmos DB 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 containers in the Azure Cosmos DB database.
B
Manually update statistics on all containers in the Azure Cosmos DB database whenever you notice performance issues.
C
Enable automatic statistics updates on all containers in the Azure Cosmos DB database.
D
Use Azure Monitor to create alerts based on query performance metrics and manually update statistics when alerts are triggered.
No comments yet.