Free MongoDB C100DEV Exam Questions

Question 1

Consider the following documents in a MongoDB collection orders:

{

"_id": 1,

"customer_id": 101,

"item": "apple",

"price": 0.5,

"quantity": 100,

"date": ISODate("2022-01-01T00:00:00Z")

},

{

"_id": 2,

"customer_id": 102,

"item": "banana",

"price": 0.25,

"quantity": 50,

"date": ISODate("2022-01-02T00:00:00Z")

},

{

"_id": 3,

"customer_id": 101,

"item": "orange",

"price": 0.75,

"quantity": 75,

"date": ISODate("2022-01-03T00:00:00Z")

}

What is the aggregation pipeline to group the documents by "customer_id" and calculate the sum of the "quantity" field for each group, sorted in descending order by the sum of the "quantity" field?

A : db.runCommand({ aggregate: "orders", group: { _id: "$customer_id", total_quantity: { $sum: "$quantity" } }, sort: { total_quantity: -1 }})

B : db.orders.aggregate([ { $group: { _id: "$customer_id", total_quantity: { $sum: "$quantity" } } }, { $sort: { total_quantity: 1 } }])

C : db.orders.aggregate([ { $groupBy: { customer_id: "$customer_id" }, total_quantity: { $sum: "$quantity" } }, { $sort: { total_quantity: 1 } }])

D : db.orders.aggregate([ { $group: { _id: "$customer_id", total_quantity: { $sum: "$quantity" } } }, { $sort: { total_quantity: -1 } }])

Answer: D

Question 2

You are developing a blogging platform using MongoDB as the database. Each blog post document has a tags array field that holds a list of strings. You are tasked to implement a search functionality that allows users to find blog posts based on the tags. Which of the following MongoDB features would you utilize to implement this functionality efficiently?

A : Capped Collections

B : Sharding

C : Text Indexes

D : Compound Indexes

E : GridFS

Answer: C

Question 3

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 4

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 5

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