SAS Exam A00-260 Topic 13 Question 36 Discussion

Actual exam question for SAS's A00-260 exam

Question #: 36
Topic #: 13

When using the Table Loader transformation to load an existing target table that contains one or more indexes in SAS Data Integration Studio, which statement is true?

AIndexes are removed when the Table Loader executes and must be re-created using the Table Structure transformation.

BIndexes are automatically preserved when the Table Loader executes.

CIndexes are removed at the beginning of the load process and must be re-created in a subsequent job step.

DIndexes can be removed or preserved at the beginning of the process depending on options chosen. Additional table loader options specify whether to re-create the index at the end of the process.

Show Suggested Answer

Suggested Answer: C

by Mozell at Oct 16, 2022, 05:59 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Jolene

8 days ago

I once accidentally removed all the indexes on a production table. Took me weeks to fix that mess. D is the way to go, no doubt.

upvoted 0 times

...

Tegan

12 days ago

Ha! Removing the indexes and then having to re-create them? What a pain! I'm going with D for sure.

upvoted 0 times

...

1 months ago

I think the answer is D, because you can choose whether to remove or preserve indexes in the Table Loader.

upvoted 0 times

...