SAS Exam A00-260 Topic 8 Question 86 Discussion

Actual exam question for SAS's A00-260 exam

Question #: 86
Topic #: 8

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

Athe old record is deleted and the changed record is added

Bthe old record is updated with the new values from the changed record

Cthe old record is flagged and the changed record is added

Dthe old record is merged with the changed record

Show Suggested Answer

Suggested Answer: C

by Justine at Mar 20, 2025, 03:40 PM

Limited Time Offer

25%

Off

Get Premium A00-260 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Vivan

1 days ago

I'm not sure, but I think C) the old record is flagged and the changed record is added makes sense.

upvoted 0 times

...

Kendra

2 days ago

I disagree, I believe the correct answer is A) the old record is deleted and the changed record is added.

upvoted 0 times

...

Marguerita

4 days ago

I think the answer is B) the old record is updated with the new values from the changed record.

upvoted 0 times

...

Minna

13 days ago

Option C is definitely the correct answer. Flagging the old record and adding the changed one is the essence of SCD Type 2 in SAS Data Integration Studio.

upvoted 0 times

Tamar

3 hours ago

It's important to flag the old record in SCD Type 2.

upvoted 0 times

...

Lashon

1 days ago

Yes, that's right. The old record is flagged and the changed record is added.

upvoted 0 times

...

Dannie

9 days ago

I agree, option C is the correct answer.

upvoted 0 times

...