New Year Sale 2026! 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 8 Question 86 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 86
Topic #: 8
[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 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:

0/2000 characters
Submit Cancel
Lashandra
2 months ago
I thought it was A at first, but C is right.
upvoted 0 times
...
Verona
3 months ago
Totally agree, C makes the most sense.
upvoted 0 times
...
Britt
3 months ago
B is definitely wrong, no updates happen in SCD Type 2!
upvoted 0 times
...
Hailey
3 months ago
Wait, are we sure about that? Sounds a bit off.
upvoted 0 times
...
Portia
3 months ago
C is the correct answer! Old record gets flagged.
upvoted 0 times
...
Sarah
4 months ago
I’m confused because I thought Type 2 meant we keep the old records. So, I guess C makes the most sense, but I’m not 100% sure.
upvoted 0 times
...
Ligia
4 months ago
I practiced a similar question, and I think it was about flagging old records too. So, I’m leaning towards C as well.
upvoted 0 times
...
Nu
4 months ago
I'm not entirely sure, but I feel like it could be A. I remember something about deleting old records, but that doesn't seem right for Type 2.
upvoted 0 times
...
Maile
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 I remember about SCD Type 2.
upvoted 0 times
...
Deandrea
4 months ago
I feel pretty confident about this one. The key with SCD Type 2 is that we need to keep a full history of changes, so the old record can't just be deleted or updated. The new changed record has to be added alongside the old record, which is then flagged as no longer current. I'm going with C.
upvoted 0 times
...
Bok
5 months ago
Okay, let me walk through this step-by-step. With SCD Type 2, we want to preserve the history of changes, so the old record shouldn't be deleted. And we also don't want to just update the old record, since that would lose the history. So I think the correct answer is C - the old record is flagged and the new changed record is added.
upvoted 0 times
...
Ernie
5 months ago
Hmm, I'm a bit unsure about this one. I know SCD Type 2 is about tracking changes, but I can't quite recall the exact behavior when a change is detected. I'll have to think this through carefully.
upvoted 0 times
...
Christiane
5 months ago
I'm pretty sure the answer is C - the old record is flagged and the changed record is added. That's how I remember the SCD Type 2 behavior working.
upvoted 0 times
...
Georgiann
11 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
9 months ago
User4: Option D sounds interesting, merging the records.
upvoted 0 times
...
Paulina
9 months ago
User3: I'm going with option C, flagging the old record.
upvoted 0 times
...
Jerry
9 months ago
User2: I believe it's option B, the old record gets updated.
upvoted 0 times
...
Jarvis
9 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
Glendora
10 months ago
User4: I'm going with option C, flagging the old record.
upvoted 0 times
...
Gilbert
10 months ago
User3: I agree with User2, option B sounds right.
upvoted 0 times
...
Merlyn
10 months ago
User2: I believe it's option B, the old record is updated.
upvoted 0 times
...
Leota
10 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
...
Yuette
11 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
11 months ago
I think D) the old record is merged with the changed record could also be a possibility.
upvoted 0 times
...
Vivan
11 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
11 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
11 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
11 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
11 months ago
I believe option A is the correct answer.
upvoted 0 times
...
Janine
11 months ago
I think option B is the correct answer.
upvoted 0 times
...
Keena
11 months ago
I agree, option C is the correct answer.
upvoted 0 times
...
Tamar
11 months ago
It's important to flag the old record in SCD Type 2.
upvoted 0 times
...
Lashon
11 months ago
Yes, that's right. The old record is flagged and the changed record is added.
upvoted 0 times
...
Dannie
11 months ago
I agree, option C is the correct answer.
upvoted 0 times
...
...

Save Cancel