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.


Correct Option: B
Explanation:

To answer this question, the user needs to understand what OLAP means and the characteristics of an OLAP data structure.

OLAP stands for Online Analytical Processing. It is a technology used to store and analyze large amounts of data in a multidimensional format. OLAP data structures are designed to support complex queries and analysis of data.

Now, let's go through each option and explain why it is right or wrong:

A. Comprised of normalized dimension and fact tables.

This option is incorrect. While OLAP data structures do use dimension and fact tables, they are not necessarily normalized. In fact, OLAP data structures use denormalized tables to improve performance.

B. Organizes dimension tables into hierarchies and levels.

This option is correct. OLAP data structures are designed to organize dimension tables into hierarchies and levels to enable quick and easy analysis of data.

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

This option is incorrect. While OLAP data structures are designed to support complex queries and analysis of data, they are not typically used for real-time analysis. OLAP systems are often updated on a regular basis, rather than in real-time, to improve performance.

D. Cardinality between tables is typically configured as inner joins.

This option is incorrect. While inner joins are often used in OLAP data structures, other types of joins can also be used depending on the specific requirements of the system.

Therefore, the correct answer is:

The Answer is: B. Organizes dimension tables into hierarchies and levels.

Find more quizzes: