Practice Test 2 | Designing And Implementing Microsoft DevOps Solutions | AZ-400 | Dumps | Mock Test
Your team currently has an Azure DevOps project and an Azure subscription. The subscription contains an Azure SQL database named whizlabdb. They want to create a release pipeline. It would use the Azure SQL Database deployment task to update the database. Which of the following should they use as an artifact in the update process?
A. BACPAC file
B. DACPAC file
C. LDF file
D. MDF file
Answer – B
You can use a DACPAC file for scheme related changes.
The Microsoft documentation mentions the following.
Option A is incorrect because the primary use case for a BACPAC is to move a database from one server to another or to migrate a database from a local server to the cloud and archive an existing database in an open format. It’s not used for performing schema-related changes in an existing database.
Option B is CORRECT because the DACPAC file is used for packaging and deploying schema-related changes in the release pipeline.
Option C is incorrect because the main purpose of using the LDF file in SQL Server is to roll back the database in case of data loss.
Option D is incorrect because the MDF file is a Master Database File used by Microsoft SQL Server to store user data and not for deploying the schema changes.
For more information on Azure SQL database deployment, please visit the following URL-
Comments are closed, but trackbacks and pingbacks are open.