Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

SAS A00-260 Exam - Topic 12 Question 103 Discussion

When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
C) the old record is flagged and the changed record is added
A) the old record is deleted and the changed record is added
B) the old record is updated with the new values from the changed record
D) the old record is merged with the changed record

SAS A00-260 Exam - Topic 12 Question 103 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 103
Topic #: 12
[All A00-260 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: C

by Bulah at May 17, 2026, 06:49 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Vannessa
5 days ago
I remember discussing SCD Type 2 in class, and I think it was about keeping historical data, so maybe C is the best choice.
upvoted 0 times
...
Catalina
10 days ago
I'm not entirely sure, but I feel like A could be right too. I recall something about deleting old records in some scenarios.
upvoted 0 times
...
Gladis
15 days ago
I think the correct answer might be C, where the old record is flagged and the new one is added. I remember practicing a similar question.
upvoted 0 times
...
Annita
20 days ago
I keep mixing up the options, but I think D could be a possibility too. Merging records sounds familiar, but I’m not confident.
upvoted 0 times
...
Fletcher
26 days ago
I feel like we went over a similar question in class, and I think it was about flagging old records. So, C sounds right to me.
upvoted 0 times
...
Idella
1 month ago
I'm not entirely sure, but I remember something about not deleting old records in SCD Type 2. Maybe it's A?
upvoted 0 times
...
Leota
3 months ago
I think the correct answer might be C, where the old record is flagged and the new one is added. That seems to align with what we practiced.
upvoted 0 times
...

Save Cancel