IBM SPSS Statistics Level 1 v2 — Question 13

Which Slowly Changing Dimension (SCD) stage statement is TRUE?

Answer options

• A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database
• B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching
• C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.
• D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link

Correct answer: B

Explanation

The correct answer, B, is true because each SCD stage indeed processes multiple dimensions and uses equality matching for lookups. Option A is incorrect as surrogate keys are typically used in star schema rather than normalized schemas. Option C is misleading because while purpose codes may be relevant, they are not a defining feature of the SCD stage's operation. Option D is inaccurate because actual dimension changes may not always be applied directly to the lookup table in memory.