Introduction to Database Sharding for Horizontal Scaling
A beginner's quiz on database sharding strategies for horizontal scaling.
Questions in this quiz
15 questions on Introduction to Database Sharding for Horizontal Scaling. Work through them here, then start the quiz to answer them and see your score.
1.What is database sharding?
- AA method to vertically scale a database
- BA method to horizontally partition a database
- CA method to encrypt a database
- DA method to backup a database
2.Which of the following is a benefit of database sharding?
- AReduced data redundancy
- BSimplified database schema
- CIncreased security
- DImproved query speed
3.What is a common challenge associated with sharding?
- AReduced data consistency
- BHigher storage costs
- CComplexity in data distribution
- DIncreased latency
4.Which strategy involves distributing data based on a hash function?
- ARange-based sharding
- BHash-based sharding
- CKey-based sharding
- DDirectory-based sharding
5.What is range-based sharding?
- ASharding data based on a hash function
- BSharding data based on user roles
- CSharding data based on a specific range of values
- DSharding data based on the size of data
6.Which of the following is NOT a sharding strategy?
- AGeographical sharding
- BRange-based sharding
- CVertical sharding
- DHash-based sharding
7.How does sharding affect database availability?
- AHas no effect
- BOnly affects availability during peak hours
- CDecreases availability
- DIncreases availability
8.What is a shard key?
- AA key used to determine data distribution across shards
- BA key used to backup shard data
- CA key used to join shards
- DA key used to encrypt data in a shard
9.Why might a company choose to implement sharding?
- ATo simplify database queries
- BTo handle increased load and scale horizontally
- CTo improve data security
- DTo reduce hardware costs
10.Which of the following best describes 'hot spots' in sharding?
- AShards that contain outdated data
- BShards that are underutilized
- CAreas of the database that are frequently accessed
- DAreas of the database with security vulnerabilities
11.What is a potential downside of hash-based sharding?
- AReduced data security
- BIncreased data redundancy
- CDifficulty in adding new shards
- DComplex query processing
12.In sharding, what is a 'split' operation?
- ACombining two shards into one
- BDeleting data from a shard
- CDividing a shard into smaller shards
- DMoving data from one shard to another
13.Which of the following is true about directory-based sharding?
- AIt is the simplest form of sharding
- BIt uses a central directory to map data to shards
- CIt distributes data based on hash functions
- DIt requires no central management
14.What is an advantage of range-based sharding?
- AUniform data distribution
- BAutomatic data redundancy
- CSimple to implement and understand
- DNo need for a central directory
15.How does sharding impact database maintenance?
- AIncreases maintenance complexity
- BSimplifies maintenance tasks
- CHas no impact
- DReduces maintenance needs