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?
To create a release pipeline that updates an Azure SQL Database, a DACPAC (Data-tier Application Package) should be deployed. The DACPAC contains the database schema and other necessary SQL objects, making it suitable for applying schema changes and updates to an existing database. This is ideal for development, testing, and production environments where only the schema needs to be updated. Other file types like BACPAC (which includes both schema and data), LDF, and MDF do not fit the requirement as closely for schema updates.
Correct DACPAC and BACPAC are similar but they target different scenarios. A DACPAC is focused on capturing and deploying schema, including upgrading an existing database. The primary use case for a DACPAC is to deploy a tightly defined schema to development, test, and then to production environments. And also the reverse: capturing production's schema and applying it back to test and development environments. A BACPAC, on the other hand, is focused on capturing schema and data supporting two main operations: EXPORT- The user can export the schema and the data of a database to a BACPAC. IMPORT - The user can import the schema and the data into a new database in the host server.
Just fyi: PAC = package DAC = "Data-tier applications" BAC = Not sure, maybe "backup" DACPAC = schemas + other SQL objects BACPAC = DACPAC + data
The task can use both dacpac and backbac, but the question is to update database, so I guess we need to provide dacpac, to update dtabase schema. Also take a look at the learning: https://docs.microsoft.com/en-us/learn/modules/manage-database-changes-in-azure-pipelines/6-deploy-pipeline
https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver15#bacpac
Got this question in Feb-2022 exam (scored 910+). Given answer is correct. DACPAC.
The answer is correct. To create a release pipeline that uses the Azure SQL Database Deployment task to update DB1, database administrators can package SQL Server objects into a portable artifact called a data-tier application (DAC) package, also known as a DACPAC.
https://learn.microsoft.com/en-us/azure/devops/pipelines/targets/azure-sqldb?view=azure-devops&tabs=yaml
DACPAC
correct - DACPAC
"update DB1": DACPAC is accepted answer here, but why should 'updating' not include the data in this question ?
https://docs.microsoft.com/en-us/sql/relational-databases/data-tier-applications/data-tier-applications?view=sql-server-ver16 "The .dacpac can be used to update a database" Answer is B
B is correct answer.
correct https://docs.microsoft.com/en-us/azure/devops/pipelines/tasks/deploy/sql-azure-dacpac-deployment?view=azure-devops