Free MongoDB C100DEV Exam Questions

Question 1

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 2

Consider a collection named orders with the following documents:

{

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

"order_id" : 101,

"customer_name" : "John Doe",

"order_date" : ISODate("2022-01-01T00:00:00.000Z"),

"items" : [

{

"product_name" : "Apple",

"quantity" : 2,

"price" : 0.99

},

{

"product_name" : "Banana",

"quantity" : 5,

"price" : 0.5

}

]

}

{

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

"order_id" : 102,

"customer_name" : "Jane Doe",

"order_date" : ISODate("2022-01-02T00:00:00.000Z"),

"items" : [

{

"product_name" : "Orange",

"quantity" : 3,

"price" : 0.79

},

{

"product_name" : "Mango",

"quantity" : 2,

"price" : 1.99

}

]

}

{

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

"order_id" : 103,

"customer_name" : "Bob Smith",

"order_date" : ISODate("2022-01-03T00:00:00.000Z"),

"items" : [

{

"product_name" : "Peach",

"quantity" : 4,

"price" : 1.49

},

{

"product_name" : "Pear",

"quantity" : 1,

"price" : 2.99

}

]

}

What is the query to retrieve the total sales for each customer in the orders collection?

A : db.orders.aggregate([ { $group: { _id: "$customer_name", total_sales: { $sum: { $multiply: ["$items.quantity", "$items.price"] } } } }])

B : db.orders.aggregate([ { $unwind: "$items" }, { $group: { _id: "$customer_name", total_sales: { $sum: { $multiply: ["$items.quantity", "$items.price"] } } } }])

C : db.orders.aggregate([ { $unwind: "$items" }, { $group: { total_sales: { $sum: { $multiply: ["$items.quantity", "$items.price"] } } } }])

D : db.orders.aggregate([ { $unwind: "$items" }, { $group: { _id: "$customer_name", total_sales: { $sum: { $multiply: ["quantity", "price"] } } } }])

Answer: B

Question 3

What is the correct syntax to insert multiple documents into a MongoDB collection named orders and return the _id values for all inserted documents?

A :

B :

C :

D :

Answer: B

Question 4

As a MongoDB Developer, you are tasked with the deletion of specific documents in a collection named users. The documents to be deleted are those that meet the following criteria: the age field is less than 18 and the status field is "inactive". After the deletion, you need to know the count of the deleted documents. Which of the following commands would correctly perform this operation?

A :

B :

C :

D :

E :

Answer: A

Question 5

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