MongoDB Exam C100DBA Topic 1 Question 93 Discussion

Actual exam question for MongoDB's C100DBA exam

Question #: 93
Topic #: 1

[All C100DBA Questions]

Consider the following document:

> db.c.find()

{ "_id" : 12, b : [ 3, 5, 7, 2, 1, -4, 3, 12 ] }

Which of the following queries on the "c" collection will return only the first five elements of the array in the "b"

field? E.g.,

Document you want returned by your query:

{ "_id" : 12, "b" : [ 3, 5, 7, 2, 1 ] >

Adb.c.find( { > , { b : { $slice : [ 0 , 5 ] } } )

Bdb.c.find( { b : [ 0 , 5 ] > )

Cdb.c.find( { > , { b : { $substr[ 0 , 5 ] > > )

Ddb.c.find( { > , { b : [ 0, 1, 2, 3, 4, 5 ] > )

Edb.c.find( { > , { b : [ 0 , 5 ] > )

Show Suggested Answer

Suggested Answer: A

by Sabine at Jul 18, 2024, 08:15 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vallie

6 days ago

Shout out to the MongoDB devs for coming up with the $slice operator. Makes our lives so much easier!

upvoted 0 times

...

Linsey

13 days ago

Woah, option C with the $substr? That's like using a sledgehammer to crack a nut. Gotta keep it simple, people.

upvoted 0 times

...

21 days ago

I agree, A is the way to go. Slicing the array is the simplest and most efficient way to get the desired result.

upvoted 0 times

Micaela

12 days ago

User 1: I think A is the correct query to use.

upvoted 0 times

...

Patria

28 days ago

I agree with you, Suzan. Option A makes sense.

upvoted 0 times

...

Suzan

1 months ago

I think the correct answer is A.

upvoted 0 times

...

Jeannetta

1 months ago

Option A is the correct answer. The $slice operator in the projection stage allows us to return only the first 5 elements of the 'b' array.

upvoted 0 times

Tabetha

25 days ago

User 2: Thanks for clarifying!

upvoted 0 times

...

Kenny

1 months ago

User 1: Option A is the correct answer.

upvoted 0 times

...