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

18.8. REVIEW QUESTIONS

  1. List any four of the physical design steps. For two of the selected four, describe the activities.

  2. Name the physical design objectives. Which objective do you think ranks as the most important?

  3. What are the components that make up the physical model? How are these related to components of the logical model?

  4. Give two reasons why naming standards are important in a data warehouse environment.

  5. List any three techniques for optimizing storage. Describe these briefly.

  6. What is index-only read? How does it improve performance?

  7. Give two reasons why B-Tree indexing is superior to other indexing methods.

  8. What is meant by the selectivity for a column in a physical table? What type of indexing technique is suitable for low-selectivity data? Why?

  9. What is data partitioning? Give two reasons why data partitioning is helpful in a data warehousing environment.

  10. What is data clustering? Give an example.

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