Question

Your team maintains an Azure DevOps pipeline that provisions a new Azure SQL Database in an existing logical server for each feature branch. The pipeline uses a Linux agent and authenticates with a service principal that has Contributor rights on the resource group. You need to add a single command-line step that creates the database at the S1 service objective and is safe to re-run without error if the database already exists. Which approach should you use?

Accepted Answer

Run 'az sql db create' with the --service-objective S1 parameter, since the command returns the existing database without failure when it already exists.

Answer

Run 'New-AzSqlDatabase' in an Azure PowerShell task, because only PowerShell cmdlets can run non-interactively on a Linux build agent.

Answer

Execute a T-SQL 'CREATE DATABASE' statement through sqlcmd wrapped in an IF NOT EXISTS check against sys.databases.

Answer

Run 'az deployment group create' referencing an ARM template, which is the only way to make the deployment idempotent.