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

Question

SIMULATION You need to implement a disaster recovery solution by using active geo-replication for an Azure Azure SQL database named db1. The replica must be in the East US Azure region on a server named sql23456789-dr.database.windows.net. You may need to use SQL Server Management Studio and the Azure portal. Answer: Step 1: Navigate to your database: In the Azure portal, browse to the Azure SQL Database you want to replicate. [Select db1] Step 2: On the SQL Database page, select your database, scroll to Data management, select Replicas, and then select Create replica. Step 3: Select your geo-secondary database Subscription and Resource group. Step 4: Select or create the server for the secondary database [Select named sql23456789- dr.database.windows.net] Question: The replica must be in the East US Azure region on a server named sql23456789- dr.database.windows.net. Step 5: When secondary database is created [or selected], the deployment process begins. Step 6: When the deployment is complete, the secondary database displays its status. (Step 7: Return to the primary database page, and then select Replicas. Your secondary database is listed under Geo replicas.) Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-configure-portal

Options

• taskImplement a disaster recovery solution by using active geo-replication for an Azure SQL database named db1. The replica must be in the East US Azure region on a server named sql23456789-dr.database.windows.net.
• prerequisitesAzure portal access