Multiple choice technology

What are features of DWH Schema?

  1. used for OLAP,denormalized,easy to navigate

  2. used for OLTP,denormalized,easy to navigate

  3. used for OLAP,normalized,easy to navigate

  4. used for OLAP,denormalized,not easy to navigate
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data warehouse schemas are designed for OLAP (analytical processing) not OLTP, use denormalized structures to optimize query performance, and are organized for easy navigation of business dimensions.

Keep practicing — related questions