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 12 Question 8 Discussion

In SAS Data Integration Studio, surrogate and retained key values are:
C) generated by the SCD Type 2 Loader transformation
A) generated by the Lookup transformation
B) copied from source tables into dimension tables
D) copied from dimension tables into source tables

SAS A00-260 Exam - Topic 12 Question 8 Discussion

Actual exam question for SAS's A00-260 exam
Question #: 8
Topic #: 12
[All A00-260 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: C

by Viva at May 08, 2022, 06:52 AM

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
Nidia
7 months ago
Definitely not D, that doesn't make sense at all!
upvoted 0 times
...
Nathan
7 months ago
I thought retained keys were just copied from source tables.
upvoted 0 times
...
Jenifer
8 months ago
Wait, are they really generated by the SCD Type 2 Loader?
upvoted 0 times
...
Nan
8 months ago
Totally agree, it's all about generating them!
upvoted 0 times
...
Emmett
8 months ago
Surrogate keys are usually generated, not copied.
upvoted 0 times
...
Reid
8 months ago
I definitely remember something about dimension tables, but I’m confused about whether they get keys from source or if it’s the other way around.
upvoted 0 times
...
Hortencia
8 months ago
I feel like retained keys might be copied from source tables, but I can't recall the exact details.
upvoted 0 times
...
Laurel
8 months ago
I remember practicing a question about SCD Type 2, and I think it mentioned that surrogate keys are generated there.
upvoted 0 times
...
Bettina
8 months ago
I think surrogate keys are generated during the loading process, but I'm not sure if it's specifically the Lookup transformation.
upvoted 0 times
...
Franchesca
8 months ago
I feel like I should know this, but I'm drawing a blank. The Activities panel has different types of things you can use, but I can't recall the specific categories. I'll have to review the documentation to refresh my memory on this one.
upvoted 0 times
...
Jina
9 months ago
This one seems straightforward - I think the key is to use DISTINCT to get a unique list of subscribers.
upvoted 0 times
...
Evan
9 months ago
This seems like a straightforward question on torts relevant to security officers. I'll start by thinking through the key elements of each option.
upvoted 0 times
...

Save Cancel