Free MongoDB C100DEV Exam Questions

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" } )