Question

Your organization requires that all Azure SQL Database deployments be fully automated, version-controlled in a Git repository, and repeatable so that redeploying the same template does not create duplicate resources or fail if the resources already exist. The DevOps team wants a native Azure infrastructure-as-code approach that integrates with Azure Pipelines and produces a declarative definition of the database and its logical server. Which deployment method should you recommend?

Accepted Answer

Use Bicep templates checked into the Git repository and deployed through an Azure Pipelines task.

Answer

Write a PowerShell script using New-AzSqlDatabase and schedule it as a recurring pipeline task.

Answer

Export a BACPAC of an existing database and import it into each new environment through the portal.

Answer

Create the database manually in the Azure portal and document the steps in a runbook.