Database Sharding and Partitioning Questions and Answers PDF

Add the following multiple choice questions and answers and explanations verbatim (DO NOT change the given wording). ========================================== New Question 1: What is the primary purpose of database sharding in improving system throughput? Choice A: To reduce the size of individual...

Add the following multiple choice questions and answers and explanations verbatim (DO NOT change the given wording). ========================================== New Question 1: What is the primary purpose of database sharding in improving system throughput? Choice A: To reduce the size of individual database tables. Choice B: To distribute data across multiple servers, increasing data processing capacity. Choice C: To encrypt data for enhanced security. Choice D: To compress data and save storage space. Correct answer: B Explanation: Database sharding involves distributing data across multiple servers or instances. This horizontal partitioning allows the system to handle more data and process requests in parallel, thereby increasing the overall data processing capacity and improving throughput. ========================================== New Question 2: How does database partitioning contribute to system throughput? Choice A: By combining multiple databases into a single large database. Choice B: By splitting a database into smaller, more manageable pieces to allow parallel processing. Choice C: By increasing the redundancy of data across servers. Choice D: By enhancing the security protocols of the database. Correct answer: B Explanation: Database partitioning involves dividing a large database into smaller, more manageable segments or partitions. This allows for parallel processing of queries and transactions, which can significantly increase the system's throughput by handling more operations simultaneously. ========================================== New Question 3: What advantage do in-memory databases provide in terms of system performance? Choice A: They offer higher storage capacity compared to traditional databases. Choice B: They reduce the cost of data storage. Choice C: They provide faster data access and processing by storing data in RAM. Choice D: They ensure data persistence even during power outages. Correct answer: C Explanation: In-memory databases store data directly in the system's RAM rather than on disk storage. This allows for much faster data access and processing speeds, as accessing data from memory is significantly quicker than reading from disk. Consequently, in-memory databases enhance system performance and throughput, especially for data-intensive applications. ==========================================