CAP Theorem and Database Trade-offs

Descrição

This quiz focuses on the CAP theorem and database trade-offs, covering MongoDB and Cassandra's approaches to consistency, availability, and partition tolerance. It emphasizes understanding system requirements to make informed database choices in design scenarios.
Eladio Rocha
Quiz por Eladio Rocha, atualizado 16 dias atrás
Eladio Rocha
Criado por Eladio Rocha 16 dias atrás
2
0

Resumo de Recurso

Questão 1

Questão
What aspect of the CAP theorem does MongoDB trade off?
Responda
  • Consistency
  • Availability
  • Partition tolerance
  • Scalability

Questão 2

Questão
Why does MongoDB experience a brief period of downtime during server failure?
Responda
  • The entire database must reboot.
  • Data replication halts temporarily.
  • The system must detect the outage and elect a new primary host.
  • Config servers need to reinitialize.

Questão 3

Questão
Which part of the CAP theorem does Cassandra sacrifice?
Responda
  • Consistency
  • Availability
  • Partition tolerance
  • Fault tolerance

Questão 4

Questão
Why is Cassandra highly available?
Responda
  • It replicates data across all nodes in real time.
  • It avoids having a single master node.
  • It requires all nodes to stay online simultaneously.
  • It partitions data only when a node fails.

Questão 5

Questão
When designing a database system, what is a critical first step in choosing a database technology?
Responda
  • Picking the most popular database solution.
  • Ensuring consistency at all costs.
  • Understanding the system’s specific requirements.
  • Using a database that maximizes partition tolerance.

Questão 6

Questão
In what scenario is it acceptable to choose a database that sacrifices availability?
Responda
  • When downtime longer than a few minutes is acceptable.
  • When the system requires eventual consistency.
  • When a few seconds of downtime is acceptable.
  • When the system does not need to scale horizontally.

Questão 7

Questão
Which database technologies are examples of solutions that balance CAP trade-offs effectively for general-purpose use?
Responda
  • Cassandra and PostgreSQL
  • MongoDB and DynamoDB
  • Oracle and SQLite
  • Redis and MySQL

Questão 8

Questão
Why is it important to discuss database trade-offs in system design interviews?
Responda
  • It shows familiarity with coding techniques.
  • It demonstrates an understanding of scalability tools.
  • It highlights an ability to make informed technical decisions.
  • It ensures the interviewer agrees with your database choice.

Semelhante

ACID Compliance and CAP Theorem
Eladio Rocha
liderazgo
ROuz De La ROza
conflicto y negacion
ROuz De La ROza
Introducción a MongoDB
Jose Julian Ariza V.
Scalable Systems and Database Redundancy
Eladio Rocha
Scaling Systems from Zero to Millions of Users
Eladio Rocha
comportamiento grupal
ROuz De La ROza
Data Lakes and Big Data Systems
Eladio Rocha
Modern Scalable Databases
Eladio Rocha
Scalable System Architectures
Eladio Rocha