C100DBA Exam Dumps - MongoDB Certified DBA Associate Questions and Answers

For a compound index to satisfy a multi-field sort, the indexed fields must occur in the same sequence as the sort specification, and their directions must either match the requested pattern or be the complete reverse of it. The query sorts by { department: 1, salary: -1 }, so option B exactly matches both the key order and the requested directions. MongoDB can scan that index and return the results already ordered, avoiding a blocking in-memory sort. Option A uses { department: 1, salary: 1 }, which does not match the mixed-direction sort and is not its full inverse. Option D puts name before the two sort keys. Because the query has no equality predicate on name, that leading key prevents the later fields from directly providing the requested global sort. Option C is not a sensible index definition for this workload. Separately, the displayed projection mixes inclusion and exclusion (name:1, salary:1, department:0), which MongoDB normally disallows except for _id; that syntax issue should be corrected independently. It does not change the intended index answer for the sort, which is B.

Study Guide reference/topic:Indexing and Query Optimization - compound indexes, sort support, index prefixes, and key direction.

===========

db.collection.getIndexes() is the mongosh method used to return the definitions of all indexes that currently exist on a collection. The result is an array of index specification documents that can show fields such as the index name, key pattern, index version, uniqueness, partial-filter settings, sparse configuration, collation, and whether the index is hidden. This makes the method useful for index audits, troubleshooting, and confirming the physical indexes available to the query planner. Option A is not a documented method for enumerating collection indexes. Option B resembles the $indexStats aggregation stage, which reports usage statistics for indexes, but db.collection.indexStats() is not the method used to list full index definitions. Option C, findIndexes(), is also not the documented mongosh collection helper. Administrators should distinguish between listing index definitions, examining index usage, and inspecting an individual query ' s winning plan: getIndexes() addresses the first requirement, $indexStats addresses usage metrics, and explain() addresses query-planner behavior. Therefore option D is the correct command for listing all indexes on the collection.

Study Guide reference/topic:Indexing and Query Optimization - index administration, index metadata, and db.collection.getIndexes().

===========

A replica-set secondary maintains a replicated copy of the primary ' s dataset. The primary records data-changing operations in its oplog, and secondary members continuously copy and apply those oplog entries asynchronously to keep their data synchronized. This redundancy allows an eligible secondary to participate in an election and potentially become primary if the current primary becomes unavailable. mongos, option B, is the query-routing process used in a sharded cluster; it does not store an application dataset copy. An arbiter, option C, participates in replica-set voting and elections but deliberately does not maintain a copy of the database data. A shard, option D, is a data partition in a sharded cluster and is normally implemented as a replica set in production, but “shard” is not the replica-set member role that replicates the primary ' s data. Secondary behavior is central to MongoDB high availability, read-scaling options, backup strategies, and failover. Administrators monitor secondary replication lag and health to ensure the copies remain sufficiently current. Therefore the member responsible for maintaining copies of the primary ' s data is the secondary, making option A correct.

Study Guide reference/topic:Cluster Reliability and Data Resilience - replica-set primaries, secondaries, oplog replication, and redundancy.

===========