Multiple choice technology databases

Which two data demographics should you consider when deciding whether or not to store or calculate derived data? (Select 2)

  1. Maximum Number of NULLs

  2. Access Frequency

  3. Change Rating

  4. Typical Rows Per Value
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

When deciding whether to store derived data or calculate it on the fly, access frequency is a key factor - frequently accessed data benefits from storage. Change rating (volatility) is equally important - data that changes often is better calculated to avoid stale values. Maximum NULLs and rows per value are not primary considerations for this decision.

Keep practicing — related questions