Eladio Rocha
Quiz von , erstellt am vor 16 Tage

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
Erstellt von Eladio Rocha vor 16 Tage
Schließen

CAP Theorem and Database Trade-offs

Frage 1 von 8

1

What aspect of the CAP theorem does MongoDB trade off?

Wähle eine der folgenden:

  • Consistency

  • Availability

  • Partition tolerance

  • Scalability

Erklärung

Frage 2 von 8

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 3 von 8

1

Which part of the CAP theorem does Cassandra sacrifice?

Wähle eine der folgenden:

  • Consistency

  • Availability

  • Partition tolerance

  • Fault tolerance

Erklärung

Frage 4 von 8

1

Why is Cassandra highly available?

Wähle eine der folgenden:

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

Erklärung

Frage 5 von 8

1

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

Wähle eine der folgenden:

  • Picking the most popular database solution.

  • Ensuring consistency at all costs.

  • Understanding the system’s specific requirements.

  • Using a database that maximizes partition tolerance.

Erklärung

Frage 6 von 8

1

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

Wähle eine der folgenden:

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

Erklärung

Frage 7 von 8

1

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

Wähle eine der folgenden:

  • Cassandra and PostgreSQL

  • MongoDB and DynamoDB

  • Oracle and SQLite

  • Redis and MySQL

Erklärung

Frage 8 von 8

1

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

Wähle eine der folgenden:

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

Erklärung