DP-300 Configure and manage automation of tasks Practice Question
You need to automatically send a weekly email report summarizing the performance metrics (DTU consumption, storage used) of all Azure SQL Databases in a subscription. Which Azure service should you use?
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 Logic App with a recurrence trigger, using Azure Monitor connector to get metrics and Office 365 Outlook connector to send email.
Azure Logic Apps provide a no-code/low-code solution with a recurrence trigger to run weekly, the Azure Monitor connector to retrieve metrics (DTU consumption, storage) from Azure SQL Databases, and the Office 365 Outlook connector to send the email report. Option A is less ideal because Azure Automation Runbooks require custom scripting for email and are more complex. Option C is incorrect because Elastic Database Jobs are designed for T-SQL administration tasks across databases, not for gathering metrics via Azure Monitor. Option D is incorrect because Azure Data Factory focuses on data movement and transformation, not on scheduling email reports with live metrics.
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 Automation Runbook with PowerShell to collect metrics and send email via Send-MailMessage.
Why it's wrong here
Send-MailMessage is deprecated and not recommended.
- ✓
Azure Logic App with a recurrence trigger, using Azure Monitor connector to get metrics and Office 365 Outlook connector to send email.
Why this is correct
Logic Apps have built-in connectors for metrics and email.
- ✗
Elastic Database Job that queries sys.dm_db_resource_stats and sends email via sp_send_dbmail.
Why it's wrong here
Elastic Database Jobs cannot send emails.
- ✗
Azure Data Factory pipeline that runs weekly and sends an email with the report.
Why it's wrong here
ADF is not designed for sending emails.
Go deeper
Related to this question
About these practice questions
One of 906 original DP-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.