Data Warehousing Fundamentals for IT Professionals

ANSWERS TO SELECTED EXERCISES

CHAPTER 1 THE COMPELLING NEED FOR DATA WAREHOUSING

1 Match the columns

1-D, 2-G, 3-I, 4-F, 5-H, 6-A, 7-J, 8-E, 9-B, 10-C

CHAPTER 2 DATA WAREHOUSE: THE BUILDING BLOCKS 1 Match the columns

1-H, 2-G, 3-J, 4-F, 5-B, 6-I, 7-C, 8-A, 9-E, 10-D

CHAPTER 3 TRENDS IN DATA WAREHOUSING

1 Indicate if true or false

A-T, B-F, C-T, D-F, E-F, F-T, G-F, H-T, I-F, J-F

CHAPTER 4 PLANNING AND PROJECT MANAGEMENT

1 Match the columns

1-D, 2-E, 3-G, 4-H, 5-F, 6-I, 7-J, 8-A, 9-C, 10-B

CHAPTER 5 DEFINING THE BUSINESS REQUIREMENTS

1 Indicate if true or false

A-F, B-T, C-F, D-T, E-T, F-F, G-F, H-F, I-F, J-T

CHAPTER 6 REQUIREMENTS AS THE DRIVING FORCE FOR DATA WAREHOUSING

1 Match the columns

1-H, 2-F, 3-J, 4-A, 5-I, 6-B, 7-E, 8-D, 9-G, 10-C

CHAPTER 7 THE ARCHITECTURAL COMPONENTS

1 Indicate if true or false

A-F, B-T, C-F, D-F, E-F, F-F, G-T, H-F, I-T, J-F

CHAPTER 8 INFRASTRUCTURE AS THE FOUNDATION FOR DATA WAREHOUSING

1 Match the columns

1-F, 2-D, 3-J, 4-A, 5-G, 6-E, 7-B, 8-C, 9-H, 10-I

CHAPTER 9 THE SIGNIFICANT ROLE OF METADATA

1 Indicate if true or false

A-F, B-T, C-F, D-F, E-T, F-T, G-F, H-T, I-T, J-F

CHAPTER 10 PRINCIPLES OF DIMENSIONAL MODELING

1 Match the columns

1-F, 2-I, 3-G, 4-A, 5-J, 6-B, 7-E, 8-C, 9-D, 10-H

CHAPTER 11 DIMENSIONAL MODELING: ADVANCED TOPICS

1 Indicate if true or false

A-T, B-F, C-T, D-F, E-T, F-F, G-T, H-T, I-F, J-T

CHAPTER 12 DATA EXTRACTION, TRANSFORMATION, AND LOADING

1 Match the columns

1-E, 2-G, 3-B, 4-F, 5-J, 6-A, 7-C, 8-H, 9-D, 10-I

CHAPTER 13 DATA ...