Fundamentals of Database Sharding for Scalability
Explore the basics of database sharding techniques to enhance scalability.
Questions in this quiz
15 questions on Fundamentals of Database Sharding for Scalability. Work through them here, then start the quiz to answer them and see your score.
1.What is database sharding?
- AA process to backup database data
- BA method to split a database into smaller, more manageable pieces
- CA way to compress database files
- DA technique to encrypt data in a database
2.Which of the following is a primary benefit of sharding a database?
- AIncreased data redundancy
- BSimplified database schema
- CReduced need for indexing
- DImproved query performance
3.In a sharded database, what is a shard?
- AA smaller, partitioned piece of the database
- BA backup copy of the database
- CA log of database transactions
- DA temporary cache of database queries
4.Which of the following is a common strategy for determining how to shard data?
- AGeographical sharding
- BTime-based sharding
- CHash-based sharding
- DRandom sharding
5.Why might a company choose to implement database sharding?
- ATo reduce the size of the database files
- BTo decrease the number of database administrators needed
- CTo improve scalability and handle more requests
- DTo simplify database queries
6.What is a potential drawback of implementing database sharding?
- ASimplified database management
- BIncreased data redundancy
- CIncreased complexity in application logic
- DReduced data availability
7.Which of the following is NOT a sharding strategy?
- AHorizontal sharding
- BCircular sharding
- CFunctional sharding
- DVertical sharding
8.How does horizontal sharding work?
- ABy splitting tables into columns
- BBy compressing data into smaller tables
- CBy distributing rows across multiple tables
- DBy duplicating data across shards
9.What is a key consideration when designing a sharding strategy?
- ADatabase color scheme
- BDatabase file format
- COperating system version
- DData distribution and access patterns
10.Which of the following best describes vertical sharding?
- ASplitting a database by rows
- BSplitting a database by columns
- CSplitting a database by users
- DSplitting a database by tables
11.What is a shard key?
- AA backup key for shard data
- BA password to access a shard
- CA unique identifier for each shard
- DA field used to determine the shard for a piece of data
12.Which of the following is a challenge associated with database sharding?
- AComplexity in managing distributed transactions
- BSimplified database queries
- CReduced data redundancy
- DIncreased data consistency
13.What is a common use case for database sharding?
- ASmall-scale applications
- BApplications with low traffic
- CWrite-intensive applications
- DRead-intensive applications
14.How does sharding affect database availability?
- AIt has no effect on availability
- BIt can increase availability by distributing data
- CIt makes data retrieval slower
- DIt decreases availability
15.What is a potential impact of sharding on database maintenance?
- AReduces the frequency of maintenance
- BSimplifies maintenance tasks
- CIncreases the complexity of maintenance
- DEliminates the need for maintenance