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

Earleen

24 days ago

I think Amber might be onto something. The wording of option D also seems a bit confusing to me. I'm going to have to think this one through carefully.

upvoted 0 times

Chantell

Let's carefully consider all the options before making a decision.

upvoted 0 times

...

Reyes

15 days ago

I think option A is the correct one, you can control the removal and creation of indexes and constraints in the target table only if you are using a Load style other than Replace.

upvoted 0 times

...

Kati

20 days ago

I agree, option D does seem a bit confusing.

upvoted 0 times

...

Antonio

1 months ago

Ha! This question is a real index-puzzler, isn't it? I'm just glad I don't have to worry about keeping track of all those constraints and whatnot. I'll leave that to the experts.

upvoted 0 times

Lore

8 days ago

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

upvoted 0 times

...

Alesia

16 days ago

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

upvoted 0 times

...

Mollie

27 days ago

A) You 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.

upvoted 0 times

...

Amber

1 months ago

I'm not so sure about that. I was thinking option C might be correct. Isn't it the case that we can only add, but not remove, indexes and constraints when using the Append to Existing load style?

upvoted 0 times

...