MENU
In SAS Data Integration Studio, surrogate and retained key values are:
Suggested Answer: C
Get Premium A00-260 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
NI
Nidia
12 months ago
Definitely not D, that doesn't make sense at all!
NA
Nathan
12 months ago
I thought retained keys were just copied from source tables.
JE
Jenifer
1 year ago
Wait, are they really generated by the SCD Type 2 Loader?
NA
Nan
1 year ago
Totally agree, it's all about generating them!
EM
Emmett
1 year ago
Surrogate keys are usually generated, not copied.
RE
Reid
1 year 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.
HO
Hortencia
1 year ago
I feel like retained keys might be copied from source tables, but I can't recall the exact details.
LA
Laurel
1 year ago
I remember practicing a question about SCD Type 2, and I think it mentioned that surrogate keys are generated there.
BE
Bettina
1 year ago
I think surrogate keys are generated during the loading process, but I'm not sure if it's specifically the Lookup transformation.
FR
Franchesca
1 year 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.
JI
Jina
1 year ago
This one seems straightforward - I think the key is to use DISTINCT to get a unique list of subscribers.
EV
Evan
1 year 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.