SAS Exam A00-260 Topic 10 Question 72 Discussion

Actual exam question for SAS's A00-260 exam

Question #: 72
Topic #: 10

[All A00-260 Questions]

In SAS Data Integration Studio, where must the columns included in a business key exist?

Ain the source and standardization tables

Bin the source and dimension tables

Cin the target and fact tables

Din the source, dimension and standardization tables

Show Suggested Answer

Suggested Answer: B

by Marvel at Aug 25, 2024, 09:58 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gladys

7 months ago

The business key? Is that like the secret password to unlock the SAS data vault? I'll just try every combination until I get in.

upvoted 0 times

...

Ilene

7 months ago

I'm just gonna randomly select an answer and hope for the best. After all, who needs business keys when you've got a magic 8-ball?

upvoted 0 times

Sommer

6 months ago

Let's hope for the best!

upvoted 0 times

...

Ricarda

6 months ago

D) in the source, dimension and standardization tables

upvoted 0 times

...

Jesse

6 months ago

B) in the source and dimension tables

upvoted 0 times

...

Madonna

6 months ago

That sounds good to me too.

upvoted 0 times

...

Virgina

6 months ago

A) in the source and standardization tables

upvoted 0 times

...

Tarra

6 months ago

I'm going with option B as well.

upvoted 0 times

...

Alex

7 months ago

I think the columns should be in the source and dimension tables.

upvoted 0 times

...

Lai

8 months ago

I believe the columns should be in the source and standardization tables.

upvoted 0 times

...

Shawnda

8 months ago

I think the correct answer is A) in the source and standardization tables because those are the tables where the data is coming from and being standardized.

upvoted 0 times

...

Belen

8 months ago

Option C seems like the obvious choice here. Everyone knows the business key belongs in the target and fact tables, right? Wait, this isn't a trick question, is it?

upvoted 0 times

Herman

7 months ago

No, I believe they should be in the source and standardization tables.

upvoted 0 times

...

Marti

7 months ago

I think the columns should be in the source and dimension tables.

upvoted 0 times

...

Derrick

8 months ago

I agree with Huey, it makes sense for the business key columns to be in those tables.

upvoted 0 times

...

Huey

8 months ago

I think the columns must exist in the source and dimension tables.

upvoted 0 times

...

Frankie

8 months ago

Hmm, this is a tricky one. I'm leaning towards B, but I'm not 100% sure. Guess I'll have to study my SAS Data Integration Studio handbook a little harder.

upvoted 0 times

...

Karl

8 months ago

I'm gonna go with D. The business key needs to be present in the source, dimension, and standardization tables to maintain data traceability and quality.

upvoted 0 times