nerdexam
MongoDB

C100DBA · Question #64

If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?

Sign in or unlock C100DBA to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.

Performance Tuning

Question

If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?

Options

  • ANone of the above
  • BThe query used an index to fetch the results
  • CThe query returned 0 documents
  • DThe query returned 30000 documents after scanning the documents

Unlock C100DBA to see the answer

You've previewed enough free C100DBA questions. Unlock C100DBA for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#explain output#index usage#totalDocsExamined#totalKeysExamined
Full C100DBA Practice