DP-300 Configure and manage automation of tasks Practice Question
Your organization uses Azure SQL Database and needs to automate email notifications when a database reaches 80% storage usage. Which native Azure feature can you use?
⚠ Common exam trap
DP-300 often tests the misconception that SQL Server features like SQL Agent, Database Mail, and sp_send_dbmail are available in Azure SQL Database, when in fact they are only supported in Azure SQL Managed Instance or on-premises SQL Server.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Create an Azure Monitor alert rule on the 'storage_percent' metric with an email action group.
Azure Monitor alert rules on the 'storage_percent' metric with an email action group are the native Azure feature for this requirement. Azure SQL Database emits the storage_percent metric to Azure Monitor, and alert rules can trigger when it exceeds 80%, invoking an action group that sends email. This is fully managed, requires no SQL Agent, and works for both single databases and elastic pools.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Create an Azure Monitor alert rule on the 'storage_percent' metric with an email action group.
Why this is correct
Azure Monitor alert rules evaluate platform metrics such as storage_percent and trigger action groups, which deliver email notifications. This satisfies the requirement for native, automated alerting at the 80% threshold without custom code or external tooling, unlike query-based or scheduled approaches.
- ✗
Create a SQL Agent alert that fires when the storage is above 80% and sends an email.
Why it's wrong here
SQL Agent is unavailable in Azure SQL Database; it exists only in SQL Server and Managed Instance. Alerts on storage metrics are handled by Azure Monitor, which triggers action groups for email. SQL Agent alerts would be the right approach on a Managed Instance where the agent runs.
- ✗
Configure Database Mail to send alerts automatically.
Why it's wrong here
Database Mail is a SQL Server Agent feature for on-premises instances; Azure SQL Database does not support it. The native mechanism is Azure Monitor alerts with an action group sending email at 80% storage. Database Mail would be correct for an on-premises SQL Server requiring agent-driven notification emails.
- ✗
Create an Elastic Database Job that checks storage and sends email via sp_send_dbmail.
Why it's wrong here
Elastic Database Jobs run T-SQL on a schedule across databases; they do not monitor platform storage metrics or send email natively, since sp_send_dbmail requires Database Mail, unsupported in Azure SQL Database. Azure Monitor alerts are the native mechanism for storage-threshold notifications.
Go deeper
Related to this question
Learn chapter
Deploying and Configuring Azure SQL Managed Instance
Key term
Azure SQL Performance Tuning
Azure SQL Performance Tuning is the process of optimizing the speed and efficiency of queries and database operations in Microsoft Azure SQL Database or SQL Managed Instance to reduce latency and improve throughput.
About these practice questions
This DP-300 question is part of Courseiva's 574-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
This DP-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-300 exam.