You are troubleshooting an Always On availability group where the secondary replica is not synchronizing. Which DMV should you query to identify the synchronization state and health of the replica?

sys.dm_hadr_database_replica_states

sys.dm_tran_active_transactions

A company has an Always On availability group on Azure VMs with a synchronous secondary replica. They experience a network partition between the two replicas. What is the impact on the primary database?

The primary database continues to accept transactions, but the secondary falls behind.

The primary database automatically fails over to the secondary.

The primary database continues to accept transactions, but the transaction log grows indefinitely.

The primary database becomes unavailable if it does not have quorum, because synchronous commit requires a quorum to continue.

You are configuring an Always On Failover Cluster Instance (FCI) on Azure virtual machines. What is the primary purpose of an FCI?

To enable automatic failover of individual databases to a secondary server

To provide read-scale replicas for reporting workloads

To provide disaster recovery across Azure regions

To provide high availability for a single SQL Server instance by failing over to another node in the cluster

A company has an Always On availability group on Azure VMs. The secondary replica is showing 'Not Synchronizing' status. The primary is healthy. What is the most likely cause and what should you do?

The network between the replicas is slow; increase the bandwidth.

The secondary replica's SQL Server service is not running; start the service.

The primary replica's transaction log is full; back up the log.

The secondary replica is in a restoring state; wait for it to complete.

You have a failover group configured for an Azure SQL Database. During a regional outage, the failover group automatically failed over to the secondary region. After the primary region is restored, you need to return the database to the original primary region without data loss. What should you do?

Restore the original primary database from a backup.

Use active geo-replication to create a new secondary in the original region and then promote it.

Delete the failover group and recreate it with the original primary as the secondary.

Initiate a manual failover from the secondary back to the primary.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 3

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

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 11–15

11foundation · easy
You are troubleshooting an Always On availability group where the secondary replica is not synchronizing. Which DMV should you query to identify the synchronization state and health of the replica?
Select an answer first
12expert · hard
A company has an Always On availability group on Azure VMs with a synchronous secondary replica. They experience a network partition between the two replicas. What is the impact on the primary database?
Select an answer first
13foundation · easy
You are configuring an Always On Failover Cluster Instance (FCI) on Azure virtual machines. What is the primary purpose of an FCI?
Select an answer first
14expert · hard
A company has an Always On availability group on Azure VMs. The secondary replica is showing 'Not Synchronizing' status. The primary is healthy. What is the most likely cause and what should you do?
Select an answer first
15application · medium
You have a failover group configured for an Azure SQL Database. During a regional outage, the failover group automatically failed over to the secondary region. After the primary region is restored, you need to return the database to the original primary region without data loss. What should you do?
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.