40081826
Beschreibung
Quiz von Eladio Rocha, aktualisiert vor 18 Tage
|
Erstellt von Eladio Rocha
vor 19 Tage
|
|
Frage 1
Frage
What is the primary purpose of a router in a scalable database design?
Antworten
-
To perform joins between shards.
-
To route client requests to the appropriate shard.
-
To store backup configurations for shards.
-
To hash keys for partitioning data.
Frage 2
Frage
What is a "shard" in the context of databases?
Antworten
-
A method of encrypting sensitive data.
-
A backup server in a replica set.
-
A horizontal partition of a database.
-
A tool for monitoring database traffic.
Frage 3
Frage
What is a major advantage of sharding in database systems?
Antworten
-
It eliminates the need for backups.
-
It increases both scalability and redundancy.
-
It simplifies complex SQL queries.
-
It reduces the need for a router.
Frage 4
Frage
What is a replica set in MongoDB?
Antworten
-
A set of configuration servers.
-
A collection of shards distributed across regions.
-
A primary server and its associated secondary servers for redundancy.
-
A group of shards that handle write-heavy traffic.
Frage 5
Frage
How does MongoDB ensure high availability when a primary server fails?
Antworten
-
Traffic is rerouted to the config server.
-
Secondary servers automatically elect a new primary.
-
The router assigns new shards dynamically.
-
The primary server is rebooted automatically.
Frage 6
Frage
What does "eventual consistency" mean in the context of Cassandra?
Antworten
-
Data is always immediately consistent across all nodes.
-
Data might take time to propagate across nodes, leading to temporary inconsistencies.
-
Data must be manually synchronized across nodes.
-
Consistency is not guaranteed due to system failures.
Frage 7
Frage
What is the "celebrity problem" in sharded databases?
Antworten
-
High traffic on specific shards causes uneven load distribution.
-
Celebrities’ data is stored differently for security reasons.
-
All shards are overloaded with high read and write requests.
-
Certain shards fail to replicate data efficiently.
Frage 8
Frage
What is re-sharding, and why is it challenging?
Antworten
-
Redistributing data when adding or removing shards, which requires fault-tolerant methods.
-
Creating backups for new shards added to the system.
-
Replicating data across all shards during traffic spikes.
-
Distributing write-heavy traffic across existing shards.
Frage 9
Frage
What is a key advantage of using a normalized database schema?
Antworten
-
It minimizes storage space and simplifies updates.
-
It allows faster reads with fewer database hits.
-
It duplicates data for high performance.
-
It eliminates the need for joins between tables.
Frage 10
Frage
Why might denormalized data be preferred in a NoSQL database?
Antworten
-
It reduces redundancy and improves update efficiency..
-
It allows for single-query retrieval of all necessary data.
-
It enforces strict schema rules.
-
It is easier to scale horizontally.
Frage 11
Frage
What should you prioritize when designing a horizontally scalable database?
Antworten
-
Using as many joins as possible for efficiency.
-
Designing around simple key-value lookups to avoid joins.
-
Avoiding hash functions for data distribution.
-
Relying heavily on a single primary server for consistency.
Frage 12
Frage
Which database systems are examples of NoSQL?
Antworten
-
PostgreSQL and MySQL.
-
MongoDB, Cassandra, and DynamoDB.
-
Oracle and SQLite.
-
Redis and HBase and SQLite
Frage 13
Frage
In what scenarios might you choose to use normalized data over denormalized data in a NoSQL database?
Antworten
-
When updates are frequent and space efficiency is important.
-
When scaling horizontally is a top priority.
-
When high traffic requires fewer database hits.
-
When you need to perform complex joins efficiently.
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.