MongoDB Exam C100DBA Topic 1 Question 64 Discussion

Actual exam question for MongoDB's C100DBA exam

Question #: 64
Topic #: 1

Given a collection posts as shown below having a document array comments, which of the following command will create an index on the comment author descending?

Adb.posts.createIndex({^comments.$.author':-l});

Bdb. posts.createIndex({^comments.author' :1});

Cdb.posts.createIndex({^commerits.author';-!});

Show Suggested Answer

Suggested Answer: A, B, C

by Carmela at Jan 06, 2023, 07:14 AM

Limited Time Offer

25%

Off

Get Premium C100DBA Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Rosalyn

9 days ago

I think the answer is A. db.posts.createIndex({\'^comments.$.author\':-1}). It seems to create an index on the 'author' field of the 'comments' subdocument in descending order.

upvoted 0 times

...

Susana

16 days ago

I'm not sure, but I think option A might be correct as it mentions creating an index on comment author in descending order.

upvoted 0 times

...

Delisa

18 days ago

The correct answer is B. db.posts.createIndex({\'comments.author\':1}). The command creates an index on the 'author' field of the 'comments' subdocument in the 'posts' collection, in ascending order.

upvoted 0 times

...

Marshall

18 days ago

I agree with Chara, option B seems to be the right choice because it specifies the index on comment author in ascending order.

upvoted 0 times

...

Chara

19 days ago

I think the correct command is B) db.posts.createIndex({^comments.author :1});

upvoted 0 times

...