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?
Click on the arrows to vote for the correct answer
A. B. C. D.B
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-deploymentTo create a release pipeline that updates an Azure SQL database, you need to deploy a database deployment artifact. There are various types of artifacts that can be used for this purpose, including BACPAC, DACPAC, LDF, and MDF files.
Out of these options, the correct answer is B. a DACPAC.
A BACPAC (Answer A) is a data-tier application package that contains the schema and data of a SQL database. It is used to create a new database or migrate an existing database to another server. While it can be used to update an existing database, it is not the optimal artifact type for this task.
An LDF (Answer C) and an MDF (Answer D) are both SQL Server data files that are used to store database transaction logs and data, respectively. These files are not deployment artifacts and cannot be used to update a database.
A DACPAC (Answer B) is a data-tier application package that contains only the schema of a SQL database. It is used to deploy changes to an existing database, without affecting any data. A DACPAC contains a snapshot of the database schema, and when deployed, it compares the schema in the package with the schema of the target database and applies the necessary changes.
Therefore, the correct answer is B. a DACPAC, as it is the appropriate artifact type to use with the Azure SQL Database Deployment task to update DB1.