Eladio Rocha
Quiz por , criado 16 dias atrás

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.

2
0
0
Eladio Rocha
Criado por Eladio Rocha 16 dias atrás
Fechar

CAP Theorem and Database Trade-offs

Questão 1 de 8

1

What aspect of the CAP theorem does MongoDB trade off?

Selecione uma das seguintes:

  • Consistency

  • Availability

  • Partition tolerance

  • Scalability

Explicação

Questão 2 de 8

1

Why does MongoDB experience a brief period of downtime during server failure?

Selecione uma das seguintes:

  • 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.

Explicação

Questão 3 de 8

1

Which part of the CAP theorem does Cassandra sacrifice?

Selecione uma das seguintes:

  • Consistency

  • Availability

  • Partition tolerance

  • Fault tolerance

Explicação

Questão 4 de 8

1

Why is Cassandra highly available?

Selecione uma das seguintes:

  • 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.

Explicação

Questão 5 de 8

1

When designing a database system, what is a critical first step in choosing a database technology?

Selecione uma das seguintes:

  • Picking the most popular database solution.

  • Ensuring consistency at all costs.

  • Understanding the system’s specific requirements.

  • Using a database that maximizes partition tolerance.

Explicação

Questão 6 de 8

1

In what scenario is it acceptable to choose a database that sacrifices availability?

Selecione uma das seguintes:

  • 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.

Explicação

Questão 7 de 8

1

Which database technologies are examples of solutions that balance CAP trade-offs effectively for general-purpose use?

Selecione uma das seguintes:

  • Cassandra and PostgreSQL

  • MongoDB and DynamoDB

  • Oracle and SQLite

  • Redis and MySQL

Explicação

Questão 8 de 8

1

Why is it important to discuss database trade-offs in system design interviews?

Selecione uma das seguintes:

  • 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.

Explicação