nerdexam
MongoDB

C100DBA · Question #93

The MongoDB explain() method does not support which of the following verbosity mode:

The correct answer is C. customExecutionStats. customExecutionStats (option C) is not a real verbosity mode - MongoDB's explain() method only supports three built-in verbosity modes, and this is a fabricated distractor. Why the others are wrong (i.e., they're all valid modes): A. executionStats - Valid. Returns stats on the w

Monitoring and Diagnostics

Question

The MongoDB explain() method does not support which of the following verbosity mode:

Options

  • AexecutionStats
  • BqueryPlanner
  • CcustomExecutionStats
  • DallPlansExecution

How the community answered

(26 responses)
  • A
    4% (1)
  • B
    4% (1)
  • C
    92% (24)

Explanation

customExecutionStats (option C) is not a real verbosity mode - MongoDB's explain() method only supports three built-in verbosity modes, and this is a fabricated distractor.

Why the others are wrong (i.e., they're all valid modes):

  • A. executionStats - Valid. Returns stats on the winning query plan, including documents examined and execution time.
  • B. queryPlanner - Valid. The default mode; shows which plan the optimizer selected without actually executing the query.
  • D. allPlansExecution - Valid. The most verbose mode; runs all candidate plans and returns stats for each, not just the winner.

Memory tip: Think of the three real modes as a spectrum of "how much work MongoDB does" - queryPlanner (plan only) → executionStats (run the winner) → allPlansExecution (run everything). Anything outside this trio is fake - "custom" is a dead giveaway since MongoDB's explain API has no customization hooks.

Topics

#explain method#verbosity modes#queryPlanner#executionStats

Community Discussion

No community discussion yet for this question.

Full C100DBA Practice