In the data warehouse for Adventure Works, the company should track changes in sales territories over time to ensure historical facts are associated with the correct territory. Which slow- changing…

The correct answer is B. Type 2 SCD. Option B is correct because Type 2 SCD is the correct choice for this scenario. It supports versioning of dimension members using a surrogate key to uniquely reference each version. It includes columns like StartDate and EndDate to define the date range validity of each…

Submitted by layla.eg· Apr 18, 2026Plan, implement, and manage a solution for data analytics

Question

In the data warehouse for Adventure Works, the company should track changes in sales territories over time to ensure historical facts are associated with the correct territory. Which slow- changing dimension (SCD) type should be used to support the versioning of vendors and their associated areas, using a surrogate key to define the date range validity of each version and including columns?

Options

AType 1 SCD
BType 2 SCD
CType 3 SCD
DType 6 SCD

How the community answered

(37 responses)

A
5% (2)
B
92% (34)
D
3% (1)

Explanation

Option B is correct because Type 2 SCD is the correct choice for this scenario. It supports versioning of dimension members using a surrogate key to uniquely reference each version. It includes columns like StartDate and EndDate to define the date range validity of each version. This ensures that historical facts, such as sales by salesperson, remain associated with the correct region even when salespeople relocate. https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure- synapse-analytics-pipelines/3-choose-between-dimension-types

Topics

#SCD Type 2#Dimension Modeling#Data Warehousing#Historical Data

Community Discussion

No community discussion yet for this question.

Full DP-600 Practice