CAP Theorem and Database Trade-offs

Descripción

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
Test por Eladio Rocha, actualizado hace más de 1 año
Eladio Rocha
Creado por Eladio Rocha hace casi 2 años
73
0

Resumen del Recurso

Pregunta 1

Pregunta
What aspect of the CAP theorem does MongoDB trade off?
Respuesta
  • Consistency
  • Availability
  • Partition tolerance
  • Scalability

Pregunta 2

Pregunta
Why does MongoDB experience a brief period of downtime during server failure?
Respuesta
  • 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.

Pregunta 3

Pregunta
Which part of the CAP theorem does Cassandra sacrifice?
Respuesta
  • Consistency
  • Availability
  • Partition tolerance
  • Fault tolerance

Pregunta 4

Pregunta
Why is Cassandra highly available?
Respuesta
  • 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.

Pregunta 5

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

Pregunta 6

Pregunta
In what scenario is it acceptable to choose a database that sacrifices availability?
Respuesta
  • 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.

Pregunta 7

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

Pregunta 8

Pregunta
Why is it important to discuss database trade-offs in system design interviews?
Respuesta
  • 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.
Mostrar resumen completo Ocultar resumen completo

Similar

Test para Practicar para el TOEFL
Lolo Reyes
Readings para Preparar el First Certificate (I)
maya velasquez
Fichas de Inglés - Vocabulario Intermedio 2
maya velasquez
Vocabulario Inglés - Tema 2
tanianicolasizqu
Inglés - Verbos Compuestos II (Phrasal Verbs)
maya velasquez
Fichas de Inglés - Vocabulario Intermedio
maya velasquez
Inglés - Conjugación Verbos Irregulares
maya velasquez
Test de Nombres de Alimentos en Inglés
maya velasquez
Test de Nombres de Alimentos en Inglés
Virginia Vera
Verbos Culinarios Inglés-Español
Diego Santos
Gramática para Practicar el First Certificate II
Diego Santos