A database administrator wants to optimize the performance of an Azure SQL Database. The administrator has identified several queries that are frequently executed and have high resource consumption. The administrator wants to automatically apply index recommendations that are safe and reversible. What should the administrator configure?

A maintenance plan to rebuild all indexes nightly.

A SQL Agent job to run the Database Tuning Advisor.

Automatic tuning with the 'CREATE INDEX' option.

Manual index creation based on the Query Performance Insight recommendations.

An Azure SQL Database has been running smoothly for months. The administrator notices that the average DTU consumption has increased from 40% to 75% over the past week, while the workload volume has remained constant. The database is still within its allocated DTU limit, and no alerts have triggered. What should the administrator do first to assess the situation?

Review recent query performance and wait statistics to identify the cause of the increased resource consumption.

Rebuild all indexes in the database to improve performance.

Ignore the change because the database is still within its DTU limit.

Increase the DTU service tier to provide more headroom.

A company runs an Azure SQL Database that is used by multiple applications. The database administrator wants to set up monitoring to detect when a specific application is causing high resource usage. The administrator needs to differentiate between applications and set alerts based on the application's resource consumption. Which configuration should the administrator implement?

Create a separate Azure SQL Database for each application.

Use Azure Monitor Metrics and filter by application name.

Enable diagnostic settings to send metrics to a Log Analytics workspace and use KQL queries to filter by application name.

Use Query Performance Insight to filter by application name.

Which Azure SQL Database setting can be configured to automatically adjust performance based on workload changes?

Transparent Data Encryption (TDE)

Microsoft Certified:Azure Database Administrator Associate

Domain 3Objective 1

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

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 16–20

16application · medium
A database administrator wants to optimize the performance of an Azure SQL Database. The administrator has identified several queries that are frequently executed and have high resource consumption. The administrator wants to automatically apply index recommendations that are safe and reversible. What should the administrator configure?
Select an answer first
17application · medium
An Azure SQL Database has been running smoothly for months. The administrator notices that the average DTU consumption has increased from 40% to 75% over the past week, while the workload volume has remained constant. The database is still within its allocated DTU limit, and no alerts have triggered. What should the administrator do first to assess the situation?
Select an answer first
18application · medium
A database administrator needs to monitor a critical Azure SQL Database in real time to observe live query execution and identify blocking issues. The administrator wants a tool that provides a visual, real-time view without writing any code. Which tool should the administrator use?
Select an answer first
19expert · hard
A company runs an Azure SQL Database that is used by multiple applications. The database administrator wants to set up monitoring to detect when a specific application is causing high resource usage. The administrator needs to differentiate between applications and set alerts based on the application's resource consumption. Which configuration should the administrator implement?
Select an answer first
20foundation · easy
Which Azure SQL Database setting can be configured to automatically adjust performance based on workload changes?
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 4)

Questions 16–20

A database administrator needs to monitor a critical Azure SQL Database in real time to observe live query execution and identify blocking issues. The administrator wants a tool that provides a visual, real-time view without writing any code. Which tool should the administrator use?

Which Azure SQL Database setting can be configured to automatically adjust performance based on workload changes?

Keep studying — Monitor, configure, and optimize database resources