SAS Exam A00-260 Topic 12 Question 69 Discussion

Actual exam question for SAS's A00-260 exam

Question #: 69
Topic #: 12

When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?

AYou can control the removal and/or creation of indexes and constraints in the target table only if you are using a Load style other than Replace.

BYou can control the removal and/or creation of indexes and constraints in the target table for all Load Styles.

CIf using the Append to Existing load style, indexes and constraints can be added but not removed.

DFor the Update/Insert load style it is possible to remove indexes not required for the Update/Insert processing, but no indexes can be added.

Show Suggested Answer

Suggested Answer: A

by Lavonna at Jul 08, 2024, 01:11 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Lavonna

2 days ago

I agree with Jovita. Option B makes the most sense to me as well. The Table Loader should give us full control over the indexes and constraints.

upvoted 0 times

...

Ceola

5 days ago

But A makes sense because it mentions controlling removal and creation of indexes for specific Load Styles.

upvoted 0 times

...

Huey

6 days ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Ceola

7 days ago

I think the answer is A.

upvoted 0 times

...

Eden

8 days ago

But A makes sense because it mentions controlling removal and creation of indexes for specific Load Styles.

upvoted 0 times

...

Jovita

10 days ago

Option B is the correct answer. We should be able to control the indexes and constraints for all load styles in the Table Loader transformation.

upvoted 0 times

...

Carole

11 days ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Eden

24 days ago

I think the answer is A.

upvoted 0 times

...