MENU
When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?
Suggested Answer: C
Get Premium A00-260 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
25 comments · newest first
AM
Amber
2 days ago
I think it's C. The old record gets flagged.
ZA
Zack
7 days ago
I feel like B could work too, but it loses history.
PA
Paris
12 days ago
C is definitely the way to go. It’s about tracking changes.
VI
Virgie
18 days ago
No way, A is wrong. We need to preserve data.
MI
Miriam
23 days ago
I’m leaning towards A. Deleting old records seems cleaner.
NI
Nicholle
28 days ago
Agreed, C makes sense. It keeps history intact.
DA
Dalene
1 month ago
I think C is correct. Old records should be flagged.
TW
Twana
1 month ago
Really? I’m surprised it’s not just an update.
RU
Rupert
1 month ago
Definitely C, that's how SCD Type 2 works!
AN
Antonio
2 months ago
Wait, I thought it was A? That seems off.
ME
Merri
2 months ago
Totally agree, it's all about preserving history.
TA
Tamala
2 months ago
C is the correct answer!
LY
Lyla
2 months ago
B seems wrong, you don’t just update the old record.
TH
Thurman
2 months ago
Definitely C, I've used it before.
GE
Georgene
2 months ago
Wait, I thought it was A? This is confusing.
LE
Leota
3 months ago
Totally agree, C makes the most sense.
EL
Elmira
3 months ago
C is the correct answer! Old record gets flagged.
TH
Thomasena
3 months ago
I’m confused between C and D. I thought merging was part of the process, but I can't recall the specifics.
VA
Vannessa
3 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.
CA
Catalina
3 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.
GL
Gladis
4 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.
AN
Annita
4 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.
FL
Fletcher
4 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.
ID
Idella
4 months ago
I'm not entirely sure, but I remember something about not deleting old records in SCD Type 2. Maybe it's A?
LE
Leota
6 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.