Microsoft
DP-300 · Question #435
Hotspot Question You have an Azure subscription that contains an Always On availability group named AG1. AG1 contains three replicas named Server1, Server2, and Server3. You execute the following T-SQ
Sign in or unlock DP-300 to reveal the answer and full explanation for question #435. The question stem and answer options stay visible for context.
Submitted by alyssa_d· Mar 6, 2026Implement a high availability and disaster recovery environment - specifically querying and interpreting Always On AG replica states using DMVs such as sys.dm_hadr_database_replica_states and sys.availability_databases_cluster
Question
Hotspot Question You have an Azure subscription that contains an Always On availability group named AG1. AG1 contains three replicas named Server1, Server2, and Server3. You execute the following T-SQL statements on Server1. For each of the following statements, select Yes if the statement is true, otherwise select No. NOTE: Each correct selection is worth one point. Answer:
Exhibits
Answer Area
- The statement will only return databases that are members of AG1.
- The statement will return all the databases for which Server1 is the secondary replica.
- The statement will return all the Always On availability groups for which Server3 is a secondary replica.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Always On Availability Groups#Dynamic Management Views#SQL Server High Availability#T-SQL System Catalog