nerdexam
IBM

C4040-124 · Question #37

Which of the following describes an IBM i solution that is designed to prevent long-running or excessive query jobs from impacting the overall performance of a system?

The correct answer is A. The DB2 Predictive Query Governor can prevent the initiation of a query if the estimated run time. See the full explanation below for the reasoning.

Question

Which of the following describes an IBM i solution that is designed to prevent long-running or excessive query jobs from impacting the overall performance of a system?

Options

  • AThe DB2 Predictive Query Governor can prevent the initiation of a query if the estimated run time
  • BDB2 Query Management Facility provides a comprehensive set of features and functions to
  • CDB2 uses the Open Query File manager to provide a filter between the query and database
  • DThe IBM i Universal DB2 Query subsystem (QQUERY) defines how, where, and how many

How the community answered

(43 responses)
  • A
    77% (33)
  • B
    14% (6)
  • C
    5% (2)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full C4040-124 Practice