Learn how to create an Azure DevOps release pipeline using the Azure SQL Database Deployment task to update your Azure SQL database by deploying a DACPAC artifact.
Table of Contents
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?
A. a BACPAC
B. a DACPAC
C. an LDF file
D. an MDF file
Answer
To create a release pipeline in Azure DevOps that uses the Azure SQL Database Deployment task to update an Azure SQL database (DB1), you should deploy a DACPAC (Data-Tier Application Package) artifact.
B. a DACPAC
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.
A DACPAC is a package that contains the schema and data of a SQL Server database. It is used to deploy or upgrade a database to a target environment, such as an Azure SQL database. The DACPAC format is specifically designed for database deployment and is the recommended artifact for the Azure SQL Database Deployment task in Azure DevOps release pipelines.
Here’s why the other options are not suitable:
A. BACPAC: A BACPAC is a package that contains both the schema and data of a SQL Server database, but it is primarily used for database backups and migrations rather than deployments in release pipelines.
C. LDF file: An LDF (Log Data File) is a transaction log file used by SQL Server to maintain database consistency. It is not an appropriate artifact for database deployment in a release pipeline.
D. MDF file: An MDF (Master Data File) is the primary data file for a SQL Server database. Like the LDF file, it is not suitable for database deployment in a release pipeline.
In summary, when creating an Azure DevOps release pipeline to update an Azure SQL database using the Azure SQL Database Deployment task, you should deploy a DACPAC artifact. The DACPAC contains the necessary schema and data to effectively update your target database (DB1) in the Azure subscription (Sub1).
Microsoft AZ-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft AZ-400 exam and earn Microsoft AZ-400 certification.