Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-600 All Questions

View all questions & answers for the DP-600 exam
Go to Exam

Exam DP-600 topic 1 question 78 discussion

Actual exam question from Microsoft's DP-600
Question #: 78
Topic #: 1
[All DP-600 Questions]

DRAG DROP
-

You are implementing two dimension tables named Customers and Products in a Fabric warehouse.

You need to use slowly changing dimension (SCD) to manage the versioning of data. The solution must meet the requirements shown in the following table.



Which type of SCD should you use for each table? To answer, drag the appropriate SCD types to the correct tables. Each SCD type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:
by prabhjot at April 5, 2024, 7:33 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
9878eb9
Highly Voted 7 months, 1 week ago
Correct. We need more questions like these. People are forgetting the importance of data modeling. Static table: Type 0 – Fixed Dimension. No changes allowed, dimension never changes. Commonly used SCD types: Type 1 – No History. Update record directly, there is no record of historical values, only current state. Type 2 – Row Versioning. Type 3 – Previous Value column. Rarely used: Type 4 – History Table. Type 6 – Hybrid SCD.
upvoted 35 times
...
prabhjot
Highly Voted 7 months, 3 weeks ago
seems correct and - Type 0 SCD, we ignore any changes and simply audit them Type 1 SCD, we overwrite existing data with new values. Historical versions are not preserved. Type 2 SCD involves adding new rows to the dimension table when changes occur. It allows us to track historical versions of attributes.
upvoted 9 times
...
nappi1
Most Recent 3 days, 9 hours ago
Customers -> Type 2 Products -> Type 1
upvoted 1 times
...
Nefirs
7 months, 1 week ago
correct, Type 2 (new row) and Type 1 (overwrite)
upvoted 4 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel