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

Cora

1 months ago

I'm going with B. db.posts.createIndex({\'comments.author\':1}). It's the only one that looks like it actually creates an index on the 'comments' subdocument. The others seem a bit... creative.

upvoted 0 times

...

Gerardo

1 months ago

Hmm, this one's tricky. Is the answer B? db.posts.createIndex({\'comments.author\':1})? I hope I'm not just making a comment on the wrong post!

upvoted 0 times

...

Lashawn

1 months ago

I'm pretty sure the correct answer is C. db.posts.createIndex({\'^commerits.author\':-1}). Oops, my bad, I misspelled 'comments'!

upvoted 0 times

Gennie

14 days ago

User 1: I think the correct answer is A) db.posts.createIndex({^comments.$.author\':-1});

upvoted 0 times

...

Isaiah

14 days ago

User 1: I think the correct answer is A) db.posts.createIndex({'comments.$.author':-1}).

upvoted 0 times

...

Rosalyn

2 months 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

Monroe

2 months ago

User2: I think it might be B) db. posts.createIndex({^comments.author\' :1}).

upvoted 0 times

...

Tricia

2 months ago

User1: I agree with you, A) db.posts.createIndex({^comments.$.author\':-1}) looks like the correct command.

upvoted 0 times

...

Susana

2 months 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

2 months 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