Microsoft Azure Data Engineer Associate - DP-203
Get started today
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.
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.
Simulated
Explanation:
Using SQL Server Management Studio is a practical approach for updating statistics in a SQL-based system. Updating statistics weekly provides a balance between keeping the data fresh and minimizing the impact on system performance. Scheduling updates during off-peak hours ensures that they do not interfere with normal operations.