MongoDB
C100DBA · Question #117
C100DBA Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock C100DBA to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Question
Consider the following example document: { "_id": Objectld("5360c0a0a655a60674680bbe"), "user" "login": "irOn" "description": "Made of steel" "date": ISODate("2014-04-30T09:16:45.836Z"), } > and index creation command: db.users.createlndex( { "user.login": 1, "user.date": -1 }, "mylndex" ) When performing the following query: db.users.find( { "user.login": /Air.*/ }, { "user":1, "_id":0 > ).sort( { "user.date":1 > ) which of the following statements correctly describe how MongoDB will handle the query? Check all that apply.
Options
- AAs an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an
- BAs an indexed query using "mylndex" because field "user.login" is indexed
- CMongoDB will need to do a table/collection scan to find matching documents
- DNone of the above
- EAs a covered query using "mylndex" because we are filtering out "_id" and only returning
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.