A company runs an Azure SQL Database that supports a line-of-business application. The database administrator wants to establish a performance baseline. The administrator has collected metrics for two weeks. The metrics show that CPU usage is typically between 20% and 40%, with occasional spikes to 60% during month-end reporting. What should the administrator do with this information?

Use the 60% spike as the baseline to ensure the database can handle peak loads.

Document the typical range and the expected spikes, then set alerts for deviations outside that range.

Use the average CPU usage as the baseline and set alerts for any deviation above 40%.

Set alerts at 50% CPU to catch any usage above the typical range.

An Azure SQL Database is experiencing intermittent performance issues. The administrator needs to collect detailed query-level metrics, including wait statistics and query execution counts, to identify bottlenecks. The administrator also wants to store this data for 90 days for trend analysis. Which solution should the administrator use?

Enable Azure SQL Analytics and configure diagnostic settings to send query-level metrics to a Log Analytics workspace.

Use Azure Monitor Metrics to view query-level metrics.

Create a custom Extended Events session to capture wait statistics and store them in a local file.

Use Query Performance Insight to view query-level metrics and export to a CSV file.

Which tool in the Azure portal provides a real-time view of active queries and performance metrics for an Azure SQL database?

SQL Server Configuration Manager

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 1

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

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 6–10

6application · medium
A company runs an Azure SQL Database that supports a line-of-business application. The database administrator wants to establish a performance baseline. The administrator has collected metrics for two weeks. The metrics show that CPU usage is typically between 20% and 40%, with occasional spikes to 60% during month-end reporting. What should the administrator do with this information?
Select an answer first
7application · medium
An Azure SQL Database is experiencing intermittent performance issues. The administrator needs to collect detailed query-level metrics, including wait statistics and query execution counts, to identify bottlenecks. The administrator also wants to store this data for 90 days for trend analysis. Which solution should the administrator use?
Select an answer first
8foundation · easy
Which dynamic management view (DMV) can be queried to obtain performance metrics about query execution in an Azure SQL database?
Select an answer first
9foundation · easy
Which tool in the Azure portal provides a real-time view of active queries and performance metrics for an Azure SQL database?
Select an answer first
10foundation · easy
To monitor query performance in an Azure SQL database, which database setting should be enabled?
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 2)

Questions 6–10

Which dynamic management view (DMV) can be queried to obtain performance metrics about query execution in an Azure SQL database?

Which tool in the Azure portal provides a real-time view of active queries and performance metrics for an Azure SQL database?

To monitor query performance in an Azure SQL database, which database setting should be enabled?

Keep studying — Monitor, configure, and optimize database resources