Multiple choice technology

Which of the following is true of an OLAP data structure?

  1. Comprised of normalized dimension and fact tables.

  2. Organizes dimension tables into hierarchies and levels.

  3. Allows "real time" analysis against disparate data sources.

  4. Cardinality between tables is typically configured as inner joins.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

OLAP (Online Analytical Processing) structures are designed for fast analysis of multidimensional data from multiple perspectives. While OLAP cubes can aggregate data from various sources for near real-time analysis, option C best describes their core analytical capability. Options A and B describe traditional dimensional modeling, while option D describes table join configuration, not OLAP's defining characteristic.

Keep practicing — related questions