BenchMark Quizzes by MDFT Pro

Identify Required Parameters For Deploying Azure SQL Database With CLI

You work for MDFT Pro, a well-known training agency with an Azure subscription for managing cloud infrastructure. Mark, the Automation Engineer, needs to deploy a new Azure SQL database to host the company’s certification tracking system. To ensure consistent deployments across development, testing, and production environments, Mark wants to use Azure Command-Line Interface (CLI) for automation and scripting. He’s writing a deployment script that will be integrated into the CI/CD pipeline, and he needs to understand which parameters are mandatory for the database creation command. Understanding the required parameters will help him create a minimal, reusable script that can be easily maintained.

Which three parameters are required to deploy an Azure SQL database using Azure CLI?

Choose the correct answer from the options below.

Explanations for each answer:

--name, --edition, and --capacity is incorrect. While name is required, edition and capacity are optional parameters that can be omitted to use default values.
--name, --tier, and --min-capacity is incorrect. While name is required, tier and min-capacity are optional parameters for specific configurations like serverless.
--name, --resource-group, and --server is correct. These three parameters are required: the database name, the resource group where it will be created, and the SQL server that will host it.
--name, --license-type, and --capacity is incorrect. While name is required, license-type and capacity are optional parameters that can be specified but are not mandatory.

Learn more about Azure CLI Commands For SQL Database:

Azure CLI For SQL Database

Practice Exam

Identify Required Parameters For Deploying Azure SQL Database With CLI

Discuss this question on social media: