A company has a failover group with two Azure SQL Databases. During a regional outage, the failover group automatically failed over to the secondary region. After the primary region is restored, they want to fail back without data loss. What should you do?

Perform a planned failover from the Azure portal, which synchronizes data before switching back.

Use T-SQL to switch the primary and secondary.

Drop the failover group and recreate it with the original primary as the new primary.

Perform an unplanned failover to force the switch back immediately.

You have configured active geo-replication for an Azure SQL Database. You need to verify that the secondary database is keeping up with the primary and that the replication lag is within acceptable limits. What should you monitor?

The CPU percentage on the secondary database.

The Deadlock metric on the secondary database.

The Replication Lag metric in Azure Monitor for the secondary database.

The Data IO Percentage metric on the primary database.

When implementing an Always On Failover Cluster Instance (FCI) on Azure virtual machines, which storage solution is commonly used to provide shared storage for the cluster?

Azure SQL Database geo-replication

Azure Managed Disks with shared disks or Storage Spaces Direct

In a log shipping configuration, what is the typical role of the secondary server?

To offload write operations from the primary server

To serve as a read-only reporting database that is continuously updated

To maintain a copy of the database that can be manually brought online for failover

To provide automatic failover if the primary server fails

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 3

Configure HA/DR for Database Solutions DP-300 Practice Questions (Page 1)

Part of the Plan and configure a high availability and disaster recovery (HA/DR) environment domain, which accounts for 20–25% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~8–16 in this domain), expect 3–5 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)

32questions here

7free pages

7concepts

20–25%of the exam

Questions 1–5

1expert · hard
A company has a failover group with two Azure SQL Databases. During a regional outage, the failover group automatically failed over to the secondary region. After the primary region is restored, they want to fail back without data loss. What should you do?
Select an answer first
2application · medium
You have configured active geo-replication for an Azure SQL Database. You need to verify that the secondary database is keeping up with the primary and that the replication lag is within acceptable limits. What should you monitor?
Select an answer first
3foundation · easy
When implementing an Always On Failover Cluster Instance (FCI) on Azure virtual machines, which storage solution is commonly used to provide shared storage for the cluster?
Select an answer first
4foundation · easy
In a log shipping configuration, what is the typical role of the secondary server?
Select an answer first
5application · medium
You have configured log shipping from a primary SQL Server to a secondary SQL Server. You need to ensure that the secondary database can be used for reporting, but you also need to be able to restore additional transaction log backups without taking the database offline. What recovery mode should you configure on the secondary database?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.