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

Question 29 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 replicate db1 to a new Azure SQL server named REPL10277521 in the Central Canada region.

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

NOTE: This task might take several minutes to complete. You can perform other tasks while the task completes or ends this section of the exam.

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

Explanations

See the explanation below.

1. In the Azure portal, browse to the database that you want to set up for geo-replication.

2. On the SQL database page, select geo-replication, and then select the region to create the secondary database.

3. Select or configure the server and for the secondary database.

Region: Central Canada -

Target server: REPL10277521 -

4. Click Create to add the secondary.

5. The secondary database is created and the seeding process begins.

6. When the seeding process is complete, the secondary database displays its status.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-active-geo-replication-portal