A database administrator needs to capture detailed information about a specific performance problem in an Azure SQL Database. The problem occurs intermittently and the administrator wants to capture the exact sequence of events leading up to the issue. The administrator also wants to minimize the performance overhead of the monitoring. What should the administrator use?

SQL Server Profiler with a trace template.

Extended Events with a ring buffer target.

Dynamic management views (DMVs) to query current activity.

Azure Monitor metrics with a high-frequency alert.

An organization needs to capture detailed information about deadlocks in an Azure SQL Database to troubleshoot recurring deadlock errors. The administrator wants to capture the deadlock graph and the exact T-SQL statements involved. The solution must have minimal performance overhead and must be easy to enable and disable. Which approach should the administrator use?

Enable the system_health Extended Events session and query the deadlock graph from the ring buffer.

Create a custom Extended Events session that captures the sqlserver.lock_deadlock event and includes the sql_text action.

Use Azure Monitor to collect deadlock graphs from the database.

Enable SQL Server Profiler to capture deadlock events.

A company runs an Azure SQL Database with a workload that has predictable peaks and valleys. The database administrator wants to optimize performance while minimizing cost. The administrator has identified that the database is over-provisioned during off-peak hours. What should the administrator do to balance performance and cost?

Set up autoscaling to automatically scale the database based on workload.

Manually scale the database up during peak hours and down during off-peak hours.

Use elastic pool to share resources among multiple databases.

Use the serverless compute tier to automatically scale compute based on demand.

A retail company runs a mission-critical Azure SQL Database. The database administrator wants to establish a performance baseline to compare against future metrics. The database experiences variable load throughout the day, with peak traffic during business hours and low activity at night. The administrator needs a baseline that accurately represents normal operating conditions. Which approach should the administrator take?

Capture metrics during a two-week period that includes both peak and off-peak hours, then calculate average and percentile values.

Use the default metrics from the Azure portal without additional data collection.

Capture metrics only during the busiest hour of the day to establish a worst-case baseline.

Capture metrics for one full day during a holiday when the database is idle.

A database administrator wants to establish a performance baseline for an Azure SQL database. Which action best describes the purpose of creating this baseline?

To replace the need for ongoing performance monitoring

To capture a snapshot of normal performance metrics to compare against future measurements

To automatically adjust database settings to optimize performance

To set a fixed performance level that the database must always achieve

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 1

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

Part of the Monitor, configure, and optimize database resources domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

6concepts

20–25%of the exam

Questions 31–35

31application · medium
A database administrator needs to capture detailed information about a specific performance problem in an Azure SQL Database. The problem occurs intermittently and the administrator wants to capture the exact sequence of events leading up to the issue. The administrator also wants to minimize the performance overhead of the monitoring. What should the administrator use?
Select an answer first
32application · medium
An organization needs to capture detailed information about deadlocks in an Azure SQL Database to troubleshoot recurring deadlock errors. The administrator wants to capture the deadlock graph and the exact T-SQL statements involved. The solution must have minimal performance overhead and must be easy to enable and disable. Which approach should the administrator use?
Select an answer first
33expert · hard
A company runs an Azure SQL Database with a workload that has predictable peaks and valleys. The database administrator wants to optimize performance while minimizing cost. The administrator has identified that the database is over-provisioned during off-peak hours. What should the administrator do to balance performance and cost?
Select an answer first
34application · medium
A retail company runs a mission-critical Azure SQL Database. The database administrator wants to establish a performance baseline to compare against future metrics. The database experiences variable load throughout the day, with peak traffic during business hours and low activity at night. The administrator needs a baseline that accurately represents normal operating conditions. Which approach should the administrator take?
Select an answer first
35foundation · easy
A database administrator wants to establish a performance baseline for an Azure SQL database. Which action best describes the purpose of creating this baseline?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

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

Questions 31–35

A database administrator wants to establish a performance baseline for an Azure SQL database. Which action best describes the purpose of creating this baseline?

Keep studying — Monitor, configure, and optimize database resources