nerdexam
CompTIA

CV0-004 · Question #391

A cloud engineer must improve the availability of a database for an application. The database must meet the following requirements: - Failover capability in case of a data center outage…

The correct answer is D. Multi-availability zone database instance. A multi-availability zone (Multi-AZ) database instance deploys a primary database in one data center and a synchronous standby replica in a separate, geographically distinct availability zone. If the primary data center experiences an outage, the database automatically fails…

Cloud architecture

Question

A cloud engineer must improve the availability of a database for an application. The database must meet the following requirements:

  • Failover capability in case of a data center outage
  • Point-in-time data restoration capabilities

Which of the following best meets these requirements?

Options

  • AClustered database instance
  • BCached Redis cluster
  • CDatabase instance replica
  • DMulti-availability zone database instance

How the community answered

(30 responses)
  • A
    13% (4)
  • B
    3% (1)
  • C
    7% (2)
  • D
    77% (23)

Explanation

A multi-availability zone (Multi-AZ) database instance deploys a primary database in one data center and a synchronous standby replica in a separate, geographically distinct availability zone. If the primary data center experiences an outage, the database automatically fails over to the standby with minimal downtime - satisfying the failover requirement. Multi-AZ configurations also typically include automated backups that support point-in-time recovery. A clustered database instance improves performance and availability within a single AZ but does not protect against full data center failures. A Redis cluster is a caching solution, not a durable primary database. A read replica offloads read traffic but does not provide automatic failover.

Topics

#High Availability#Disaster Recovery#Point-in-time Recovery#Multi-AZ Databases

Community Discussion

No community discussion yet for this question.

Full CV0-004 Practice