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

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

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 5

Suppose you have a restaurants collection with the following document structure:

{

_id: ObjectId("5eb3d668b31de5d588f42931"),

address: {

building: '6409',

coord: [ -74.00528899999999, 40.628886 ],

street: '11 Avenue',

zipcode: '11219'

},

borough: 'Brooklyn',

cuisine: 'American',

grades: [

{

date: ISODate("2014-07-18T00:00:00.000Z"),

grade: 'A',

score: 12

},

{

date: ISODate("2013-07-30T00:00:00.000Z"),

grade: 'A',

score: 12

},

{

date: ISODate("2013-02-13T00:00:00.000Z"),

grade: 'A',

score: 11

},

{ date: ISODate("2012-08-16T00:00:00.000Z"),

grade: 'A',

score: 2 },

{

date: ISODate("2011-08-17T00:00:00.000Z"),

grade: 'A',

score: 11

}

],

name: 'Regina Caterers',

restaurant_id: '40356649'

}

You don't have any indexes so far. What will the query plan look like for the following query?

db.restaurants.find( { "cuisine": "American" } )

A : IXSCAN

B : SORT

C : FETCH

D : COLLSCAN

Answer: D