nerdexam
Microsoft

70-473 · Question #133

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. The goal is to provision a new Azure Database for MySQL server database, but the solution only creates a database within an existing MySQL server, not provisioning an Azure resource.

Design and implement data storage

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Microsoft Azure tenant. You need to provision a new Azure Database for MySQL server database in the tenant. Solution: You run the CREATE DB command from the mysql command prompt. Does this meet the goal?

Options

  • AYes
  • BNo

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    96% (23)

Why each option

The goal is to provision a new Azure Database for MySQL server database, but the solution only creates a database within an existing MySQL server, not provisioning an Azure resource.

AYes

Running the CREATE DATABASE command only creates a database on an already provisioned MySQL server, it does not provision the server resource itself as an Azure managed service.

BNoCorrect

The CREATE DATABASE command is a SQL statement used to create a database inside an existing MySQL server, not to provision a new Azure Database for MySQL server resource as a managed service within an Azure tenant.

Concept tested: Differentiating between SQL commands and Azure resource provisioning

Source: https://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-server-portal

Topics

#Azure Database for MySQL#database provisioning#T-SQL commands

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-473 Practice