Exam AZ-400 topic 8 question 36 discussion

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

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

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.

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