Free MongoDB C100DEV Exam Questions

Question 1

Which of the following scenarios is best suited for applying the Attribute Pattern?

A : Product categories in the online store.

B : You need to apply document validation before inserting/modifying.

C : The documents in the collection are quite large.

D : Some fields share a similar characteristics, and you want to search across those fields.

Answer: D

Question 2

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 3

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

Question 4

In MongoDB, the $out operator is commonly used within an aggregation pipeline. Which of the following statements accurately describes the functionality and usage of the $out operator?

A : $out operator is used to output the results to a specified collection.

B : $out operator can be used to output the results to a collection in a different MongoDB database.

C : $out operator is used to export data directly to a file.

D : $out operator is used to read data from multiple collections in a single command.

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