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
Antonio
3 days ago
Wait, I thought it was A? That seems off.
upvoted 0 times
...
Merri
9 days ago
Totally agree, it's all about preserving history.
upvoted 0 times
...
Tamala
14 days ago
C is the correct answer!
upvoted 0 times
...
Lyla
19 days ago
B seems wrong, you don’t just update the old record.
upvoted 0 times
...
Thurman
24 days ago
Definitely C, I've used it before.
upvoted 0 times
...
Georgene
29 days ago
Wait, I thought it was A? This is confusing.
upvoted 0 times
...
Leota
1 month ago
Totally agree, C makes the most sense.
upvoted 0 times
...
Elmira
1 month ago
C is the correct answer! Old record gets flagged.
upvoted 0 times
...
Thomasena
1 month ago
I’m confused between C and D. I thought merging was part of the process, but I can't recall the specifics.
upvoted 0 times
...
Vannessa
2 months 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
2 months 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
2 months 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
2 months 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
2 months 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
3 months 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
4 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