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

1 months 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

Dyan

7 days ago

I think we need to carefully consider all the options before making a decision.

upvoted 0 times

...

Hortencia

12 days ago

I agree, Amber's point is interesting. Option D does seem a bit unclear.

upvoted 0 times

...

Chantell

15 days ago

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

upvoted 0 times

...

Reyes

1 months 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

1 months ago

I agree, option D does seem a bit confusing.

upvoted 0 times

...

Antonio

2 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

23 days ago

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

upvoted 0 times

...

Alesia

1 months 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

1 months 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

2 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

...