Suppose your aggregation pipeline terminated with an exception referring to exceeded memory limit. What is the best way to resolve the issue?

June 25, 2021 Team Pa 0 Comment

MongoDB LinkedIn Assessment Questions and Answers

Set useMemory to twice amount indicated in exception.
Switch a 64 bit instance of MongoDB.
Increase the memory of the MongoDB server.
Set allowDiskUse to true.

Leave a Reply Cancel reply

You have a collection named restaurants with the geographical information stored in the location property, how do you create a geospatial index on it?You have a collection named restaurants with the geographical information stored in the location property, how do you create a geospatial index on it?

db.restaurants.CreateIndex({location: “2dsphere”}) db.restaurants.geospatial({location: “2dsphere”}) db.restaurants.CreateIndex(“2dsphere”:”location”) db.restaurants.CreateIndex({geospatial: “location”})[...]

READ MORE

You want to know how many types of items you have in each category. Which query does this?You want to know how many types of items you have in each category. Which query does this?

db.product.group({_id: “$category”, count: {$sum:1}}) db.product.aggregate($sum: {_id: “$category”, count: {$group:1}}) db.product.aggregate($group: {_id: “$category”, count: {$sum:1}}) db.product.aggregate($count: {_id: “$category”, count: {$group:1}})[...]

READ MORE

On a newly created collection, which field will have an index?On a newly created collection, which field will have an index?

the name field the ObjectId field the _id field no field will have an index[...]

READ MORE