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?

Posted by: Pdfprep Category: C2090-552 Tags: , ,

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?
A . Archive indexes do not need to be defined since Optim has already detected and included the indexes in the archive request.
B . Archive indexes will automatically be created to mirror the indexes that exist on the tables in the archive request.
C . Archive indexes should be specified in the Access Definition to match all of the indexes on the tables.
D . Archive indexes should be specified in the Access Definition that will support the query workload planned for the archived data.

Answer: D

Leave a Reply

Your email address will not be published.