MENU
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?
Suggested Answer: D
Get Premium DP-700 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
17 comments · newest first
CO
Coleen
1 month ago
Exactly, we need to focus on performance.
PE
Pedro
1 month ago
True, but B is more reliable for existing records.
ED
Edgar
1 month ago
D seems interesting too, but it depends on the source table.
OS
Osvaldo
2 months ago
I feel like B is safer for large data sets.
JE
Jesusita
2 months ago
A could work, but it might slow down with 20 million rows.
KE
Keneth
2 months ago
But what about option A? It’s straightforward.
CO
Coleen
2 months ago
I agree, B minimizes resource use. Direct comparisons can be heavy.
PE
Pedro
2 months ago
I think option B is the best choice. Hash functions are efficient.
KE
Keneth
3 months ago
Isn't it risky to rely solely on hash functions for changes?
LI
Linwood
3 months ago
Definitely going with B, it minimizes resource consumption for sure.
ZO
Zoila
3 months ago
Wait, can a hash function really handle 20 million rows efficiently?
ST
Stefany
3 months ago
I disagree, direct comparison seems more straightforward.
CA
Carmen
3 months ago
I think option B is the best choice. Hash functions are efficient!
KE
Kerry
3 months 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.
LA
Lavonda
4 months 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.
GI
Gilma
4 months ago
I remember practicing a similar question where we had to minimize resource usage, and I think a hash function could help with that.
BA
Barrie
4 months 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.