Free MongoDB C100DEV Exam Questions

Question 1

Consider a collection named orders with the following documents:

{

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

"order_number" : 1001,

"customer_id" : "CUST-001",

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

"total_amount" : 199.99

},

{

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

"order_number" : 1002,

"customer_id" : "CUST-002",

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

"total_amount" : 299.99

},

{

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

"order_number" : 1003,

"customer_id" : "CUST-003",

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

"total_amount" : 399.99

}

What is the query to create a compound index on the "customer_id" (ascending) and "order_date" (descending) fields in the orders collection?

A : db.orders.createIndex({ order_date: -1, customer_id: 1 })

B : db.orders.createIndex({ customer_id: asc, order_date: desc })

C : db.orders.createIndex({ customer_id: 1, order_date: -1 })

D : db.orders.createIndex({ customer_id: -1, order_date: 1 })

Answer: C

Question 2

In a MongoDB database, you have a collection named orders that contains information about various product orders placed by customers. Each document in the collection has the following structure:

{

"customerID": "",

"orderID": "",

"product": "",

"quantity": ,

"price": ,

"date": "",

"status": ""

}

You are required to write an aggregation query that retrieves all orders placed by customers where the quantity of ordered items is greater than 100 and the status of the order is "delivered". Which of the following $match stages would you use to achieve this? Select the best option.

A : { "$match": { "quantity": { "$gt": 100 }, "status": "delivered" } }

B : { "$match": { "quantity": { "$lt": 100 }, "status": "delivered" } }

C : { "$match": { "quantity": { "$gt": 100 }, "status": { "$eq": "delivered" } } }

D : { "$match": { "quantity": { "$gte": 100 }, "status": "delivered" } }

Answer: A

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

Suppose you have a restaurants collection with the following document structure:

{

_id: ObjectId("5eb3d668b31de5d588f42931"),

address: {

building: '6409',

coord: [ -74.00528899999999, 40.628886 ],

street: '11 Avenue',

zipcode: '11219'

},

borough: 'Brooklyn',

cuisine: 'American',

grades: [

{

date: ISODate("2014-07-18T00:00:00.000Z"),

grade: 'A',

score: 12

},

{

date: ISODate("2013-07-30T00:00:00.000Z"),

grade: 'A',

score: 12

},

{

date: ISODate("2013-02-13T00:00:00.000Z"),

grade: 'A',

score: 11

},

{ date: ISODate("2012-08-16T00:00:00.000Z"),

grade: 'A',

score: 2 },

{

date: ISODate("2011-08-17T00:00:00.000Z"),

grade: 'A',

score: 11

}

],

name: 'Regina Caterers',

restaurant_id: '40356649'

}

You don't have any indexes so far. What will the query plan look like for the following query?

db.restaurants.find( { "cuisine": "American" } )

A : IXSCAN

B : SORT

C : FETCH

D : COLLSCAN

Answer: D

Question 5

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