DP-300 Configure and manage automation of tasks Practice Question
You manage a fleet of 100 Azure SQL Databases used by different departments. You need to automate the deployment of schema changes across all databases with rollback capability. What is the best approach?
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
✓
Implement a CI/CD pipeline using Azure DevOps with Azure SQL Database deployment tasks
Azure SQL Database supports deployment pipelines with CI/CD using Azure DevOps or GitHub Actions, allowing automated schema changes with rollback. Option A is wrong because Elastic Database Jobs are for ad-hoc scripts, not for complex deployments with rollback. Option C is wrong because SQL Server Management Studio (SSMS) is a manual tool. Option D is wrong because it lacks full automation and rollback.
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 Elastic Database Job that runs the schema script
Why it's wrong here
Elastic Database Jobs are useful for ad-hoc script execution across many databases but lack native rollback capabilities, making them unsuitable for complex schema deployments with rollback.
- ✓
Implement a CI/CD pipeline using Azure DevOps with Azure SQL Database deployment tasks
Why this is correct
Azure DevOps CI/CD pipeline with SQL Database deployment tasks provides automated schema changes with built-in rollback via deployment history and script versioning.
- ✗
Use SQL Server Management Studio (SSMS) to run scripts against each database
Why it's wrong here
SQL Server Management Studio (SSMS) is a manual tool that does not provide automation or rollback capabilities for fleet-wide deployments.
- ✗
Use Azure Automation with PowerShell to run Invoke-SqlCmd
Why it's wrong here
Azure Automation with PowerShell can run scripts but lacks full pipeline integration, deployment history, and seamless rollback compared to a CI/CD solution.
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
This DP-300 question is part of Courseiva's 906-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 →
Same concept, more angles
1 more way this is tested on DP-300
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You are responsible for managing a fleet of 20 Azure SQL Databases used by different departments. Each database has its own schema and data. You need to automate the creation of weekly exports of each database to a BACPAC file stored in a specific Azure Storage container. The exports should be done outside business hours (Sundays at 2 AM). You also need to ensure that the export process does not impact production performance. What is the most straightforward and cost-effective solution?
easy- A.Use Elastic Database Jobs to run a SQL script that exports the database using the BACPAC export command.
- B.Use Azure Data Factory with a copy activity to export the database to BACPAC via the SQL Server Import/Export service.
- ✓ C.Create an Azure Automation runbook that uses the Export-AzSqlDatabase cmdlet for each database, and schedule the runbook to run weekly on Sundays at 2 AM.
- D.Manually export each database using Azure Portal once a week.
Why C: Azure Automation runbooks can use the Export-AzSqlDatabase cmdlet to export each database to BACPAC, and scheduling the runbook for Sundays at 2 AM meets the automation and off-hours requirement, minimizing performance impact. This is straightforward and cost-effective as it uses built-in Azure Automation without extra services. Option A (Elastic Database Jobs) is designed for running T-SQL scripts across databases, not for exporting BACPAC files. Option B (Azure Data Factory) adds unnecessary complexity and cost for this simple export task. Option D is manual and not automated.
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.