Plan and configure a high availability and disaster recovery (HA/DR) environment Questions
Practice questions for Plan and configure a high availability and disaster recovery (HA/DR) environment topic in Microsoft Certified: Azure Database Administrator Associate. 43 questions covering this domain.
What is the best practice for selecting regions for Azure SQL failover groups?
A failover group is being created between two Azure SQL Managed Instances. Why must the instances share the same DNS zone?
An application must protect a specific committed transaction from being lost during a later geo-failover. What should the application do immediately a...
Which Azure SQL feature is configured per individual database rather than as a group-level abstraction?
Which DMV column should you monitor on the primary database to estimate current geo-replication lag against the recovery point objective?
Which failover policy does Microsoft recommend for Azure SQL failover groups in most cases?
Which statement is true for Azure SQL Managed Instance failover groups?
Why can a forced geo-failover result in data loss?
Which combination of availability mode and failover behavior is correct for SQL Server Always On availability groups?
An application uses the read-write listener of an Azure SQL failover group. What change is required in the application connection string after a geo-f...
An administrator needs to perform a planned disaster recovery drill without data loss. Which statement is correct?
An Azure SQL Database is accidentally dropped. Which recovery option lets you restore it for the duration of the configured PITR window?
A DBA performs an LTR restore for an Azure SQL Database backup. What is the result?
What is the maximum point-in-time restore (PITR) retention available for Azure SQL Database (without LTR)?
Which RPO is documented for Azure SQL Database active geo-replication / failover groups in normal operation?
An organization wants to test a planned regional failover for an Azure SQL failover group without disrupting production traffic. What is the documente...
Which backup storage redundancy option for Azure SQL Database backups provides protection against a region-wide outage by replicating to the paired re...
Which statement about Hyperscale named replicas is correct regarding failover?
Which option enables zone-redundant high availability for Azure SQL Database Business Critical?
An Always On availability group hosted on SQL Server VMs in Azure needs a multi-subnet listener. What additional Azure component is required to make t...
Sign in to see all 43 questions
Create a free account to browse all questions — completely free during our launch phase.