DP-300 Configure and manage automation of tasks Practice Question
You are automating the creation of an Azure SQL database. You need to ensure that the deployment is idempotent using Azure Resource Manager (ARM) templates. Which deployment mode should you use?
⚠ Common exam trap
DP-300 often tests the misconception that Complete mode is 'more thorough' and therefore better for automation, when in fact Complete mode's deletion behavior breaks idempotency and can destroy resources not in the template.
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
✓
Incremental
Incremental deployment mode is the default ARM template mode and is idempotent: resources declared in the template are created or updated, and existing resources not in the template are left untouched. This makes repeated deployments safe and consistent, which is exactly what idempotency requires. Complete mode, by contrast, deletes resources in the resource group that are not in the template, so it is not idempotent in the safe sense.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Complete
Why it's wrong here
Complete mode deletes resources in the target resource group that the ARM template does not declare, so redeploying could remove the existing Azure SQL database rather than leaving it idempotently in place. It suits scenarios demanding an exact, authoritative resource-group state, not repeatable additive deployments.
- ✗
Automatic
Why it's wrong here
Automatic is not a valid ARM deployment mode; the supported modes are Incremental, Complete, and Validate. It may be confused with automatic rollback or validation behaviour, but no such mode exists, so it cannot deliver the idempotent redeployment the scenario requires.
- ✓
Incremental
Why this is correct
Incremental mode deploys resources without deleting existing ones, so re-running the same ARM template leaves unchanged resources intact and creates only missing ones. This satisfies the idempotency requirement, whereas Complete mode would delete resources absent from the template, breaking repeated deployments.
- ✗
Validate
Why it's wrong here
Validate performs a dry-run syntax and template check without creating or modifying any resources, so the Azure SQL database is never deployed. It is the right choice when you want to confirm a template will be accepted before committing, not when idempotent provisioning is required.
Go deeper
Related to this question
Learn chapter
Managing Environment Configurations and Resource Governance
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.