Free MongoDB C100DEV Exam Questions

Question 1

We have an accounts collection with the following document structure:

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239d"),

account_id: 864905,

limit: 10000,

products: [ 'Commodity', 'InvestmentStock' ]

},

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239e"),

account_id: 299072,

limit: 10000,

products: [ 'InvestmentFund', 'InvestmentStock' ]

},

{

_id: ObjectId("5ca4bbc7a2dd94ee5816239f"),

account_id: 137994,

limit: 10000,

products: [ 'CurrencyService', 'InvestmentStock' ]

}

We need to use Aggregation Framework to find the distribution of products field. Sort the result set by decreasing total number of products.

Expected output:

[

{ _id: 'InvestmentStock', total: 1746 },

{ _id: 'CurrencyService', total: 742 },

{ _id: 'Brokerage', total: 741 },

{ _id: 'InvestmentFund', total: 728 },

{ _id: 'Commodity', total: 720 },

{ _id: 'Derivatives', total: 706 }

]

Which pipeline should you use?

A : [{ $group: { _id: "$products", total: { $sum: 1 } }}]

B : [{ $unwind: { path: "$products" }}, { $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

C : [{ $unwind: { path: "products" }}, { $group: { _id: "products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

D : [{ $group: { _id: "$products", total: { $sum: 1 } }}, { $sort: { total: -1 }}]

Answer: B

Question 2

Given the following orders collection in MongoDB:

[

{

"_id": 1,

"customer": "John",

"orderDetails": [

{ "productId": "P1", "quantity": 2, "unitPrice": 50 },

{ "productId": "P2", "quantity": 1, "unitPrice": 30 }

]

},

{

"_id": 2,

"customer": "Sara",

"orderDetails": [

{ "productId": "P1", "quantity": 3, "unitPrice": 50 },

{ "productId": "P3", "quantity": 2, "unitPrice": 20 }

]

},

{

"_id": 3,

"customer": "Peter",

"orderDetails": [

{ "productId": "P2", "quantity": 2, "unitPrice": 30 },

{ "productId": "P4", "quantity": 1, "unitPrice": 100 }

]

}

]

Which MongoDB query will find all orders that contain a product with the productId of "P1" and a quantity greater than 1?

A : db.orders.find( { orderDetails: { $elemMatch: { productId: "P1", quantity: { $gt: 1 } } } } )

B : db.orders.find( { "orderDetails.productId": "P1", "orderDetails.quantity": { $gt: 1 } } )

C : db.orders.find( { orderDetails: { $elemMatch: { productId: "P1", quantity: { $gte: 1 } } } } )

D : db.orders.find( { "orderDetails.productId": "P1", "orderDetails.quantity": { $eq: 2 } } )

Answer: A

Question 3

Consider a MongoDB collection named orders which has documents in the following format:

{

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

"orderId" : 1001,

"customerId" : 200,

"items" : [

{

"productId" : 101,

"quantity" : 2

},

{

"productId" : 102,

"quantity" : 1

}

],

"totalAmount" : 250,

"status" : "Pending"

}

What is the correct syntax to find and update the first document in the orders collection where "status" is "Pending", and change the "status" field to "Completed" using the findAndModify method?

A : db.orders.findAndModify( { status: "Pending" }, { $set: { status: "Completed" } })

B : db.orders.findAndModify({ query: { status: "Pending" }, update: { $set: { status: "Completed" } }})

C : db.orders.findAndModify({ query: { status: "Pending" }, status: "Completed" })

D : db.orders.findAndModify({ status: "Pending" }, { status: "Completed" })

Answer: B

Question 4

You are working on a MongoDB database for a library system. The system tracks book information in a Books collection. A typical document in this collection looks like this:

Original Document:

{

"_id": ObjectId("book_id"),

"title": "The Art of Computer Programming",

"author": "Donald Knuth",

"genres": ["Computer Science", "Algorithms"],

"published_year": 1968,

"copies_available": 3

}

You are asked to update the document by replacing it with the following document:

Updated Document:

{

"title": "The Art of Computer Programming",

"published_year": 1973

}

After this update, what will the final document in the database look like?

A : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "published_year": 1973}

B : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "author": "Donald Knuth", "genres": ["Computer Science", "Algorithms"], "published_year": 1973, "copies_available": 3}

C : { "title": "The Art of Computer Programming", "published_year": 1973, "author": "Donald Knuth"}

D : { "_id": ObjectId("book_id"), "title": "The Art of Computer Programming", "published_year": 1973, "genres": ["Computer Science"]}

Answer: A

Question 5

Which of the following statements correctly describes the relationship between BSON and JSON in MongoDB?

A : BSON and JSON are exactly the same data format, and the terms can be used interchangeably.

B : MongoDB uses JSON for data storage, and BSON is only used for querying data.

C : BSON is a binary representation of JSON-like documents, with additional data types not found in JSON.

D : BSON is a subset of JSON and only includes a portion of JSON's data types.

Answer: C