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

Georgiann

16 days ago

Haha, 'merge' the old and new records? What is this, a wedding ceremony? I'll stick with option C, thank you very much.

upvoted 0 times

...

Yuette

20 days ago

Hmm, I thought the old record was supposed to be archived or something. This 'flagging' idea is new to me.

upvoted 0 times

...

Halina

21 days ago

I think D) the old record is merged with the changed record could also be a possibility.

upvoted 0 times

...

Vivan

24 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

25 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

27 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

1 months 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

Melda

7 days ago

I believe option A is the correct answer.

upvoted 0 times

...

Janine

10 days ago

I think option B is the correct answer.

upvoted 0 times

...

Keena

12 days ago

I agree, option C is the correct answer.

upvoted 0 times

...

Tamar

23 days ago

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

upvoted 0 times

...

Lashon

24 days ago

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

upvoted 0 times

...

Dannie

1 months ago

I agree, option C is the correct answer.

upvoted 0 times

...