MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) C100DBA Question # 12 Topic 2 Discussion

MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) C100DBA Question # 12 Topic 2 Discussion

C100DBA Exam Topic 2 Question 12 Discussion:
Question #: 12
Topic #: 2

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.


A.

As an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an indexed field


B.

As an indexed query using "mylndex" because field "user.login" is indexed


C.

MongoDB will need to do a table/collection scan to find matching documents


D.

None of the above


E.

As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"


Get Premium C100DBA Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.