Database Failover and High Availability Quiz

1. 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

2. 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

3. 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

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

True

False

5. 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

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

Log shipping

Mirroring

Snapshot replication

Change data capture

7. 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

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

Star topology

Mesh topology

Ring topology

Cascade topology

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

True

False

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

True

False

11. 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

Submit

14. 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

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

True

False

Submit

17. 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

Submit

19. 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

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

True

False

DataSys+ Failover and High Availability for Databases Quiz

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

2.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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