New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25%
- Ends In
00:00:00
Coupon code:
SAVE25
X
Welcome to Pass4Success
Login
|
Sign up
-
Free
Preparation Discussions
Mail Us
support@pass4success.com
Location
US
MENU
Home
Popular vendors
Salesforce
Microsoft
Nutanix
Amazon
Google
CompTIA
SAP
VMware
Fortinet
PeopleCert
Eccouncil
HP
Palo Alto Networks
Adobe
ISC2
ServiceNow
Dell EMC
CheckPoint
Linux Foundation
Discount Deals
New
About
Contact
Login
Sign up
Home
Discussions
SAS Discussions
A00-260 Exam - Topic 12 Question 8 Discussion
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:
A
generated by the Lookup transformation
B
copied from source tables into dimension tables
C
generated by the SCD Type 2 Loader transformation
D
copied from dimension tables into source tables
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
4 months ago
Definitely not D, that doesn't make sense at all!
upvoted
0
times
...
Nathan
4 months ago
I thought retained keys were just copied from source tables.
upvoted
0
times
...
Jenifer
4 months ago
Wait, are they really generated by the SCD Type 2 Loader?
upvoted
0
times
...
Nan
4 months ago
Totally agree, it's all about generating them!
upvoted
0
times
...
Emmett
5 months ago
Surrogate keys are usually generated, not copied.
upvoted
0
times
...
Reid
5 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
5 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
5 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
5 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
5 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
5 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
5 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
...
Log in to Pass4Success
×
Sign in:
Forgot my password
Log in
Report Comment
×
Is the comment made by
USERNAME
spam or abusive?
Commenting
×
In order to participate in the comments you need to be logged-in.
You can
sign-up
or
login
Save
Cancel
Nidia
4 months agoNathan
4 months agoJenifer
4 months agoNan
4 months agoEmmett
5 months agoReid
5 months agoHortencia
5 months agoLaurel
5 months agoBettina
5 months agoFranchesca
5 months agoJina
5 months agoEvan
5 months ago