Multiple choice technology databases

When denormalizing a table, what are some things to consider? (Select 2)

  1. Downtime

  2. Stability

  3. Performance

  4. Volatility
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

Performance is the primary motivation for denormalization - reducing joins improves read speed. Volatility is equally critical - frequently changing data causes update anomalies and maintenance overhead in denormalized structures. Downtime and stability are operational concerns, not architectural considerations for denormalization.

Keep practicing — related questions