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
7 days 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
...
Yuette
11 days 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
12 days ago
I think D) the old record is merged with the changed record could also be a possibility.
upvoted 0 times
...
Vivan
15 days 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
16 days 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
18 days ago
I think the answer is B) the old record is updated with the new values from the changed record.
upvoted 0 times
...
Minna
27 days 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
Janine
1 days ago
I think option B is the correct answer.
upvoted 0 times
...
Keena
3 days ago
I agree, option C is the correct answer.
upvoted 0 times
...
Tamar
14 days ago
It's important to flag the old record in SCD Type 2.
upvoted 0 times
...
Lashon
15 days ago
Yes, that's right. The old record is flagged and the changed record is added.
upvoted 0 times
...
Dannie
23 days ago
I agree, option C is the correct answer.
upvoted 0 times
...
...

Save Cancel