An Azure SQL Database is experiencing slow response times. The database administrator uses Query Performance Insight and sees that a query has high duration and high CPU time. The query plan shows a table scan. What is the most likely cause of the performance issue?

Insufficient memory on the database server.

Network latency between the application and the database.

Lock contention from concurrent transactions.

Missing index on the table being scanned.

A company uses Azure SQL Database for an e-commerce application. The database administrator wants to proactively monitor performance and receive notifications when CPU usage exceeds 80% for more than 5 minutes. The administrator also wants to store the metric history for 30 days for analysis. Which configuration should the administrator implement?

Create a diagnostic setting to send metrics to a Log Analytics workspace and configure an alert rule on the CPU metric.

Use Azure Monitor Metrics to view CPU and set a manual alert in the portal.

Enable SQL Analytics and rely on its built-in alerts.

Configure a SQL Agent job to check CPU usage and send an email.

An Azure SQL Database is experiencing performance degradation during specific time periods. The administrator needs to capture detailed information about the queries that are running during those periods, including the T-SQL text and the duration of each query. The administrator wants to minimize overhead and be able to start and stop the capture easily. Which approach should the administrator use?

Create an Extended Events session that captures the sqlserver.sql_statement_completed event and includes the sql_text action.

Use Query Performance Insight to capture query text and duration.

Enable SQL Server Profiler to capture all queries.

Use Azure Monitor to collect query logs.

A database administrator is investigating a performance issue in an Azure SQL Database. The administrator notices that the database's DTU consumption is high, but the CPU metric is low. The administrator suspects that the issue is related to I/O. What should the administrator do to confirm the cause?

Check the I/O metrics in Azure Monitor, such as 'Data IO' and 'Log IO'.

Enable Extended Events to capture I/O-related events.

Check the Query Performance Insight for queries with high I/O.

Use the Azure Portal's 'Metrics' blade to view the 'DTU' metric.

Which of the following is a source for gathering performance metrics for an Azure SQL database?

Azure Resource Manager templates

Azure Active Directory sign-in logs

SQL Server Management Studio (SSMS) Object Explorer

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 1

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

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 11–15

11application · medium
An Azure SQL Database is experiencing slow response times. The database administrator uses Query Performance Insight and sees that a query has high duration and high CPU time. The query plan shows a table scan. What is the most likely cause of the performance issue?
Select an answer first
12application · medium
A company uses Azure SQL Database for an e-commerce application. The database administrator wants to proactively monitor performance and receive notifications when CPU usage exceeds 80% for more than 5 minutes. The administrator also wants to store the metric history for 30 days for analysis. Which configuration should the administrator implement?
Select an answer first
13application · medium
An Azure SQL Database is experiencing performance degradation during specific time periods. The administrator needs to capture detailed information about the queries that are running during those periods, including the T-SQL text and the duration of each query. The administrator wants to minimize overhead and be able to start and stop the capture easily. Which approach should the administrator use?
Select an answer first
14expert · hard
A database administrator is investigating a performance issue in an Azure SQL Database. The administrator notices that the database's DTU consumption is high, but the CPU metric is low. The administrator suspects that the issue is related to I/O. What should the administrator do to confirm the cause?
Select an answer first
15foundation · easy
Which of the following is a source for gathering performance metrics for an 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 3)

Questions 11–15

An Azure SQL Database is experiencing slow response times. The database administrator uses Query Performance Insight and sees that a query has high duration and high CPU time. The query plan shows a table scan. What is the most likely cause of the performance issue?

Which of the following is a source for gathering performance metrics for an Azure SQL database?

Keep studying — Monitor, configure, and optimize database resources