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

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

Daisy

19 days ago

User4: Option D sounds interesting, merging the records.

upvoted 0 times

...

Paulina

23 days ago

User3: I'm going with option C, flagging the old record.

upvoted 0 times

...

Jerry

24 days ago

User2: I believe it's option B, the old record gets updated.

upvoted 0 times

...

Jarvis

24 days ago

User1: I think option A is the correct one.

upvoted 0 times

...

Glendora

1 months ago

User4: I'm going with option C, flagging the old record.

upvoted 0 times

...

Gilbert

1 months ago

User3: I agree with User2, option B sounds right.

upvoted 0 times

...

Merlyn

1 months ago

User2: I believe it's option B, the old record is updated.

upvoted 0 times

...

Leota

2 months ago

User1: I think option A is the correct one.

upvoted 0 times

...

Yuette

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

2 months ago

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

upvoted 0 times

...

Vivan

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

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

3 months ago

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

upvoted 0 times

...

Minna

3 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

2 months ago

I believe option A is the correct answer.

upvoted 0 times

...

Janine

2 months ago

I think option B is the correct answer.

upvoted 0 times

...

Keena

2 months ago

I agree, option C is the correct answer.

upvoted 0 times

...

Tamar

3 months ago

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

upvoted 0 times

...

Lashon

3 months ago

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

upvoted 0 times

...

Dannie

3 months ago

I agree, option C is the correct answer.

upvoted 0 times

...