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 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
4 months ago
I thought it was A at first, but C is right.
upvoted 0 times
...
Verona
4 months ago
Totally agree, C makes the most sense.
upvoted 0 times
...
Britt
5 months ago
B is definitely wrong, no updates happen in SCD Type 2!
upvoted 0 times
...
Hailey
5 months ago
Wait, are we sure about that? Sounds a bit off.
upvoted 0 times
...
Portia
5 months ago
C is the correct answer! Old record gets flagged.
upvoted 0 times
...
Sarah
5 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
6 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
6 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
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 I remember about SCD Type 2.
upvoted 0 times
...
Deandrea
6 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
6 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
7 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
7 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
1 year 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
11 months ago
User4: Option D sounds interesting, merging the records.
upvoted 0 times
...
Paulina
11 months ago
User3: I'm going with option C, flagging the old record.
upvoted 0 times
...
Jerry
11 months ago
User2: I believe it's option B, the old record gets updated.
upvoted 0 times
...
Jarvis
11 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
Glendora
12 months ago
User4: I'm going with option C, flagging the old record.
upvoted 0 times
...
Gilbert
12 months ago
User3: I agree with User2, option B sounds right.
upvoted 0 times
...
Merlyn
12 months ago
User2: I believe it's option B, the old record is updated.
upvoted 0 times
...
Leota
12 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
...
Yuette
1 year 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
1 year ago
I think D) the old record is merged with the changed record could also be a possibility.
upvoted 0 times
...
Vivan
1 year 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
1 year 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
1 year ago
I think the answer is B) the old record is updated with the new values from the changed record.
upvoted 0 times
...
Minna
1 year 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
1 year ago
I believe option A is the correct answer.
upvoted 0 times
...
Janine
1 year ago
I think option B is the correct answer.
upvoted 0 times
...
Keena
1 year ago
I agree, option C is the correct answer.
upvoted 0 times
...
Tamar
1 year ago
It's important to flag the old record in SCD Type 2.
upvoted 0 times
...
Lashon
1 year ago
Yes, that's right. The old record is flagged and the changed record is added.
upvoted 0 times
...
Dannie
1 year ago
I agree, option C is the correct answer.
upvoted 0 times
...
...

Save Cancel