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 Exam A00-260 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:

Submit Cancel
Georgiann
4 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
3 months ago
User4: Option D sounds interesting, merging the records.
upvoted 0 times
...
Paulina
3 months ago
User3: I'm going with option C, flagging the old record.
upvoted 0 times
...
Jerry
3 months ago
User2: I believe it's option B, the old record gets updated.
upvoted 0 times
...
Jarvis
3 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
Glendora
3 months ago
User4: I'm going with option C, flagging the old record.
upvoted 0 times
...
Gilbert
3 months ago
User3: I agree with User2, option B sounds right.
upvoted 0 times
...
Merlyn
3 months ago
User2: I believe it's option B, the old record is updated.
upvoted 0 times
...
Leota
4 months ago
User1: I think option A is the correct one.
upvoted 0 times
...
...
Yuette
4 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
4 months ago
I think D) the old record is merged with the changed record could also be a possibility.
upvoted 0 times
...
Vivan
5 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
5 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
5 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
5 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
4 months ago
I believe option A is the correct answer.
upvoted 0 times
...
Janine
4 months ago
I think option B is the correct answer.
upvoted 0 times
...
Keena
4 months ago
I agree, option C is the correct answer.
upvoted 0 times
...
Tamar
4 months ago
It's important to flag the old record in SCD Type 2.
upvoted 0 times
...
Lashon
5 months ago
Yes, that's right. The old record is flagged and the changed record is added.
upvoted 0 times
...
Dannie
5 months ago
I agree, option C is the correct answer.
upvoted 0 times
...
...

Save Cancel