nerdexam
IBM

C2090-552 · Question #43

Which of the following are included in an Access Definition?

The correct answer is D. Archive indexes should be specified in the Access Definition that will support the query. 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…

DB2 Utilities and Operations

Question

Which of the following are included in an Access Definition?

Options

  • AArchive indexes do not need to be defined since Optim has already detected and
  • BArchive indexes will automatically be created to mirror the indexes that exist on the
  • CArchive indexes should be specified in the Access Definition to match all of the indexes
  • DArchive indexes should be specified in the Access Definition that will support the query

How the community answered

(53 responses)
  • A
    6% (3)
  • B
    4% (2)
  • C
    11% (6)
  • D
    79% (42)

Explanation

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? included the indexes in the archive request. tables in the archive request. workload planned for the archived data.

Topics

#Access Definition#archive indexes#Optim#query support

Community Discussion

No community discussion yet for this question.

Full C2090-552 Practice