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

Questions 21–25

1. 21application · medium

   A company runs an Azure SQL Managed Instance and needs to gather performance metrics for a custom monitoring dashboard. The dashboard must include CPU usage, memory usage, storage I/O, and query-level execution statistics. The administrator wants to use a single, unified monitoring solution that can collect and query these metrics alongside other Azure resources. Which source should the administrator use?

   • ASQL Server Profiler
   • BDynamic Management Views (DMVs)
   • CAzure Monitor Logs (Log Analytics)
   • DAzure Monitor Metrics
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   When analyzing performance metrics for an Azure SQL database, which metric would most directly indicate a potential blocking or concurrency issue?

   • AData space used
   • BNumber of indexes
   • CWait statistics
   • DBackup size
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A database administrator notices that the average CPU usage of an Azure SQL Database has increased from 30% to 60% over the past month, but the workload volume has not changed. The database is still within its allocated resources. The administrator wants to determine whether this is a performance regression or a normal variation. What should the administrator do first?

   • AIncrease the service tier to provide more resources.
   • BCompare the current metrics against the established baseline for the same time of day and day of week.
   • CRebuild all indexes to improve performance.
   • DIgnore the increase because the database is within its resource limits.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   A database administrator is troubleshooting a performance issue in an Azure SQL Database. The administrator suspects that a specific query is causing blocking and wants to see the live execution plan and the progress of the query. The administrator is using SQL Server Management Studio (SSMS). Which feature should the administrator use?

   • ASQL Server Profiler
   • BLive Query Statistics
   • CAzure Monitor Workbooks
   • DQuery Performance Insight
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A database administrator is analyzing performance metrics for an Azure SQL Database. The administrator notices that the average CPU usage is 50%, but the 95th percentile is 95%. The database is experiencing occasional performance spikes that are not reflected in the average. The administrator needs to determine whether these spikes are a cause for concern. What should the administrator do?

   • AIncrease the service tier to eliminate the spikes.
   • BReduce the monitoring granularity to smooth out the spikes.
   • CInvestigate the spikes by correlating them with specific queries or events.
   • DIgnore the spikes because the average CPU usage is within acceptable limits.
   Reveal Solution Discussion Select an answer first