Hotspot Question You have an Azure SQL database named DB1. You have an Azure DevOps pipeline named Pipeline1. Pipeline1 creates a data-tier app and publishes a file that contains the output of the app

Question

Exhibit

Answer Area

• Input key for value 'DacpacTask'DacpacTask:
  DacpacTask:InlineSqlTask:SqlTask:
• Input key for value $(dbfile)DacpacFile:
  BacpacFile:DacpacFile:SqlFile:

Explanation

This question tests knowledge of deploying a DACPAC (Data-tier Application Package) file to Azure SQL Database using Azure DevOps YAML pipelines. The correct approach involves using the SqlAzureDacpacDeployment task with appropriate configuration.

Approach. To deploy a published DACPAC file to Azure SQL Database, you must use the task 'SqlAzureDacpacDeployment@1' in the YAML pipeline. The key inputs are: 'azureSubscription' (for the Azure service connection), 'AuthenticationType' (set to 'server' or 'aadAuthenticationPassword' etc.), 'ServerName' (the Azure SQL server FQDN), 'DatabaseName' (DB1), 'deployType' set to 'DacpacTask', and 'DeploymentAction' set to 'Publish'. The 'DacpacFile' input should reference the published .dacpac file from the pipeline artifact, typically using a wildcard path like '**/*.dacpac'. This task handles the entire deployment of a data-tier application package to Azure SQL Database.

Concept tested. Deploying a DACPAC file to Azure SQL Database using the SqlAzureDacpacDeployment@1 Azure DevOps pipeline task in a YAML pipeline configuration, including correct task name, inputs such as deployType 'DacpacTask', DeploymentAction 'Publish', and specifying the DacpacFile path.

Reference. https://learn.microsoft.com/en-us/azure/devops/pipelines/tasks/reference/sql-azure-dacpac-deployment-v1

No community discussion yet for this question.