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

Questions 1–5

1. 1foundation · easy

   Which component of an Extended Events session defines the specific events to capture?

   • AEvent
   • BEvent package
   • CEvent session
   • DTarget
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A database administrator observes that the 'DTU consumption' metric for an Azure SQL database is consistently above 90%. What does this indicate?

   • AThe database is experiencing a network connectivity issue
   • BThe database is likely approaching its resource capacity and may experience performance degradation
   • CThe database is underutilized and can be scaled down
   • DThe database is running perfectly with no need for action
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A database administrator needs to monitor the performance of an Azure SQL Database. The administrator wants to see historical CPU, memory, and I/O metrics alongside query-level details such as wait statistics and query text. Which combination of sources should the administrator use?

   • AAzure Activity Log for resource metrics and SQL Server Profiler for query details.
   • BAzure SQL Analytics for both resource and query metrics, but only for the last 24 hours.
   • CDynamic management views (DMVs) for resource metrics and Azure Monitor for query text.
   • DAzure Monitor metrics for resource-level data and Query Performance Insight for query-level details.
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which Azure service provides a centralized monitoring solution for database watchers to collect and analyze performance data from multiple Azure SQL databases?

   • AAzure Logic Apps
   • BAzure Blob Storage
   • CAzure Monitor
   • DAzure Data Factory
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company runs an Azure SQL Database that supports a global application. The workload varies significantly by time zone, with peak usage in the morning and evening. The database administrator wants to establish a baseline to detect performance anomalies. The administrator has collected metrics for one month. What is the most effective approach to establish the baseline?

   • ASegment the data by hour of day and day of week, then create a baseline for each segment.
   • BCalculate the average CPU, memory, and I/O for the entire month and use those as the baseline.
   • CSet alerts based on the 90th percentile of all metrics.
   • DUse the maximum values from the month as the baseline to ensure the database can handle peak load.
   Reveal Solution Discussion Select an answer first