15.7. REVIEW QUESTIONS

  1. Briefly explain multidimensional analysis.

  2. Name any four key capabilities of an OLAP system.

  3. State any five of Dr. Codd's guidelines for an OLAP system, giving a brief description for each.

  4. What are hypercubes? How do they apply in an OLAP system?

  5. What is meant by slice-and-dice? Give an example.

  6. What are the essential differences between the MOLAP and ROLAP models? Also list a few similarities.

  7. What are multidimensional databases? How do these store data?

  8. Describe anyone of the four OLAP architectural options.

  9. Discuss two reasons why feeding data into the OLAP system directly from the source operational systems is not recommended.

  10. Name any four factors for consideration in OLAP administration.

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial