nerdexam
GAQM

CITM-001 · Question #27

Which three are the advantages of Distributed Database? (Choose three)

The correct answer is A. Increase Availability B. Easier Expansion D. Improved Performance. Distributed databases provide several advantages over centralized databases, including improved scalability, availability, performance, flexibility, fault tolerance, and security. Here are some of the advantages of distributed databases: Increased availability: Distributed…

IT Operations and Infrastructure Management

Question

Which three are the advantages of Distributed Database? (Choose three)

Options

  • AIncrease Availability
  • BEasier Expansion
  • CEasy to scale
  • DImproved Performance

How the community answered

(32 responses)
  • A
    88% (28)
  • C
    13% (4)

Explanation

Distributed databases provide several advantages over centralized databases, including improved scalability, availability, performance, flexibility, fault tolerance, and security. Here are some of the advantages of distributed databases: Increased availability: Distributed databases can tolerate failures of individual nodes or sites without affecting the overall system functionality. Users can access data from other sites if their local site is down or unreachable. Data replication and backup mechanisms can also enhance data availability and recovery. Easier expansion: Distributed databases can be scaled horizontally by adding more nodes to the network. This allows for increased capacity and performance as data and user demand grow. Adding new sites or units to the distributed system does not require significant efforts or disruption in the existing functions. Improved performance: Distributed databases can offer faster response and lower communication costs by locating data near the users who normally use that data. Distributed query processing and transaction management can also optimize the use of network and computing resources. Furthermore, distributed databases can exploit the parallelism of multiple nodes to execute operations concurrently.

Topics

#distributed database#high availability#scalability#performance optimization

Community Discussion

No community discussion yet for this question.

Full CITM-001 Practice