O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required