Database Sharding: Strategies & Implementation Basics
A beginner's quiz on the fundamental concepts and strategies of database sharding.
Questions in this quiz
15 questions on Database Sharding: Strategies & Implementation Basics. Work through them here, then start the quiz to answer them and see your score.
1.What is database sharding?
- AA way to backup data to the cloud
- BA method to replicate data across multiple databases
- CA process to encrypt data in a database
- DA technique to split a database into smaller, more manageable pieces
2.Which of the following is a common benefit of sharding?
- AIncreased data redundancy
- BImproved query performance
- CSimplified database schema
- DReduced data security
3.Which strategy involves distributing data based on a specific attribute, such as user ID?
- AVertical sharding
- BRange-based sharding
- CHorizontal sharding
- DHash-based sharding
4.What is a potential drawback of sharding?
- AReduced storage requirements
- BComplexity in query operations
- CIncreased data consistency
- DSimplified database management
5.Which of the following is NOT a sharding strategy?
- ATime-based sharding
- BRange-based sharding
- CHash-based sharding
- DGeographic sharding
6.In which scenario is database sharding most beneficial?
- AA static website with no database
- BA single-user desktop application
- CA small application with minimal data
- DA large-scale application with high traffic
7.What is a shard key?
- AA backup key for restoring shards
- BA unique identifier for each shard
- CAn attribute used to determine the shard placement
- DA key used to encrypt database shards
8.Which of the following is a challenge when implementing sharding?
- ASimplified database queries
- BIncreased data redundancy
- CMaintaining data consistency
- DReduced hardware costs
9.What is vertical sharding?
- ASplitting data into different tables based on columns
- BDividing data into different tables based on rows
- CDistributing data across different geographic locations
- DReplicating data across multiple databases
10.Which sharding strategy uses a range of values to distribute data?
- AGeographic sharding
- BRange-based sharding
- CVertical sharding
- DHash-based sharding
11.What is one way to handle data consistency in a sharded database?
- AUsing a single shard for all data
- BAvoiding data replication
- CImplementing a distributed transaction system
- DStoring all data in-memory
12.Which of the following is a common use case for sharding?
- AA single-user spreadsheet application
- BA global social media platform
- CA local file storage system
- DA small personal blog
13.How does sharding affect database scalability?
- AIt reduces scalability
- BIt has no effect on scalability
- CIt improves scalability by distributing data
- DIt limits scalability to a single server
14.What is a key consideration when choosing a shard key?
- AThe shard key should be a constant value
- BThe shard key should be a primary key
- CThe shard key should be the same for all rows
- DThe shard key should evenly distribute data
15.Which of the following best describes horizontal sharding?
- AReplicating data across multiple databases
- BDividing data into different tables based on rows
- CDistributing data across different geographic locations
- DSplitting data into different tables based on columns