You are implementing a medallion architecture in a Fabric lakehouse. You plan to create a dimension table that will contain the following columns: ID CustomerCode CustomerName CustomerAddress…

Type 2 SCDs track full history by adding new rows with `ValidFrom` and `ValidTo` dates for each change, which is the standard approach for full historical context and typically suggested by the presence of such columns.

Type 0 SCDs mean the dimension attributes never change or changes are not tracked, which does not meet the requirement of analyzing historical locations.

Type 1 SCDs overwrite existing attribute values, meaning historical values are lost, making it unsuitable for analyzing historical sales by previous customer locations.

Type 3 SCDs allow tracking a limited history, usually the current and one previous value for a specific attribute like `CustomerLocation`, by adding new columns to the dimension table (e.g., `CurrentCustomerLocation`, `PreviousCustomerLocation`). This design enables direct comparison of a customer's location at the time of sale with their immediately preceding location, which can be useful for certain historical analyses, even if `ValidFrom` and `ValidTo` columns are also present for broader record validity.