Free MongoDB C100DEV Exam Questions

You have a MongoDB collection named employees that contains documents with fields name, department, and salary. You want to update the salary of all employees in the "Marketing" department to $75,000. The original collection looks like this:

[

  { "_id": 1, "name": "Alice", "department": "Marketing", "salary": 60000 },

  { "_id": 2, "name": "Bob", "department": "Sales", "salary": 55000 },

  { "_id": 3, "name": "Charlie", "department": "Marketing", "salary": 62000 },

  { "_id": 4, "name": "David", "department": "Engineering", "salary": 70000 }

]

You run the following MongoDB update operation:

db.employees.updateMany(

  { "department": "Marketing" },

  { $set: { "salary": 75000 } }

)

What will the collection look like after this update operation?

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

{

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

    "name" : "Smartphone",

    "brand" : "Apple",

    "category" : "Electronics",

    "price" : 1000,

    "discount" : 0.1

}

What is the correct syntax to update the "price" field of all documents in the products collection by multiplying it with (1 - discount) using the $set operator and the $multiply operator?

Given a movies collection where each document has the following structure:

{

    _id: ObjectId('573a1390f29313caabcd60e4'),

    genres: [ 'Short', 'Comedy', 'Drama' ],

    title: 'The Immigrant',

    year: 1917,

    imdb: { rating: 7.8, votes: 4680, id: 8133 },

    countries: [ 'USA' ]

}

Which of the following queries will find all the movies that have more votes than the year in which they were released?