
Ultimate access to all questions.
As part of your monitoring duties, you need to update statistics about data across a system to ensure that query performance remains optimal. Describe the steps you would take to update these statistics, including the tools you would use, the frequency of updates, and how you would ensure that these updates do not negatively impact system performance.
A
Use SQL Server Management Studio, update statistics weekly, and schedule updates during off-peak hours.
B
Use Azure Data Catalog, update statistics daily, and perform updates in real-time.
C
Use Azure Data Lake Analytics, update statistics monthly, and perform updates in batches.
D
Use Azure Cosmos DB, update statistics hourly, and perform updates asynchronously.