Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-700 Exam - Topic 3 Question 30 Discussion

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?
D) a hash function to compare the attributes in the source table.
A) a direct attributes comparison for the attributes in the source table.
B) a hash function to compare the attributes in the DimCustomer table.
C) a direct attributes comparison across the attributes in the DimCustomer table.

Microsoft DP-700 Exam - Topic 3 Question 30 Discussion

Actual exam question for Microsoft's DP-700 exam
Question #: 30
Topic #: 3
[All DP-700 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: D

by Luke at Jun 01, 2026, 10:39 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Zoila
3 days ago
Wait, can a hash function really handle 20 million rows efficiently?
upvoted 0 times
...
Stefany
8 days ago
I disagree, direct comparison seems more straightforward.
upvoted 0 times
...
Carmen
13 days ago
I think option B is the best choice. Hash functions are efficient!
upvoted 0 times
...
Kerry
18 days ago
I lean towards option B, but I wonder if comparing the source table instead would yield better results. I need to double-check my notes on this.
upvoted 0 times
...
Lavonda
23 days ago
I'm a bit confused about whether to compare attributes directly or use a hash. I feel like both could work, but one might be better for performance.
upvoted 0 times
...
Gilma
29 days ago
I remember practicing a similar question where we had to minimize resource usage, and I think a hash function could help with that.
upvoted 0 times
...
Barrie
1 month ago
I think using a hash function to compare attributes in the DimCustomer table makes sense, but I'm not entirely sure if it's the most efficient option.
upvoted 0 times
...

Save Cancel