Database Failover and High Availability Quiz

1. Which of these is NOT a common database failover mechanism?

Virtual IP address (VIP) switching

DNS round-robin failover

Application-level connection pooling

Automatic schema validation

2. A cold standby database requires significant time to initialize before becoming the primary after a failure. True or False?

True

False

3. Which technology prevents split-brain in a three-node cluster by requiring a majority of nodes to agree?

Quorum-based consensus

Round-robin DNS

Synchronous log shipping

Connection pooling

Submit

5. What is the primary benefit of using a virtual IP (VIP) in database failover?

Applications connect to a stable address that can switch to different servers

It encrypts all database traffic automatically

It eliminates the need for replication

It increases database query performance

6. Log shipping is an example of synchronous replication. True or False?

True

False

7. Which statement best describes the relationship between RTO and RPO?

RTO is the time to restore; RPO is the acceptable data loss window

They are the same metric measured differently

RPO determines the failover speed; RTO determines backup frequency

RTO is only for physical backups; RPO is only for logical backups

Submit

9. Heartbeat monitoring in a failover cluster detects node failures by periodically checking node availability. True or False?

True

False

10. In a multi-master replication setup, how are conflicting writes typically resolved?

Using timestamps, sequence numbers, or custom conflict resolution logic

Always rejecting the second write

Merging both changes automatically

Requiring manual intervention only

11. What is the primary purpose of database failover in a high-availability system?

Automatically redirect traffic to a standby database when the primary fails

Increase storage capacity across multiple servers

Reduce the cost of database licensing

Improve query performance for read-heavy workloads

Submit

13. Split-brain scenarios in database clusters occur when network partitioning causes two isolated groups to believe they are the primary. True or False?

True

False

14. Which replication topology involves multiple replicas receiving updates from a single source?

Star topology

Mesh topology

Ring topology

Cascade topology

Submit

16. What is the key advantage of using a warm standby database in disaster recovery?

It is already partially initialized and can failover faster than a cold standby

It requires no network connectivity to the primary

It eliminates the need for transaction logs

It automatically backs up all data hourly

17. Asynchronous replication in databases carries a higher risk of data loss than synchronous replication. True or False?

True

False

18. In a database cluster, what does a quorum determine?

The number of nodes needed to make cluster decisions

The total storage capacity of all nodes

The replication lag between nodes

The backup frequency schedule

19. Recovery Time Objective (RTO) measures the maximum acceptable time to restore a database after failure. True or False?

True

False

20. Which of the following is a synchronous replication method used in high-availability databases?

Log shipping

Mirroring

Snapshot replication

Change data capture

DataSys+ Failover and High Availability for Databases Quiz

1. Which of these is NOT a common database failover mechanism?

2.

What first name or nickname would you like us to use?

2. A cold standby database requires significant time to initialize before becoming the primary after a failure. True or False?

3. Which technology prevents split-brain in a three-node cluster by requiring a majority of nodes to agree?

4. In a ____ replication model, all nodes can accept write operations independently.

5. What is the primary benefit of using a virtual IP (VIP) in database failover?

6. Log shipping is an example of synchronous replication. True or False?

7. Which statement best describes the relationship between RTO and RPO?

8. A ____ failover occurs without manual intervention when the system automatically detects a failure.

9. Heartbeat monitoring in a failover cluster detects node failures by periodically checking node availability. True or False?

10. In a multi-master replication setup, how are conflicting writes typically resolved?

11. What is the primary purpose of database failover in a high-availability system?

12. A ____ is a pre-configured instance ready to assume the primary role immediately upon failover.

13. Split-brain scenarios in database clusters occur when network partitioning causes two isolated groups to believe they are the primary. True or False?

14. Which replication topology involves multiple replicas receiving updates from a single source?

15. Recovery Point Objective (RPO) is defined as the maximum acceptable amount of ____.

16. What is the key advantage of using a warm standby database in disaster recovery?

17. Asynchronous replication in databases carries a higher risk of data loss than synchronous replication. True or False?

18. In a database cluster, what does a quorum determine?

19. Recovery Time Objective (RTO) measures the maximum acceptable time to restore a database after failure. True or False?

20. Which of the following is a synchronous replication method used in high-availability databases?