SAS Exam A00-260 Topic 9 Question 74 Discussion

Actual exam question for SAS's A00-260 exam

Question #: 74
Topic #: 9

[All A00-260 Questions]

In SAS Data Integration Studio, surrogate and retained key values are:

Agenerated by the Lookup transformation

Bcopied from source tables into dimension tables

Cgenerated by the SCD Type 2 Loader transformation

Dcopied from dimension tables into source tables

Show Suggested Answer

Suggested Answer: C

by Linwood at Sep 18, 2024, 09:34 AM

Limited Time Offer

25%

Off

Get Premium A00-260 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Hyun

28 days ago

I don't know about you, but I'm feeling a bit 'retained' by this question. Maybe we should just 'lookup' the answer instead.

upvoted 0 times

Taryn

19 hours ago

I think the answer is A) generated by the Lookup transformation

upvoted 0 times

...

Josephine

2 days ago

No, I believe it's A) generated by the Lookup transformation

upvoted 0 times

...

Wynell

5 days ago

B) copied from source tables into dimension tables

upvoted 0 times

...

Jaclyn

9 days ago

I think it's A) generated by the Lookup transformation

upvoted 0 times

...

Keneth

14 days ago

A) generated by the Lookup transformation

upvoted 0 times

...

Nieves

16 days ago

B) copied from source tables into dimension tables

upvoted 0 times

...

Domitila

17 days ago

A) generated by the Lookup transformation

upvoted 0 times

...

Elden

2 months ago

Wait, is this a trick question? I thought the SCD Type 2 Loader was for managing changes in dimension tables, not generating the keys themselves. Hmm, let me think about this again.

upvoted 0 times

Billye

22 days ago

I'm pretty sure it's C) generated by the SCD Type 2 Loader transformation.

upvoted 0 times

...

Clement

28 days ago

No, I believe it's actually A) generated by the Lookup transformation.

upvoted 0 times

...

Lura

1 months ago

I think the answer is B) copied from source tables into dimension tables.

upvoted 0 times

...

Hailey

2 months ago

I'm pretty sure it's not B or D, since the key values are generated, not copied. I think A is a bit too broad, so I'm going with C.

upvoted 0 times

Inocencia

1 months ago

Definitely not B or D, and A does seem too broad. C seems to be the best choice for this scenario.

upvoted 0 times

...

Burma

1 months ago

I'm leaning towards C as well. It seems like the most logical option for how surrogate and retained key values are generated.

upvoted 0 times

...

Julieta

1 months ago

Yeah, I think you're right. It wouldn't make sense for the key values to be copied from dimension tables into source tables.

upvoted 0 times

...

Adolph

2 months ago

I agree, I think C makes sense because the SCD Type 2 Loader transformation generates the key values.

upvoted 0 times

...

Miss

2 months ago

I'm not sure, but I think it might be C) generated by the SCD Type 2 Loader transformation, as it deals with slowly changing dimensions.

upvoted 0 times

...

Dahlia

2 months ago

I agree with Adolph, because surrogate and retained key values are usually created during lookup operations.

upvoted 0 times

...

Justine

2 months ago

Option C is the correct answer. The SCD Type 2 Loader transformation generates the surrogate and retained key values in the dimension tables.

upvoted 0 times

Pearly

2 months ago

That makes sense, thanks for clarifying!

upvoted 0 times

...

Carissa

2 months ago

C) generated by the SCD Type 2 Loader transformation

upvoted 0 times

...

Vincent

2 months ago

I agree with Justine. The SCD Type 2 Loader is responsible for handling the slowly changing dimensions, including the surrogate and retained keys.

upvoted 0 times

...

Adolph

2 months ago

I think the answer is A) generated by the Lookup transformation.

upvoted 0 times

...