Monitor Resource Activity and Performance DP-300 Practice Questions (Page 8)

Questions 36–38

1. 36expert · hard

   A database administrator is establishing a performance baseline for a new Azure SQL Database that will support a seasonal business. The workload is highly variable: heavy during the holiday season and light during the rest of the year. The administrator needs to set up monitoring to detect anomalies that could indicate performance issues. Which approach is most appropriate?

   • AUse the Azure portal's default metrics as the baseline.
   • BEstablish a single baseline based on the first month of operation and use it for the entire year.
   • CEstablish separate baselines for peak and off-peak seasons and use them accordingly.
   • DEstablish a baseline only during the holiday season to capture the most demanding workload.
   Reveal Solution Discussion Select an answer first
2. 37application · medium

   A company runs an Azure SQL Database used by a customer-facing application. The database has been in production for six months. The team wants to detect gradual performance degradation before users complain. They plan to compare current metrics against a historical reference. What should they do first?

   • ASet alerts on CPU and DTU usage at 80% to catch immediate spikes.
   • BConfigure a diagnostic setting to stream all metrics to a Log Analytics workspace for ad-hoc analysis.
   • CCreate a baseline by collecting metrics during a typical business week, then set alerts based on deviations from that baseline.
   • DEnable automatic tuning to adjust indexes and query plans based on current workload patterns.
   Reveal Solution Discussion Select an answer first
3. 38application · medium

   An Azure SQL Database shows high CPU usage (90%) during business hours. The database administrator checks the Query Performance Insight and finds that a single query is responsible for 70% of the CPU time. The query has a missing index. What should the administrator do to address the performance issue?

   • ACreate the missing index and monitor the CPU usage to confirm the improvement.
   • BSet an alert to notify the team when CPU exceeds 80%.
   • CScale up the database to a higher service tier to provide more CPU capacity.
   • DKill the query every time it appears in the Query Performance Insight.
   Reveal Solution Discussion Select an answer first