Microsoft DP-700 Exam - Topic 2 Question 28 Discussion

Actual exam question for Microsoft's DP-700 exam

Question #: 28
Topic #: 2

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?

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

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

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

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

Show Suggested Answer

Suggested Answer: D

by Mica at May 03, 2026, 03:35 PM

Limited Time Offer

25%

Off

Get Premium DP-700 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!