As a Fabric Analytics Engineer, you are responsible for implementing two dimension tables named Customers and Products in a Fabric data warehouse. To manage the versioning of data effectively, you must use a Slowly Changing Dimension (SCD) approach. Ensure that the solution adheres to the requirements specified in the table below. Determine the most appropriate type of SCD to use for each table based on these requirements.

Static table: Type 0 – Fixed Dimension. No changes allowed, dimension never changes.

Commonly used SCD types: Type 1 – No History. Update record directly, there is no record of historical values, only current state. Type 2 – Row Versioning. Type 3 – Previous Value column.

Rarely used: Type 4 – History Table. Type 6 – Hybrid SCD.

Which type of SCD should you implement for each of the dimension tables?