Free MongoDB C100DEV Exam Questions

Become MongoDB Certified with updated C100DEV exam questions and correct answers

Page: 1 / 83

Total 411 Questions | Updated On: Apr 02, 2026

Add To Cart

Question 1

We have a movies collection with the following document structure:

{

_id: ObjectId("573a1390f29313caabcd6223"),

genres: [ 'Comedy', 'Drama', 'Family' ],

title: 'The Poor Little Rich Girl',

released: ISODate("1917-03-05T00:00:00.000Z"),

year: 1917,

imdb: { rating: 6.9, votes: 884, id: 8443 }

{

_id: ObjectId("573a13e3f29313caabdc08a4"),

genres: [ 'Horror', 'Thriller' ],

title: 'Mary Loss of Soul',

year: 2014,

imdb: { rating: '', votes: '', id: 2904798 }

}

We need to use Aggregation Framework to calculate the following aggregates:

average imdb rating

minimum imdb rating

maximum imdb rating

Expected output:

[

{

_id: null,

avg_rating: 6.6934040649367255,

min_rating: 1.6,

max_rating: 9.6

}

]

Please note that some documents have "" (empty string) for the field "imdb.rating". Exclude these documents before aggregation.

Which pipeline should you use?

A : [{ $match: { "imdb.rating": { $ne: "" } }}, { $group: { _id: null, avg_rating: { $avg: "imdb.rating" }, min_rating: { $min: "imdb.rating" }, max_rating: { $max: "imdb.rating" } }}]

B : [{ $group: { _id: null, avg_rating: { $avg: "$imdb.rating" }, min_rating: { $min: "$imdb.rating" }, max_rating: { $max: "$imdb.rating" } }}]

C : [{ $match: { "imdb.rating": { $ne: "" } }}, { $group: { _id: null, avg_rating: { $avg: "$imdb.rating" }, min_rating: { $min: "$imdb.rating" }, max_rating: { $max: "$imdb.rating" } }}]

D : [{ $match: { "imdb.rating": { $ne: "" } }}, { $group: { _id: null, avg_rating: { avg: "$imdb.rating" }, min_rating: { min: "$imdb.rating" }, max_rating: { max: "$imdb.rating" } }}]

Answer: C

Question 2

Consider the following scenario: You have a MongoDB collection named users that stores user information. Each document in the collection has the following structure:

{

"_id": ObjectId("609fe4b5728ad805aef1a88d"),

"name": "John Doe",

"age": 30,

"email": "johndoe@example.com",

"address": {

"street": "123 Main St",

"city": "New York",

"state": "NY",

"zipcode": "10001"

}

You need to retrieve all the documents from the users collection and convert them to an array format. Which of the following MongoDB queries should you use for this task?

A : db.users.find().convertToArray()

B : db.users.find().toArray()

C : db.users.toArray()

D : db.users.aggregate({ $toArray: "users" })

Answer: B

Question 3

Suppose you have a reviews collection with the following index:

{ stars: 1, votes: 1 }

Which of the following queries would be a covered query?

A : db.reviews.find( { votes: { $gte: 100 } }, { _id: 0, votes: 1, stars: 1 })

B : db.reviews.find( { votes: { $gte: 100 } }, { _id: 0, votes: 1 })

C : db.reviews.find( { votes: { $gte: 100 }, stars: 4.5 }, { _id: 0 })

D : db.reviews.find( { stars: { $gt: 4.5 } }, { _id: 0, votes: 1 })

Answer: D

Question 4

Suppose you insert the following documents into a companies collection:

db.companies.insertMany([

{"name": "Facebook"},

{"name": "X"}

])

Select all true statements about this command. (Select three)

A : This command will insert one document into the collection.

B : The command will only insert the first document and skip the second because the _id field is not explicitly provided.

C : This command will insert two documents into the collection.

D : MongoDB will automatically create an _id field for each document and it will be unique.

E : The _id field is not specified in any of these documents.

Answer: C,D,E

Question 5

Given the following documents in a collection:

{ _id: 1, n: [1,2,5], p: 0.75, c: 'Green' },

{ _id: 2, n: 'Orange', p: 'Blue', c: 42, q: 14 },

{ _id: 3, n: [1,3,7], p: 0.85, c: 'Orange' }

Which two documents can successfully be added in the same collection? (Select two)

A : { _id: 1, n: [1,2,5], p: 0.75, c: 'Green' }

B : { _id: 2, n: [1,2,5], p: 0.75, c: 'Green' }

C : { _id: 6, n: [1,3,7], p: 0.85, c: 'Orange }

D : { _id: 5, n: [1,2,5], p: 0.75, c: 'Green' }

Answer: C,D

Page: 1 / 83

Total 411 Questions | Updated On: Apr 02, 2026

Add To Cart