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

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 4

How can you insert a new document into a MongoDB collection named customers?

A :

B :

C :

D :

Answer: D

Question 5

Consider a MongoDB database containing a collection of documents representing online orders for an e-commerce website. The documents have the following structure:

{

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

"order_number": "ORD-001",

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

"customer": {

"name": "John Doe",

"email": "johndoe@example.com"

},

"items": [

{ "product_name": "Smartphone", "quantity": 2, "price": 800 },

{ "product_name": "Laptop", "quantity": 1, "price": 1500 }

],

"shipping_address": {

"street": "123 Main St",

"city": "New York",

"state": "NY",

"zipcode": "10001"

},

"total_amount": 3000

}

Select an aggregation pipeline that returns the total sales amount by state and month, for orders placed in the year 2022. The result should have the following format:

A : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$group": { "_id": { "state": "$shipping_address.state", "month": { "$month": "$order_date" } }, "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

B : [ { "$group": { "_id": { "state": "$shipping_address.state", "month": { "$month": "$order_date" } }, "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

C : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$group": { "sales_amount": { "$sum": "$total_amount" } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

D : [ { "$match": { "order_date": { "$gte": ISODate("2022-01-01T00:00:00.000Z"), "$lt": ISODate("2023-01-01T00:00:00.000Z") } } }, { "$project": { "state": "$_id.state", "month": "$_id.month", "sales_amount": "$sales_amount", "_id": 0 } }]

Answer: A