You have a Fabric warehouse named DW1 that contains a Type 2 slowly changing dimension...

Vendor: Microsoft
Product: DP-700
Update on: May 3, 2026
Questions: 113

Microsoft DP-700 Question Answer

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 to the table and update the records when there is a change. The solution must minimize resource consumption.

What should you use to identify changes to attributes?

a direct attributes comparison for the attributes in the source table.

a hash function to compare the attributes in the DimCustomer table.

a direct attributes comparison across the attributes in the DimCustomer table.

a hash function to compare the attributes in the source table.