Free MongoDB C100DEV Exam Questions

Question 1

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

Question 2

You are managing a MongoDB collection named orders, where each document represents an order. The documents contain the following fields:order_id (String): The unique identifier for the order.customer_name (String): The name of the customer who placed the order.total_amount (Number): The total amount of the order.status (String): The status of the order, which can be "pending," "shipped," or "delivered."items (Array of Strings): A list of items included in the order.You want to find all orders that meet the following criteria:The order has a total amount greater than $1000.The order status is either "pending" or "shipped."The order contains either "laptop" or "smartphone" in the list of items.Which of the following queries would return the correct documents?

A :

B :

C :

D :

Answer: D

Question 3

Consider a tasks collection that holds task records. The document structure is as follows:

{

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

"task": "Review PR",

"status": "pending",

"assignedTo": "alice"

}

Two operations are performed concurrently:

Operation A:

db.tasks.findAndModify({

query: { task: "Review PR", status: "pending" },

remove: true

});

Operation B:

db.tasks.findAndModify({

query: { task: "Review PR", status: "pending" },

update: { $set: { status: "completed" } },

new: true

});

Operation B starts slightly after Operation A but before Operation A completes. What will be the final state of the tasks collection after both operations have been executed?

A : The document will be removed from the collection.

B : The document's status will be updated to "completed".

C : A new document with the status "completed" will be inserted.

D : The document's status will remain "pending".

Answer: A

Question 4

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 5

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