You have configured active geo-replication for an Azure SQL Database. Management wants to be alerted if the replication lag exceeds 30 seconds. What should you use to monitor this?

Use Azure Monitor's built-in metric 'Replication Lag' for the database.

Check the Azure portal's geo-replication page for the lag indicator.

Query sys.dm_geo_replication_link_status and create an alert based on the replication_lag_sec column.

Use SQL Insights to monitor replication lag.

An organization runs SQL Server on two Azure VMs in the same availability set. They need to protect against a single VM failure and ensure the SQL Server instance continues to be available with the same server name. What should you configure?

An Always On availability group with a synchronous replica on the second VM.

Log shipping from the primary VM to the secondary VM.

An Always On Failover Cluster Instance (FCI) using shared storage, such as Azure Shared Disks.

Azure Site Recovery to replicate the VM to a secondary region.

A company is implementing an Always On Failover Cluster Instance (FCI) on Azure VMs. They need to ensure that the cluster can automatically fail over if one node becomes unavailable. What is a prerequisite for this?

Use a shared disk that is manually attached to both nodes.

Set the SQL Server service to start automatically on both nodes.

Enable Always On availability groups in SQL Server Configuration Manager.

Configure a cloud witness in Azure Storage.

A company uses active geo-replication for an Azure SQL Database. They want to ensure that the secondary database is used for read-only queries without affecting the primary. What should you do?

Connect to the secondary database using its server name and database name, and set the application intent to read-only.

Use a failover group listener with ApplicationIntent=ReadOnly.

Create a database snapshot on the secondary.

Use Azure SQL Database's built-in read scaling to route queries to the secondary.

Microsoft Certified:Azure Database Administrator Associate

Domain 5Objective 3

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

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 16–20

16application · medium
You have configured active geo-replication for an Azure SQL Database. Management wants to be alerted if the replication lag exceeds 30 seconds. What should you use to monitor this?
Select an answer first
17application · medium
An organization runs SQL Server on two Azure VMs in the same availability set. They need to protect against a single VM failure and ensure the SQL Server instance continues to be available with the same server name. What should you configure?
Select an answer first
18application · medium
A company is implementing an Always On Failover Cluster Instance (FCI) on Azure VMs. They need to ensure that the cluster can automatically fail over if one node becomes unavailable. What is a prerequisite for this?
Select an answer first
19foundation · easy
Which Azure service can you use to monitor the health and performance of your HA/DR solutions, such as availability groups and failover groups, by collecting metrics and logs?
Select an answer first
20application · medium
A company uses active geo-replication for an Azure SQL Database. They want to ensure that the secondary database is used for read-only queries without affecting the primary. 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.