All Questions
Data Modeling easy

What is the main risk of storing the same data in two different places (Redundancy)?

  1. A It consumes excessive CPU cycles as the database engine must struggle to keep multiple copies of the same record perfectly synchronized in memory.
  2. B It requires significant amounts of additional RAM to store the redundant internal pointers that the database uses to track duplicated data blocks.
  3. C It creates a risk of Data Inconsistency, where updating a record in one location but failing to update its duplicates leads to conflicting truths.
  4. D It dramatically slows down the automated background backup process by forcing the system to perform complex deduplication on every binary file.

One system design question a day, with spaced repetition so the ones you miss come back.

Get the app

Related questions