PrepAway - Latest Free Exam Questions & Answers

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform?

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Look up whether a record with a matching business key value exists in a dimension table. If it
does,add new values for selected fields to values lists for those fields.

B.
Look up whether a record with a matching business key value exists in a fact table. If it does
not,retrieve a new surrogate key value and insert a new row into the fact table.

C.
Look up whether a record with a matching business key value exists in a dimension table. If it
does not,retrieve a new surrogate key value and insert a new row into the dimension table.

D.
Look up whether a record with a matching business key value exists in a dimension table. If it
does,mark the record as not-current,and generate a new record with new values for selected
fields.

Explanation:


Leave a Reply