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?

Question

Options

• AIndexes are removed when the Table Loader executes and must be re-created using the Table
• 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
• DIndexes can be removed or preserved at the beginning of the process depending on options

• C
  5% (1)
• D
  95% (19)

Explanation

Option D is correct because the Table Loader transformation in SAS Data Integration Studio provides configurable index handling options: you can choose to drop indexes before the load begins and recreate them afterward (which improves bulk-load performance), or you can preserve indexes throughout the process - the behavior is not fixed, it depends on the settings you configure.

Option A is wrong because it implies indexes are always removed with no choice in the matter, and the phrasing suggests manual recreation is the only path. Option B is wrong because automatic preservation is not the default or guaranteed behavior - it is one possible outcome based on your configuration, not an unconditional rule. Option C is also wrong for the same reason as A: it presents index removal as mandatory rather than optional.

Memory tip: Think of the Table Loader as a "flexible loader" - the keyword in option D is "depending on options," which signals user control. Any answer that says indexes are always removed or always preserved is too absolute to be right in a configurable tool.

No community discussion yet for this question.