C100DBA Exam Dumps : MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4)

db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )

db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )

db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )

db.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )

Creating a sharded key automatically creates an index on the collection using that key

We cannot change a shard key directly/automatically once it is set up

A sharded environment does not support sorting functionality since the documents lie on various mongod instances

Sharding is enabled at the database level

Providing these parameters in any order does not impact the performance

$sort moves before $match

MongoDB does not do any movements by default and will use the order provided

$match moves before $sort