IBM
C2090-461 · Question #21
C2090-461 Question #21: Real Exam Question with Answer & Explanation
The correct answer is D. Archive indexes should be specified in the Access Definition that will support the query workload. See the full explanation below for the reasoning.
Question
You have created an Access Definition containing multiple tables. The tables each have primary keys and additional non-unique indexes that have been added over the years. While defining this archive request you have the choice of defining archive indexes. Which statement is true?
Options
- AArchive indexes do not need to be defined since Optim has already detected and included the
- BArchive indexes will automatically be created to mirror the indexes that exist on the tables in the
- CArchive indexes should be specified in the Access Definition to match all of the indexes on the
- DArchive indexes should be specified in the Access Definition that will support the query workload
Community Discussion
No community discussion yet for this question.