You have an Azure DevOps project named Project1 and an Azure subscription named Sub1. Sub1 contains an Azure SQL database named DB1. You need to create a release pipeline that uses the Azure SQL Datab

The correct answer is B. a DACPAC. Use Azure SQL Database Deployment task in a build or release pipeline to deploy to Azure SQL DB using a DACPAC or run scripts using SQLCMD. https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-

Submitted by miguelv· Mar 6, 2026Design and implement build and release pipelines

Question

You have an Azure DevOps project named Project1 and an Azure subscription named Sub1. Sub1 contains an Azure SQL database named DB1. You need to create a release pipeline that uses the Azure SQL Database Deployment task to update DB1. Which artifact should you deploy?

Options

Aa BACPAC
Ba DACPAC
Can LDF file
Dan MDF file

How the community answered

(63 responses)

A
6% (4)
B
78% (49)
C
3% (2)
D
13% (8)

Explanation

Use Azure SQL Database Deployment task in a build or release pipeline to deploy to Azure SQL DB using a DACPAC or run scripts using SQLCMD. https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-

Topics

#DACPAC#Azure SQL#database deployment#release pipeline

Community Discussion

No community discussion yet for this question.

Full AZ-400 Practice