Question 33

A distributed database is needed to ensure high availability during outages.

A distributed database allows data to be stored across multiple locations, ensuring accessibility and reliability even during local or regional outages. This architecture enhances fault tolerance and minimizes downtime.

A) Distributed

This option is correct as a distributed database is specifically designed to handle high availability and fault tolerance by distributing data across multiple servers or locations. In the event of an outage in one area, the system can continue to function using data from other distributed nodes.

B) Cloud

While cloud databases can offer high availability, the term is broader and encompasses various types of database architectures, including relational and distributed. A cloud database might not inherently guarantee the same level of fault tolerance as a specifically designed distributed database.

C) Relational

A relational database typically stores data in a structured format but may not be inherently designed for high availability across multiple locations. While some relational databases can be configured for high availability, they do not automatically provide the distributed capabilities that ensure data remains accessible during outages.

D) Flat-file

Flat-file databases are simple and store data in a single file without complex structures. They are not suited for high availability or fault tolerance, as they do not have the capability to distribute data across multiple locations, making them vulnerable during outages.

Conclusion

A distributed database is the optimal choice for the need described, as it is designed to maintain high availability and reliability even in adverse conditions. Other options either lack the necessary architecture for high availability or do not specifically address the requirements outlined in the scenario.