You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD). Which two actions should you include in the process? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
A.
Update rows when the non-key attributes have changed.
B.
Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.
C.
Update the effective end date of rows when the non-key attribute values have changed.
D.
Insert new records when the natural key is a new value in the table.
A. Update rows when the non-key attributes have changed: In a Type 1 SCD, when a change is detected in any of the non-key attributes of an existing row, the current row is updated with the new values. This type of SCD does not keep any historical data; it simply overwrites the old data with the new data.
D. Insert new records when the natural key is a new value in the table: When a new record (with a new natural key) is encountered that does not already exist in the dimension table, it is inserted as a new row. This is necessary to ensure that all new entities are captured in the dimension.
I would go with A and C: Type1 use case to make changes or correction without involving histohttps://www.examtopics.com/exams/microsoft/dp-600/view/13/#ric data. D in my opinion is type 2 inserting new record with natural key for versioning.
IMHO, A & D is good.
Taking into account this: A Type 1 SCD always reflects the latest values, and when changes in source data are detected, the dimension table data is overwritten.
Link: https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/3-choose-between-dimension-types
AD makes sense given the type of SCD as no history is maintained and any updates on the columns are taken care of by replacing the values then and there.
But, still a bit skeptical about C, since that is a part of SCD too in case we have certain audit columns that we would have to update. If the end_date is an audit column to update the date and time of last entry into a record, then, it would be required to be updated too.
This section is not available anymore. Please use the main Exam Page.DP-600 Exam Questions
Log in to ExamTopics
Sign in:
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.
fabric1
Highly Voted 1 year, 2 months agoRakesh16
Most Recent 5 months, 2 weeks agoJoly
7 months, 4 weeks agoAhmadpbi
9 months, 2 weeks agowoliveiras
11 months ago282b85d
11 months, 1 week ago2dc6125
11 months, 3 weeks agostilferx
11 months, 3 weeks agoNefirs
1 year agosraakesh95
1 year, 2 months agothuss
1 year, 2 months agoMomoanwar
1 year, 2 months ago