Practice Test 1 | Designing and Implementing Microsoft DevOps Solutions | AZ-400 | Dumps | Mock Test
A team is currently using Azure Pipelines for their application deployments. They now want to implement database updates to an Azure SQL database after every successful build. Which of the following steps the team can apply for this requirement?
A. Create an ARM template for the schema related changes.
B. Create a DACPAC to deploy schema related changes.
C. Use the Azure SQL Database deployment task.
D. Use the Azure Stack deployment task.
Answer – B and C
You can publish schema-related changes using a DACPAC. You can then use the Azure SQL Database deployment task in Azure Pipelines.
This is also mentioned in the Microsoft documentation-
Option A is incorrect because ARM templates can be used for the creation of Azure SQL database resources but not for database updates.
Option B is the CORRECT step because for database change deployment you can create DACPA. DACPACs can be used to package and deploy schema changes and data.
Option C is the CORRECT step because, for the deployment of the DACPAC file, you need to use this task.
Option D is incorrect because this task can not be used for database updates.
For more information on publishing changes to an Azure SQL database, please refer to the following link-
Comments are closed, but trackbacks and pingbacks are open.