You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension (SCD) dimension table named DimCustomer. DimCustomer contains 100 columns and 20 million rows. The columns are of various data types, including int, varchar, date, and varbinary. You need to identify incoming changes from the source table to DimCustomer and update the records when there is a change. The solution must minimize resource consumption. What should you use to identify changes to attributes? (Choose one answer)

• A. a hash function to compare the attributes in the DimCustomer table.
• B. a direct attributes comparison across the attributes in the DimCustomer table.
• C. a direct attributes comparison for the attributes in the source table.
• D. a hash function to compare the attributes in the source table.

Correct Answer: A

Brave-Dump Clients Votes