A company runs an Azure SQL Database that supports a seasonal business. The workload is light for most of the year but spikes during the holiday season. The database administrator wants to establish a baseline to detect performance issues during the holiday season. The administrator has historical data from the previous year. What is the best approach?

Use the current year's off-peak data as the baseline.

Use the previous year's holiday season data as the baseline for the upcoming season.

Set alerts based on the service tier's maximum capacity.

Use the average of the entire year as the baseline.

A database administrator needs to monitor an Azure SQL Database for deadlocks. The administrator wants to capture the deadlock graph and the queries involved. The administrator also wants to store the data for later analysis. What should the administrator use?

Azure Monitor alerts for deadlock count.

Extended Events with a file target to capture the deadlock_graph event.

Dynamic management views (DMVs) to query deadlock history.

Query Performance Insight to view deadlock information.

When establishing a performance baseline for an Azure SQL database, which period of data collection would provide the most representative baseline?

A 5-minute window during off-peak hours

A 1-week period during a major application release

A 1-hour period during a known performance issue

A 24-hour period that includes both peak and off-peak activity

An Azure SQL Database shows high CPU usage (85%) consistently. The database administrator has a baseline that shows typical CPU usage is 30%. The administrator also notices that a new query was deployed last week. The query plan shows a large memory grant. What is the most likely cause of the high CPU usage?

The database is experiencing lock contention from concurrent transactions.

The new query is causing excessive memory grants, leading to CPU pressure.

The database service tier is too low for the current workload.

The database is running out of storage space.

What is the primary purpose of Extended Events in Azure SQL Database?

To capture detailed database activity and performance data for analysis

To replicate data to another region

To back up the database automatically

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 1

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

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 26–30

26expert · hard
A company runs an Azure SQL Database that supports a seasonal business. The workload is light for most of the year but spikes during the holiday season. The database administrator wants to establish a baseline to detect performance issues during the holiday season. The administrator has historical data from the previous year. What is the best approach?
Select an answer first
27application · medium
A database administrator needs to monitor an Azure SQL Database for deadlocks. The administrator wants to capture the deadlock graph and the queries involved. The administrator also wants to store the data for later analysis. What should the administrator use?
Select an answer first
28foundation · easy
When establishing a performance baseline for an Azure SQL database, which period of data collection would provide the most representative baseline?
Select an answer first
29expert · hard
An Azure SQL Database shows high CPU usage (85%) consistently. The database administrator has a baseline that shows typical CPU usage is 30%. The administrator also notices that a new query was deployed last week. The query plan shows a large memory grant. What is the most likely cause of the high CPU usage?
Select an answer first
30foundation · easy
What is the primary purpose of Extended Events in Azure SQL Database?
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 6)

Questions 26–30

A database administrator needs to monitor an Azure SQL Database for deadlocks. The administrator wants to capture the deadlock graph and the queries involved. The administrator also wants to store the data for later analysis. What should the administrator use?

When establishing a performance baseline for an Azure SQL database, which period of data collection would provide the most representative baseline?

What is the primary purpose of Extended Events in Azure SQL Database?

Keep studying — Monitor, configure, and optimize database resources