Free MongoDB C100DEV Exam Questions

Question 1

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 2

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 3

In the context of MongoDB development, you are creating a new service that is expected to handle high load. You've decided to leverage the MongoDB drivers' connection pooling capability. What best describes connection pooling and its advantages?

A : Connection pooling ensures secure data transfer between the client and the server by encrypting all connections in the pool.

B : Connection pooling allows a client to connect to a database only when a data transfer operation occurs, reducing the memory requirements.

C : Connection pooling involves maintaining a "pool" of open database connections, which can be reused for multiple requests, improving performance.

D : Connection pooling refers to the storage of multiple connection strings for redundancy, increasing system reliability.

Answer: C

Question 4

In MongoDB, which statement accurately describes a typical task for a MongoDB developer related to schema validation?

A : Schema validation enables the creation of complex relationships between multiple collections.

B : Schema validation guarantees the uniqueness of a specific field across all documents in a collection.

C : Schema validation ensures the presence of required fields and their data types within a document.

D : Schema validation provides real-time data synchronization across multiple MongoDB instances.

Answer: C

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