DP-700 · Question #91
DP-700 Question #91: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #91. The question stem and answer options stay visible for context.
Question
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?
Options
- Aa hash function to compare the attributes in the source table.
- Ba direct attributes comparison across the attributes in the DimCustomer table.
- Ca direct attributes comparison for the attributes in the source table.
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.