13.7. REVIEW QUESTIONS

  1. List five reasons why you think data quality is critical in a data warehouse.

  2. Explain how data quality is much more than just data accuracy. Give an example.

  3. Briefly list three benefits of quality data in a data warehouse.

  4. Give examples of four types of data quality problems.

  5. What is the problem related to the reuse of primary keys? When does it usually occur?

  6. Describe the functions of data correction in data cleansing tools.

  7. Name five common sources of data pollution. Give an example for each type of source.

  8. List six types of error discovery features found in data cleansing tools.

  9. What is the "clean as you go" method? Is this a good approach for the data warehouse environment?

  10. Name any three types of participants on the data quality team. What are their functions?

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