Become MongoDB Certified with updated C100DEV exam questions and correct answers
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?
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" } )
© Copyrights DumpsCertify 2025. All Rights Reserved
We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the DumpsCertify.