Free MongoDB C100DEV Exam Questions

Question 1

What is the difference between a sparse index and a non-sparse index in MongoDB?

A : A sparse index only indexes documents that contain the indexed field, while a non-sparse index indexes all documents in the collection, including those that do not contain the indexed field.

B : A sparse index indexes all documents in the collection, including those that contain the indexed field, while a non-sparse index only indexes documents that do not contain the indexed field.

C : A sparse index only indexes documents that do not contain the indexed field, while a non-sparse index indexes all documents in the collection, including those that contain the indexed field.

D : A sparse index indexes all documents in the collection, including those that do not contain the indexed field, while a non-sparse index only indexes documents that contain the indexed field.

Answer: A

Question 2

Consider a MongoDB collection named orders which has documents in the following format:

{

"_id" : ObjectId("5f5b0d2f3e3dfbcc11c84444"),

"orderId" : 1001,

"customerId" : 200,

"items" : [

{

"productId" : 101,

"quantity" : 2

},

{

"productId" : 102,

"quantity" : 1

}

],

"totalAmount" : 250,

"status" : "Pending"

}

What is the correct syntax to find and update the first document in the orders collection where "status" is "Pending", and change the "status" field to "Completed" using the findAndModify method?

A : db.orders.findAndModify( { status: "Pending" }, { $set: { status: "Completed" } })

B : db.orders.findAndModify({ query: { status: "Pending" }, update: { $set: { status: "Completed" } }})

C : db.orders.findAndModify({ query: { status: "Pending" }, status: "Completed" })

D : db.orders.findAndModify({ status: "Pending" }, { status: "Completed" })

Answer: B

Question 3

In a MongoDB collection named orders, you are tasked with retrieving a subset of documents that fulfill specific criteria. Each document in this collection contains the following fields: customerId, orderId, orderDate, and orderDetails (an embedded document with fields: product, quantity, unitPrice). You are required to fetch all orders made by the customer with a customerId of 1234 on a specific date 2023-04-12, and only return the orderId, orderDate, and product from orderDetails. Which of the following MongoDB queries would accurately fulfill these requirements?

A :

B :

C :

D :

Answer: A

Question 4

You have two collections in your MongoDB database: students and grades. The students collection contains the following document:

{

"_id": ObjectId("64d5b0e5c9d95a76ac3ebed2"),

"student_id": 1,

"name": "Alice"

}

The grades collection contains the following documents:

{

"_id": ObjectId("64d5b0e5c9d95a76ac3ebed3"),

"student_id": 2,

"course": "Math",

"grade": "A"

},

{

"_id": ObjectId("64d5b0e5c9d95a76ac3ebed4"),

"student_id": 2,

"course": "Science",

"grade": "B"

}

You run the following aggregation query to retrieve students along with their grades:

db.students.aggregate([

{

$lookup: {

from: "grades",

localField: "student_id",

foreignField: "student_id",

as: "grades_details"

}

])

What will be the structure of the documents returned by this aggregation query for the student with student_id: 1?

A : { "_id": ObjectId("64d5b0e5c9d95a76ac3ebed2"), "student_id": 1, "name": "Alice", "grades_details": null}

B : { "_id": ObjectId("64d5b0e5c9d95a76ac3ebed2"), "student_id": 1, "name": "Alice", "grades_details": []}

C : { "_id": ObjectId("64d5b0e5c9d95a76ac3ebed2"), "student_id": 1, "name": "Alice", "grades_details": [ { "course": "Math", "grade": "A" } ]}

D : { "_id": ObjectId("64d5b0e5c9d95a76ac3ebed2"), "student_id": 1, "name": "Alice", "grades_details": [ { "course": "Math", "grade": "A" }, { "course": "Science", "grade": "B" } ]}

Answer: B

Question 5

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