Machine-translated by Google. Questions are authored in English.
Top

Discussion

A data warehouse is a database system that is optimized for operational transaction processing.

  • A.True
  • B.False

Answer: B

Correct answer: False

A data warehouse is optimised for the opposite of transaction processing. Operational databases are tuned for many small fast writes and are normalised to protect integrity; a warehouse is tuned for large analytical reads, is usually denormalised into star schemas, and is loaded in batches rather than updated continuously.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.