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
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)- A4% (1)
- B4% (1)
- C92% (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
Community Discussion
No community discussion yet for this question.