Question 30 of 170 from exam DP-200: Implementing an Azure Data Solution

Question 30 of 170 from exam DP-200: Implementing an Azure Data Solution

Question

SIMULATION -

Use the following login credentials as needed:

Azure Username: xxxxx -

Azure Password: xxxxx -

The following information is for technical support purposes only:

Lab Instance: 10277521 -

You need to create an Azure SQL database named db3 on an Azure SQL server named SQL10277521. Db3 must use the Sample (AdventureWorksLT) source.

To complete this task, sign in to the Azure portal.

Explanations

See the explanation below.

1. Click Create a resource in the upper left-hand corner of the Azure portal.

2. On the New page, select Databases in the Azure Marketplace section, and then click SQL Database in the Featured section.

3. Fill out the SQL Database form with the following information, as shown below:

Database name: Db3 -

Select source: Sample (AdventureWorksLT)

Server: SQL10277521 -

4. Click Select and finish the Wizard using default options.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-design-first-database