Free MongoDB C100DEV Exam Questions

Question 1

Consider a collection named students with the following document:

{

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

"name" : "Alice",

"age" : 21,

"courses" : [

{

"name" : "Math",

"grade" : 89

},

{

"name" : "Science",

"grade" : 92

}

]

}

What is the query to update the grade of the "Math" course for the student with "_id" equal to ObjectId("5f0a7e80d8c9c7b5a48c49e1") to 95?

A : db.students.updateOne( { "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

B : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1") }, { $set: { "courses.$.grade": 95 } })

C : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "courses.$.grade": 95 } })

D : db.students.updateOne( { _id: ObjectId("5f0a7e80d8c9c7b5a48c49e1"), "courses.name": "Math" }, { $set: { "grade": 95 } })

Answer: C

Question 2

You have a MongoDB collection named employees that contains documents with fields name, department, and salary. You want to update the salary of all employees in the "Marketing" department to $75,000. The original collection looks like this:

[

{ "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 },

{ "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 },

{ "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 62000 },

{ "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }

]

You run the following MongoDB update operation:

db.employees.updateMany(

{ "department": "Marketing" },

{ $set: { "salary": 75000 } }

)

What will the collection look like after this update operation?

A : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

B : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 62000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 62000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

C : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 75000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

D : [ { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 }, { "_id": 2, "name": "Bob", "department": "Sales", "salary": 75000 }, { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 75000 }, { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }]

Answer: C

Question 3

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

{

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

"name" : "Smartphone",

"brand" : "Apple",

"category" : "Electronics",

"price" : 1000,

"discount" : 0.1

}

What is the correct syntax to update the "price" field of all documents in the products collection by multiplying it with (1 - discount) using the $set operator and the $multiply operator?

A : db.products.update( {}, { $set: { price: { $multiply: ["$price", { $subtract: [1, "$discount"] }] } } })

B : db.products.updateMany( {}, { $set: { price: { $multiply: ["$price", 1 - $discount] } } })

C : db.products.update( {}, { $set: { price: { $multiply: ["$price", 1 - $discount] } } })

D : db.products.updateMany( {}, { $set: { price: { $multiply: ["$price", { $subtract: [1, "$discount"] }] } } })

Answer: D

Question 4

In a MongoDB database with referenced relationships, what is the advantage of using a separate collection for each entity over using a single collection for all entities?

A : Improved maintainability and reduced complexity of updates to related entities.

B : Improved query performance and reduced complexity of updates to related entities.

C : Improved maintainability and increased scalability.

D : Improved query performance and increased scalability.

Answer: A

Question 5

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