Advanced
Database Management Systems
Q89 / 100
What is write amplification in database storage engines?
Correct! Well done.
Incorrect.
The correct answer is B) The ratio of data written to storage vs. data actually written by the application — caused by compaction, journaling, and copy-on-write mechanisms
B
Correct Answer
The ratio of data written to storage vs. data actually written by the application — caused by compaction, journaling, and copy-on-write mechanisms
Explanation
A single 4KB write may cause 20KB of actual storage writes (WAL write, B-tree page write, checkpoint). LSM-tree compaction amplifies writes. High write amplification wears SSDs faster and reduces throughput.
Progress
89/100