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

Beatriz

1 days ago

I agree with Mira, D seems like the most flexible option for handling indexes during the loading process.

upvoted 0 times

...

Mira

3 days ago

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

upvoted 0 times

...