SAS_Institute
A00-260 · Question #12
A00-260 Question #12: Real Exam Question with Answer & Explanation
The correct answer is B. You can control the removal and/or creation of indexes and constraints in the target table for all. See the full explanation below for the reasoning.
Question
When using the Table Loader transformation in SAS Data Integration Studio to update an existing table containing indexes or constraints, which statement is true?
Options
- AYou can control the removal and/or creation of indexes and constraints in the target table only if
- BYou can control the removal and/or creation of indexes and constraints in the target table for all
- 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
Community Discussion
No community discussion yet for this question.