DP-300 Configure and manage automation of tasks Practice Question
You need to automatically send an email notification when an Azure SQL Database reaches 80% storage usage. What should you configure?
⚠ Common exam trap
DP-300 often tests the misconception that SQL Server features like SQL Agent Mail or sp_send_dbmail are available in Azure SQL Database, when in fact PaaS Azure SQL Database does not support SQL Agent or Database Mail.
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
✓
Azure Monitor alert with action group
Azure Monitor alerts with action groups are the native mechanism for triggering notifications based on platform metrics such as storage percentage on an Azure SQL Database. You create an alert rule on the 'storage' metric with a threshold of 80%, and attach an action group that sends email (or SMS, webhook, etc.). This is the standard, supported approach for metric-based notifications on Azure SQL Database.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Azure Monitor alert with action group
Why this is correct
An Azure Monitor alert evaluates the database's storage metric against an 80% threshold and triggers an action group, which delivers the email notification. This satisfies the requirement for automatic notification without custom scripting or manual monitoring.
- ✗
Change Data Capture (CDC) with Logic Apps
Why it's wrong here
Change Data Capture records inserted, updated and deleted rows for downstream consumption; it captures data changes, not resource utilisation metrics, so it cannot detect 80% storage usage. CDC is tempting because Logic Apps can act on captured changes, but storage thresholds come from platform metrics, not row-level change streams.
- ✗
Elastic Database Job with sp_send_dbmail
Why it's wrong here
Elastic Database Jobs run T-SQL across databases but cannot themselves monitor Azure SQL Database storage metrics or trigger on threshold breaches; sp_send_dbmail also requires Database Mail configured on a SQL Server instance, which Azure SQL Database does not expose. Jobs are tempting for scheduled T-SQL, yet metric-driven alerting needs Azure Monitor alerts.
- ✗
SQL Agent Mail
Why it's wrong here
SQL Agent Mail depends on SQL Server Agent and Database Mail, neither of which is available in Azure SQL Database, so no agent job can dispatch the notification. It is tempting because on-premises SQL Server administrators routinely use Agent alerts for exactly this threshold, but the platform difference removes that mechanism entirely.
Go deeper
Related to this question
Learn chapter
Overview of Azure Data Platform Options
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
Courseiva writes every DP-300 question from scratch — 574 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.