40081826
Descrição
Quiz por Eladio Rocha, atualizado 18 dias atrás
|
Criado por Eladio Rocha
19 dias atrás
|
|
Questão 1
Questão
What is the primary purpose of a router in a scalable database design?
Responda
-
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.
Questão 2
Questão
What is a "shard" in the context of databases?
Responda
-
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.
Questão 3
Questão
What is a major advantage of sharding in database systems?
Responda
-
It eliminates the need for backups.
-
It increases both scalability and redundancy.
-
It simplifies complex SQL queries.
-
It reduces the need for a router.
Questão 4
Questão
What is a replica set in MongoDB?
Responda
-
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.
Questão 5
Questão
How does MongoDB ensure high availability when a primary server fails?
Responda
-
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.
Questão 6
Questão
What does "eventual consistency" mean in the context of Cassandra?
Responda
-
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.
Questão 7
Questão
What is the "celebrity problem" in sharded databases?
Responda
-
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.
Questão 8
Questão
What is re-sharding, and why is it challenging?
Responda
-
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.
Questão 9
Questão
What is a key advantage of using a normalized database schema?
Responda
-
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.
Questão 10
Questão
Why might denormalized data be preferred in a NoSQL database?
Responda
-
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.
Questão 11
Questão
What should you prioritize when designing a horizontally scalable database?
Responda
-
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.
Questão 12
Questão
Which database systems are examples of NoSQL?
Responda
-
PostgreSQL and MySQL.
-
MongoDB, Cassandra, and DynamoDB.
-
Oracle and SQLite.
-
Redis and HBase and SQLite
Questão 13
Questão
In what scenarios might you choose to use normalized data over denormalized data in a NoSQL database?
Responda
-
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.
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.