nerdexam
IBM

P2090-050 · Question #72

What is required to troubleshoot a query?

The correct answer is D. nzdumpschema and the execution plan. See the full explanation below for the reasoning.

Question

What is required to troubleshoot a query?

Options

  • Anzevents and the pg.log.
  • Bnzsql and the ODBC config.
  • Cnzinventory and the dbos.log.
  • Dnzdumpschema and the execution plan.

How the community answered

(54 responses)
  • A
    9% (5)
  • B
    17% (9)
  • C
    4% (2)
  • D
    70% (38)

Community Discussion

No community discussion yet for this question.

Full P2090-050 Practice