MongoDB Associate Database Administrator

An Atlas Sample Dataset of restaurants is loaded into a database deployment.How is Data Explorer used to find all restaurants whose name is “The Rose Palace” in the Restaurants database?

Given the following query:

db.coll.find({}).sort({“income”: 1, “tax”: -1})

Which two indexes will improve the performance of this query the most? (Choose two.)

Given the following sample documents:{_id:1, company: “Farm Inc.”, active: true},

{_id:2, company: “Garden Inc.”, active: false} A developer wants to create a search query to search for a company. There is a business requirement to accommodate misspellings. An Atlas Search index has already been created for this query. What query satisfies these requirements?

Given the following documents in a collection:

{_id:1, a: “one”, b: “two”}

{_id:2, a: “two”, b: “three”}

{_id:3, a: “one”, b: “four”, c: “three”}

Using the following update command: db.coll.replaceOne({a: “one”}, {d: “two”, b: “five”})

What would the contents of the collection be after successfully running this command?

Given the following match expression:

{“c”: {$eq: “Green”}, “a”: {$gt: 3}}

{ _id: 1, p: 0.75, c: ‘Green’, a: [1,3,5,7]},

{ _id: 2, p: 0.80, c: ‘Orange, a: [1,3]},

{ _id: 3, p: 0.13, c: [‘Green’, ‘Orange’], a: [3]},

{ _id: 4, p: 0.00, c: ‘Green’, a: [5,7]},

{ _id: 5, p: 0.04, c: ‘Green’, a: 3},

{ _id: 6, p: 0.97, c: ‘Red, a:5}

What document will be returned from this expression?