DP-300 Configure and manage automation of tasks Practice Question
Which TWO tools can be used to automate the deployment of database schema changes to Azure SQL Database as part of a CI/CD pipeline? (Choose two.)
⚠ Common exam trap
The trap is selecting manual tools like SSMS or Azure Data Studio, which are not automation tools for CI/CD pipelines; candidates must focus on tools that integrate with pipeline systems.
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
✓
GitHub Actions with the Azure SQL Database deployment action
Option B is correct because GitHub Actions provides the 'Azure SQL Database deployment' action (azure/sql-action), which executes scripts or DACPAC/BACPAC deployments against Azure SQL Database as an automated pipeline step. Option C is correct because an Azure DevOps release pipeline can use the 'Azure SQL Database deployment' task (SqlAzureDacpacDeployment) to deploy a SQL Server database project's DACPAC, applying schema changes automatically during CI/CD. Option A is not a pipeline automation tool; Azure Data Studio with SQLCMD mode is an interactive client for running scripts manually. Option D, the Import and Export Wizard, only moves data between sources and does not manage schema versioning or pipeline deployment. Option E, SSMS, is a manual GUI administration tool and does not itself automate CI/CD schema deployment.
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 Data Studio with SQLCMD mode
Why it's wrong here
SQLCMD mode in Azure Data Studio executes scripts interactively or ad hoc; it provides no pipeline task, deployment agent or release orchestration for unattended schema deployment. It is tempting because SQLCMD scripts are commonly embedded in DACPAC and migration workflows, and it would be correct for running T-SQL scripts manually against a database.
- ✓
GitHub Actions with the Azure SQL Database deployment action
Why this is correct
GitHub Actions orchestrates pipeline jobs, and the Azure SQL Database deployment action connects to the server and applies schema changes via SqlPackage. This satisfies the CI/CD automation constraint by executing DACPAC or SQL script deployment against Azure SQL Database on each pipeline run.
- ✓
Azure DevOps release pipeline with SQL Server database project (DACPAC) deployment task
Why this is correct
Azure DevOps release pipelines execute the SQL Server database project deployment task, which invokes SqlPackage to publish a compiled DACPAC to Azure SQL Database. This satisfies the CI/CD constraint by automating schema deployment as a release stage, with the DACPAC providing declarative, versioned schema definition.
- ✗
SQL Server Import and Export Wizard
Why it's wrong here
The Import and Export Wizard moves table data between sources; it performs no schema versioning, comparison or deployment step. It is tempting because it is a built-in SQL tool that touches Azure SQL Database, and it would be correct for one-off bulk data migration rather than schema release automation.
- ✗
SQL Server Management Studio (SSMS)
Why it's wrong here
SSMS is a graphical client for interactive administration; it exposes no CI/CD pipeline task or unattended deployment mechanism for schema changes. It is tempting because SSMS generates the DACPAC and publish scripts that pipelines consume, and it would be correct for manually authoring and applying schema changes.
Visual reference
Go deeper
Related to this question
Learn chapter
Monitoring Database Performance with Azure Tools
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.
Key term
Azure SQL Database Deployment
Azure SQL Database Deployment is the process of creating and configuring a fully managed relational database in the Microsoft Azure cloud using SQL Server engine, without managing the underlying infrastructure.
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.