DP-300 Question #257: Real Exam Question with Answer & Explanation

Question

You have an Azure subscription. You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI). Which three parameters are required?

Options

• A--name, --edition, and --capacity
• B--name, --tier, and --min-capacity
• C--name, --resource-group, and --server
• D--name, --licence-type, and --capacity

Explanation

Explanation

When deploying an Azure SQL database using the Azure CLI command az sql db create, three parameters are mandatory: --name (the database name), --resource-group (the resource group where the database will reside), and --server (the logical SQL Server that will host the database) - making Option C correct. Without all three, the CLI cannot determine where to create the database or associate it with a server.

Options A and D are incorrect because --edition, --capacity, and --licence-type are all optional parameters used to customize performance tiers and licensing, but they are not required to execute the command. Option B is incorrect because --tier and --min-capacity relate to serverless or vCore configurations and are also optional, not mandatory for basic database creation.

💡 Memory Tip: Think of the three required parameters as answering "What? Where? On what?" - --name (What is it called?), --resource-group (Where does it live?), and --server (What server hosts it?). Everything else is just customization!

No community discussion yet for this question.