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 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 3

How can we present the basic syntax for aggregation in MongoDB?

A :

B :

C :

D :

Answer: D

Question 4

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 5

Consider a MongoDB database managing e-commerce product data. The database has a collection named products with documents containing the fields product_id, category, price, and reviews. Each reviews field is an array of subdocuments with fields user_id, rating, and comment. You are tasked with optimizing a query that retrieves all products within a specific category that have an average rating higher than 4. The query is frequently used, and performance is critical. Which indexing strategy would best optimize this query?

A : Create a compound index on category and reviews.rating, with a partial filter expression that only includes documents where the average rating in reviews.rating is greater than 4.

B : Create a multi-key index on reviews.rating.

C : Create a compound index on category and reviews.rating.

D : Create a single index on the category field.

E : Create a compound index on category, reviews.rating, and price.

Answer: A