scenario questions

An application uses a compound index on `{ 'status': 1, 'priority': -1 }`. Which query will efficiently use this index?

What is the primary benefit of using a Covered Query in MongoDB?

Refer to the exhibit. What is the primary cause of the performance issue seen in this query plan?

A collection has a 'status' field with only three possible values: 'active', 'pending', and 'closed'. Why is 'status' a poor choice for a shard key by itself?

Refer to the exhibit. What is the effect of the 'writeConcern' parameter in this operation?

A financial services company runs a sharded MongoDB cluster with three shards. They need to shard a new collection that stores transaction records. The collection will be queried primarily by 'accountId' and 'transactionDate'. The team wants to minimize scatter-gather queries and ensure even data distribution. Which two actions should they take when choosing and implementing the shard key? (Choose two.)

An organization wants to restrict customer data for European Union residents to a specific set of physical servers located in Frankfurt, complying with data residency regulations. Which MongoDB sharding feature should the DBA implement to achieve this?

A MongoDB DBA is configuring a new sharded cluster. The application requires that queries on the sharded collection include the shard key to avoid scatter-gather. The DBA decides to use a ranged shard key on the field 'region'. After sharding, the DBA notices that queries filtering only on 'region' are performing well, but queries that also filter on 'city' are still scanning all shards. What is the most likely cause?

How does the 'w: majority' write concern align with the philosophy of data reliability in MongoDB?

What happens to the replica set if a majority of voting members are permanently lost?

What happens if you run an update operation with the $set operator on a field that does not yet exist in the document?

A production MongoDB 6.0 sharded cluster has a collection with a ranged shard key on the field `customerId`. Over time, the team notices that nearly all new documents have monotonically increasing `customerId` values, and one shard is receiving a disproportionate share of writes while the other shards remain relatively idle. The balancer is enabled and running. Which of the following is the most likely explanation for this imbalance?

When using 'readConcern: majority', what is the specific guarantee provided to the client?

A security audit requires that sensitive document data contained in query parameters must not be written to the MongoDB system logs. Which server configuration setting should be enabled?

Refer to the exhibit. An aggregation pipeline is failing with an error. How can you modify the pipeline to allow it to process the large dataset?

What occurs when a replica set member experiences a 'rollback'?

Which command is used to check the current replication lag status on a secondary node?

Refer to the exhibit. What does this output indicate about the query performance?

A logistics company is designing a MongoDB database for a real-time shipment tracking system. The operations team needs to frequently update shipment statuses and query the latest events. The development team is debating the trade-offs of embedding versus referencing for the shipment events. Which two considerations align with MongoDB's philosophy for this scenario? (Choose two.)

A retail application stores product documents in the `products` collection. Each document has an `inventory` array of embedded subdocuments, for example: `{ _id: 1, name: "Widget", inventory: [ { sku: "A1", qty: 5 }, { sku: "B2", qty: 8 } ] }`. The warehouse team needs to increase the `qty` of the subdocument with `sku: "B2"` by 3 for the product with `_id: 1`. Which update operation accomplishes this?

A developer needs to insert a document into the inventory collection and wants the operation to fail with a duplicate key error if a document with the same value for the sku field already exists. The sku field has a unique index. Which insert method and option combination achieves this with the least code?

Which operator is best used to add an element to an array only if it does not already exist?

A DBA is reviewing update operations that use the upsert option. Which TWO statements about upsert behavior in MongoDB are correct? (Choose two.)

A collection called events stores documents with an array field named tags. You need to remove all occurrences of the string "obsolete" from the tags array in every document where the array contains that value, without affecting other elements. Which update operator should you use?

A DBA notices that a query on the products collection uses an index scan but returns only a small fraction of documents. The index is { category: 1, price: 1 }. The query filters on category and price with a range condition on price. Which statement best describes why the index might still be efficient despite scanning many index entries?

An administrator needs to distribute a high-throughput collection evenly across a sharded cluster using a hashed shard key. What is the primary characteristic of MongoDB's hashed sharding strategy that makes it effective for preventing write bottlenecks?

A DBA executes 'mongodump --oplog' against a primary node in a replica set. What is the specific purpose of the --oplog flag in this administrative context?

A sharded cluster has a three-member replica set for its config servers. If two of the three config servers go offline, what is the immediate impact on the cluster's operations?

Refer to the exhibit. Which index is most effective for this query?

Which connection string parameter should be used to ensure an application driver automatically discovers all members of a replica set?

When using the find() method, which cursor modifier is used to skip a specific number of documents before returning results?

An application executes a query on a sharded collection that does not include the shard key. What is the impact on the cluster performance?

Which THREE actions occur when a MongoDB secondary node performs an initial sync?

Which situation is best suited for a Multikey Index?

What is the consequence of having a high number of 'keysExamined' compared to 'nReturned' in a query?

What happens when you perform a find() query on a collection where the projection includes both an inclusion and an exclusion for different fields?

When evaluating index performance, what is the impact of a 'partial index'?

A company is migrating from a monolithic SQL database to MongoDB. They want to maintain high availability. Which feature is most critical to their success?

A collection 'events' has a compound index { tenantId: 1, createdAt: -1 }. A developer runs db.events.find({ tenantId: "acme", createdAt: { $gte: ISODate("2024-01-01") } }).sort({ createdAt: -1 }).limit(50). The explain output shows the index is used but the query still performs a large in-memory sort. Which action resolves the sort performance issue?

You are a DBA for a MongoDB replica set. A secondary node has been down for several days and is far behind the primary. The oplog on the primary has wrapped, and the secondary's last oplog entry is no longer present. What must you do to bring the secondary back into sync?

Refer to the exhibit. An administrator inspects chunk metadata for a sharded collection using a compound shard key: { region: 1, account_id: 1 }. What does the presence of MinKey and MaxKey signify in this specific chunk range definition?

A MongoDB 6.0 sharded cluster has a collection sharded with a hashed shard key on 'userId'. The operations team needs to run an aggregation that groups documents by 'userId' and calculates the total transaction amount. They want to know whether the aggregation can be optimized to run only on the shards that contain the relevant 'userId' values. Which statement describes the correct behavior?

You are updating a document in the `products` collection. The document has an array field `tags`. You need to add the tag "sale" to the array only if it does not already exist, and you want to ensure that no duplicate tags are added even if multiple updates run concurrently. Which update operator should you use?

A media company stores articles with nested comments and tags. The development team wants to retrieve an article along with its comments in a single database round trip. Which MongoDB philosophy supports this design?

Refer to the exhibit. What is the impact of this operation on the document?

A startup is building a content management system where the document structure varies significantly between blog posts, product pages, and user profiles. Which fundamental MongoDB philosophy best supports this requirement?

What is the primary function of the 'wtimeout' setting in write concern?

An administrator wants to audit all authentication attempts on a MongoDB Enterprise instance. Which feature should be configured to track these events?

A DBA is reviewing a slow query on the `orders` collection. The query is: `db.orders.find( { status: "shipped", total: { $gt: 100 } } )`. The collection has an index on `{ status: 1, total: 1 }`. Which statement best describes how MongoDB will use this index to satisfy the query?

Which TWO of the following are valid reasons to use an arbiter in a MongoDB replica set?

Which mechanism ensures an application receives an error if a write is not persisted to the majority of nodes in a replica set?

A DBA is troubleshooting a slow query on a large collection. Which two techniques directly reduce the number of documents the query must examine for an equality-plus-range predicate? (Choose two.)

A healthcare startup is evaluating MongoDB for a patient management system. The CTO asks how MongoDB ensures data durability and consistency across multiple servers without manual intervention. Which feature best describes MongoDB's built-in mechanism for automatic failover and data redundancy?

A development team is building a Node.js application that connects to a MongoDB replica set. They want the driver to automatically retry certain write operations once if they fail due to a transient network error, without requiring custom retry logic in their code. Which connection string option should they enable?

What is the consequence of MongoDB's 'write concern' in a distributed environment?

When is it appropriate to use a hashed shard key instead of a ranged shard key in a MongoDB sharded collection?

An e-commerce application frequently runs a query filtering by category and sorting by price descending. Which index structure provides the optimal performance for this access pattern?

A sharded cluster has a collection sharded on `{ location: 1 }`. A query is executed with the filter `{ location: { $in: ["NY", "CA"] } }`. How does MongoDB route this query?

You are configuring a MongoDB replica set for a global application. You need to add a member that will never become primary and will be invisible to client applications. Which two steps must you take when adding this member? (Choose two.)

A startup is building a mobile app backend. They want to iterate quickly on features without downtime for schema changes. Which MongoDB characteristic best supports this agile development approach?

A database administrator wants to configure a read preference that directs all read operations to the primary node of a replica set, ensuring the most up-to-date data. Which read preference mode should be used?

An application needs to perform a series of reads and writes across multiple documents in two collections atomically. The deployment is a replica set running MongoDB 4.2. Which feature should the application use?

When designing a compound shard key in MongoDB, what is the architectural significance of placing a high-cardinality field as the prefix compared to placing a low-cardinality field first?

Refer to the exhibit. An application queries active user documents frequently, but explainPlan output reveals a COLLSCAN stage. What is the most appropriate remediation step?

A database is experiencing high latency. You run 'mongotop 5'. What specific insight does this provide compared to 'mongostat' for server administration?

A DBA is troubleshooting a sharded cluster where the balancer is not migrating chunks even though there is an imbalance. The DBA runs `sh.getBalancerState()` and it returns `true`. Which of the following is the most likely reason the balancer is not migrating chunks?

A DBA observes that a query with filter { a: 5, b: { $gt: 10 } } and sort { c: 1 } is using a collection scan despite the existence of an index { a: 1, b: 1, c: 1 }. The DBA wants to improve performance. Which action is most likely to allow the index to support both the filter and the sort?

A global IoT platform ingests sensor readings from millions of devices. The team must choose a database that can store semi-structured data, scale horizontally, and provide high write throughput. Which TWO MongoDB features directly support these requirements? (Choose two.)

A server has multiple network interfaces including a public IP and a private management IP. How should the 'net.bindIp' configuration be managed to follow security best practices?

You are maintaining an inventory collection where each document has a field named `stock` (integer). A nightly job needs to atomically decrement `stock` by 1 for the document with `sku: "A100"` and also insert the current timestamp into a `lastUpdated` field in the same operation, without overwriting any other fields. Which update operation should you use?

A DBA is configuring a replica set with three members: one primary and two secondaries. The DBA wants to ensure that a write concern of { w: 'majority' } is acknowledged only after the write has been applied to a majority of voting members and has been written to the on-disk journal on those members. Which write concern should the DBA use?

What is the primary benefit of the BSON format in MongoDB?

Which method is the safest way to delete a single document from a collection based on a unique identifier?

In a replica set, what is the 'oplog' and why is it important?

Which THREE of the following are valid MongoDB CRUD query operators?

You are the DBA for a MongoDB 6.0 replica set with three voting members: rs0-primary (priority 2), rs0-secondary-1 (priority 1), and rs0-secondary-2 (priority 1). The primary fails and is unavailable for an extended period. You need to ensure that rs0-secondary-1 is elected as the new primary instead of rs0-secondary-2. Which action should you take before the primary fails?

Which of these best describes MongoDB's approach to the CAP theorem?

Which of the following describes the 'schema-less' nature of MongoDB?

When adding a new member to an existing replica set, what is the most common reason for the initial sync process to fail if the data set is extremely large?

When would you choose to create a Partial Index instead of a standard index?

A financial application requires that read operations never return data that could later be rolled back, even if it means reading from a secondary. The application connects to a replica set with readPreference=secondary. Which read concern level should be used to guarantee that the data read has been acknowledged by a majority of replica set members and cannot be rolled back?

Which TWO of the following scenarios are best handled by a Hashed Index?

A DBA needs to grant a new application service account the ability to read and write data in any database except the admin database on a MongoDB 6.0 replica set. The account should not be able to perform administrative actions such as managing users or shutting down the server. Which built-in role should the DBA assign?

Refer to the exhibit. What philosophy regarding client connectivity does this log entry reflect?

When enabling access control on a production sharded cluster, what is the most secure method for ensuring internal authentication between cluster components such as mongos and mongod instances?

An application is using a capped collection for logging. What happens when the collection reaches its configured size limit?

Refer to the exhibit. What is the implication of setting the priority of n2 to 0?

How can you prevent a specific node from becoming a primary in a replica set?

Which method is the most efficient way to perform a bulk update of multiple documents in a single request?

Which TWO of the following are primary benefits of implementing sharding in a MongoDB environment?

In a dedicated server environment, what is the primary reason an administrator would choose to manually decrease the 'storage.wiredTiger.engineConfig.cacheSizeGB' below the default value?

An application needs to update a user's balance. Which method ensures the operation is atomic for a single document?

A DBA needs a query that returns only the fields name and email from a 'users' collection, filtered by an equality on email, to avoid fetching full documents from disk. Which index design supports this efficiently?

A multi-document transaction is being executed across multiple shards. Which component is responsible for coordinating the transaction and ensuring the all-or-nothing property?

A logistics company uses MongoDB to track shipments. Each shipment document includes a status field and an array of location updates. The company wants to ensure that when a shipment's status changes to "delivered," the corresponding location update is also recorded atomically. Which MongoDB feature best supports this requirement while adhering to the philosophy of document atomicity?

A developer needs to retrieve a subset of fields from a collection. Which TWO methods achieve this using projection?

A DBA needs to ensure that chunk migrations only occur during a specific maintenance window from 02:00 to 04:00. Which configuration change is required?

A high-traffic e-commerce application requires a schema that avoids multi-document transactions where possible to ensure maximum throughput. Which MongoDB philosophy aligns best with this requirement?

An operations engineer notices that a frequently executed aggregation pipeline fails with a 'Exceeded memory limit for $sort' error. Which index configuration best resolves this memory constraint?

A DBA is designing indexes for a collection that stores user activity logs. The collection has fields: user_id, action, timestamp, and metadata (an embedded document). The most common queries are: (1) find all actions for a given user_id sorted by timestamp descending; (2) find all users who performed a specific action within a time range. Which TWO indexes would best support these queries? (Choose two.)

Which THREE of the following are core tenets of the MongoDB philosophy regarding data modeling?

What is the result of applying a $push operator with a value of [1, 2] to an existing array field [0]?

When evaluating the performance of a 'hint' in MongoDB, what should you keep in mind?

A collection 'logs' receives continuous inserts and is queried by both timestamp ranges and a rarely used severity field. A DBA creates six indexes to cover every query variant, and now insert throughput has dropped sharply while index sizes dominate the working set. Which action best restores insert throughput while preserving the important query paths?

An application uses a MongoDB driver that supports retryable writes. A write operation is sent to the primary, which applies the write but crashes before sending the acknowledgment. The driver receives a network error. What will the driver do by default?

A MongoDB DBA is asked to ensure that the mongod process on a Linux server automatically restarts if it crashes. The server uses systemd. Which command should the DBA run to enable this behavior?

Which THREE components are required to form a functional MongoDB sharded cluster?

Which MongoDB feature allows an application to receive real-time updates when data changes in a collection?

You are a MongoDB DBA at a retail company. The 'orders' collection has a document with _id: 100 and status: 'pending'. You need to atomically update the status to 'shipped' only if the current status is 'pending'. Which update operation should you use?

In a three-node replica set with default write concerns, what occurs when the primary node experiences a network partition and cannot communicate with the majority of the set?

A MongoDB 6.0 sharded cluster has a collection with a ranged shard key on the field 'customerId'. The balancer has been running normally, but the operations team notices that one shard consistently holds significantly more chunks than the others. They want to understand which internal metadata collection the mongos uses to determine chunk distribution and to verify the current chunk-to-shard mapping. Which collection should they query?

A MongoDB application requires that reads never see data that could be rolled back, even in the event of a replica set failover. The application also needs to read from secondary nodes to distribute load. Which read concern should be used with a secondary read preference?

An administrator notices that the balancer in a MongoDB sharded cluster is repeatedly migrating chunks between two shards, causing performance degradation. The administrator wants to temporarily stop the balancer to investigate. Which command should be used on mongos?

What is the primary motivation for MongoDB's 'WiredTiger' storage engine to provide document-level concurrency control?

Refer to the exhibit. Which documents will this query return?

You are a MongoDB DBA and need to retrieve all documents from the 'products' collection where the 'price' field is greater than 100 and the 'category' is 'electronics'. Which query accomplishes this?

A developer chooses Hashed Sharding for a collection. What is a significant limitation of this sharding strategy compared to Ranged Sharding?

An application uses a time-series collection. What is the benefit of using the TTL (Time-To-Live) index feature?

An engineering team must shard a high-volume collection tracking global financial transactions. The chosen shard key is based on a timestamp field containing the exact millisecond of each transaction. Why will this specific shard key choice severely degrade cluster write performance over time?

What is the result of setting the 'votes' configuration to 0 for a specific node in a replica set?

Which THREE metrics provided by the 'mongostat' utility are most helpful for identifying a performance bottleneck caused by a high volume of concurrent write operations?

A support team reports that a MongoDB 6.0 replica set is experiencing slow queries on a collection where almost every document has a unique value for the field status. A developer suggests creating a hashed index on status to speed up equality lookups. Which outcome should the DBA expect?

Which query operator matches documents where a field contains a value greater than or equal to a specified value?

When a secondary node is lagging behind the primary, what is the most significant risk to the replica set if the lag time exceeds the length of the oplog?

Refer to the exhibit. The MongoDB process has crashed due to a storage engine error. What is the most immediate administrative action required to restore service?

Which feature of MongoDB allows it to scale horizontally by distributing data across multiple physical servers?

Refer to the exhibit. If the primary node fails, which node is most likely to be elected the next primary based on optime?

Which operator is used to perform a logical OR operation across multiple query conditions?

What is the primary function of the oplog in a MongoDB replica set?

What is the primary function of the 'projection' parameter in the find() method?

A social media company is using MongoDB to store user posts and comments. The application needs to retrieve a post along with its most recent comments in a single query. Which data modeling approach best aligns with MongoDB's philosophy to optimize this access pattern?

A sharded cluster stores customer documents in the customers collection, sharded on the customerId field. An application runs an updateOne with the filter { email: "user@example.com" } and the update { $set: { tier: "gold" } }. The email field is not the shard key and has no index. What is the most likely outcome of this operation?

A developer is using the MongoDB Node.js driver and wants to ensure that a write operation is acknowledged by a majority of replica set members and is also written to the on-disk journal before returning success. Which write concern should be specified?

What is the primary purpose of an Arbiter in a MongoDB replica set?

During a peak load period, the 'page faults' metric in mongostat increases significantly. What is the most likely administrative cause related to server resources?

A healthcare provider is building a patient portal that must remain available even if a data center loses power. The operations team wants the database to continue accepting writes during a single-region outage. Which MongoDB philosophy directly enables this resilience?

A DBA needs to automate log rotation on a Linux-based MongoDB server without restarting the mongod process. Which signal or command should be used to ensure the current log file is archived and a new one is started?

A DBA is preparing to shard a collection in a MongoDB 6.0 cluster. The collection currently has no indexes other than the default _id index. The chosen shard key is { userId: 1 }. What must the DBA do before running shardCollection?

You are monitoring a MongoDB replica set and notice that the replication lag on a secondary is increasing steadily. You suspect that the secondary is unable to keep up with the write load. Which administrative action should you take first to diagnose the issue?

A MongoDB DBA is configuring a new application to connect to a sharded cluster. The application requires that reads are distributed across shards and that the driver automatically routes queries to the appropriate shard based on the shard key. Which component must be included in the connection string to enable this routing?

Which TWO statements accurately describe the behavior and management of orphaned documents in a MongoDB sharded cluster? Choose 2 answers.

Why does MongoDB use a 'document' as its fundamental unit of data?

Which command is used to verify the current replica set configuration and the state of all members?

An application is performing many updates to a document. Which strategy is most effective to avoid fragmentation in the data files?

Why does MongoDB support both embedding and referencing in data modeling?

Refer to the exhibit. The explain output shows a SORT stage wrapping an IXSCAN stage. What is the performance implication of this execution plan?

A DBA is investigating a performance issue. A query on the `logs` collection uses the following filter: `{ $or: [ { level: "error" }, { level: "warning" } ] }`. There is an index on `{ level: 1 }`. Which statement correctly describes how MongoDB executes this query?

A developer reports slow queries on a specific collection. You decide to enable the database profiler to capture only queries taking longer than 200ms. Which command configuration achieves this?

A three-member replica set has default settings, and all three members are healthy. A DBA needs to perform an index build on the primary during business hours. Which concern should the DBA consider regarding replica set behavior?

A database administrator is configuring a MongoDB replica set. The application requires that writes are acknowledged by a majority of voting members before being considered successful, and that the write is also written to the on-disk journal before acknowledgment. Which write concern specification achieves this?

Refer to the exhibit. An administrator attempts to recover a corrupted standalone mongod instance using the --repair flag. Based on the error log output, what is the most appropriate next step for the administrator?

Which cursor method should you use to sort documents by a field named 'age' in descending order?

How does the 'Replica Set' architecture influence client application design?

A DBA is adding a new secondary to an existing replica set. The data set is 2 TB, and the network bandwidth between the new member and the primary is 100 Mbps. The DBA wants to minimize the impact on the primary during the initial sync. Which approach should the DBA take?

Why does MongoDB choose the BSON format over JSON for storage?

A MongoDB 6.0 sharded cluster uses a shard key of { region: 1, customerId: 1 } for a global order collection. Most queries filter on customerId only, without region. The operations team observes that nearly every read is a scatter-gather across all shards. What is the most accurate explanation for this behavior?

A development team is building a real-time analytics dashboard that reads from a MongoDB replica set. The dashboard can tolerate slightly stale data but must never show data that could be rolled back. The team also wants to minimize read latency. Which read concern should they use?

A DBA is troubleshooting a replica set where the secondary is consistently lagging behind the primary by several hours. The DBA notices that the secondary's optime is far behind the primary's optime, and the secondary's oplog window is only 1 hour. The primary has a heavy write workload. Which action should the DBA take to reduce the replication lag and prevent the secondary from falling off the oplog?

An administrator notices that the MongoDB balancer is actively migrating chunks during peak business hours, causing noticeable application latency spikes. What is the standard administrative approach to mitigate this performance impact?

A development team is building a mobile application backend using MongoDB. They want to ensure that the application can handle rapid changes to the data model without requiring database downtime or complex migrations. Which MongoDB feature directly supports this requirement?

An administrator needs to create a restricted user for a third-party monitoring tool. The user must be able to perform backups and monitor server status but cannot read actual document data. Which TWO built-in roles should be combined?

Which design principle explains why MongoDB uses a document-oriented model instead of a rigid tabular schema?

You are the DBA for a three-member MongoDB replica set. The primary becomes unreachable due to a network partition, and two secondaries remain in communication. After the election timeout, one secondary is elected primary. What is the required condition for a new primary to be elected?

During routine cluster maintenance, an administrator needs to remove an underperforming shard from a production MongoDB sharded cluster safely. What is the mandatory first step the administrator must execute?

A financial application must ensure that once a transaction is committed, the data will never be rolled back, even if the primary node crashes immediately after the write is acknowledged. Which write concern should be used?

Which TWO of the following are essential for maintaining performance in a sharded cluster?

Which design principle should guide the decision between embedding and referencing?

When designing an application, what is the best practice for handling connection pools?

A MongoDB 6.0 replica set has a collection called orders with the default read concern. Users occasionally see an order document that still shows status "pending" even though a separate application thread just updated it to "shipped" and received an acknowledgment. The update used default write concern and targeted a single document by _id. Which read concern should you set on the read operation to guarantee the read returns data acknowledged by a majority of replica set members?

A financial services company is evaluating MongoDB for a new application that requires strong consistency for critical transactions and high availability across multiple data centers. The team must choose features that align with MongoDB's philosophy of balancing consistency, availability, and partition tolerance. (Choose two.)

An application frequently queries a large collection using two fields: 'category' (equality) and 'timestamp' (range). Which index strategy provides the most efficient execution plan?

An application issues a find query against a sharded collection without including the shard key in the query filter. How does the mongos query router handle this operation?

Which capability of MongoDB's document model most significantly distinguishes it from key-value stores?

Refer to the exhibit. An administrator attempts to execute the shardCollection command but receives the displayed error message. What is the root cause of this failure?

A sharded cluster experiences poor query performance because a targeted query targeting a specific shard key still results in a scatter-gather operation across all shards. What is the root cause?

Why should you avoid creating too many indexes on a single collection?

A financial services team is designing a real-time fraud detection system. They need a database that can store alerts with flexible, evolving fields such as device fingerprint, geolocation, and transaction metadata, and that can scale horizontally across many nodes. Which MongoDB philosophy best supports this requirement?

An application serves users in Europe and North America. The DBA wants to ensure that European user data stays on shards located in Europe to comply with data residency laws. Which feature should be used?

Which update operator would you use to increase the value of a numeric field by a specific amount?

When adding a new node to an existing replica set, what is the primary factor that determines how quickly the new member will be able to begin participating in elections?

Which connection string parameter should be used to ensure that an application only reads data from nodes that are considered current and consistent?

You are a DBA for a MongoDB replica set. A developer asks you to explain what the oplog is and why it is important. What is the correct description?

A DBA is reviewing a query that performs a sort on a field named score in descending order. The collection has an index { score: 1 }. The query also includes a filter on a field named active with an equality condition. The DBA observes that the query planner chooses a collection scan and performs an in-memory sort. Which index would allow the query to use an index for both the filter and the sort?

Which property of a field makes it a poor candidate for an index?

Refer to the exhibit. What is the primary benefit of the data structure shown?

Refer to the exhibit. A developer attempts to run a query using both 'tags' and 'location' in a single $and operation. What is the expected behavior regarding index usage?

A MongoDB DBA is investigating replication lag on a secondary member named rs0-2. The DBA runs rs.status() and notices that the 'optimeDate' of rs0-2 is several hours behind the primary's 'optimeDate'. The DBA wants to quickly determine the exact time difference. Which field in the rs.status() output should the DBA compare to calculate the replication lag?

A MongoDB 6.0 replica set is experiencing performance issues during peak hours. The DBA notices that the primary is spending significant time on disk I/O. The DBA wants to identify which collections are generating the most disk reads and writes. Which administrative command should the DBA use?

An application requires high write throughput for time-series data indexed by a timestamp field. You observe that all incoming data is being routed to a single shard, creating a write hotspot. Which shard key strategy best resolves this performance bottleneck?

A social media platform uses MongoDB to store user posts. Each post document contains an array of comments. The platform's engineers notice that some posts have tens of thousands of comments, causing documents to approach the 16 MB size limit and degrading read performance. They want to redesign the schema to handle this growth while preserving the ability to retrieve a post with its most recent comments efficiently. Which approach best aligns with MongoDB's schema design philosophy?

A MongoDB sharded cluster has a collection with a hashed shard key on the field 'userId'. A query is executed that includes an equality condition on userId. How does mongos route this query?

Which THREE of the following are core pillars of the MongoDB architecture?

A company stores IoT sensor data with a high ingestion rate. They use a monotonically increasing timestamp as the shard key. What is the most likely performance bottleneck for this cluster?

A database administrator is setting up a new sharded cluster and needs to enable sharding on a database named 'sales' before sharding any collections. Which command should be executed on mongos to enable sharding for this database?

A financial services firm is migrating its reporting application from a relational database to MongoDB. The lead architect argues that MongoDB's schema-less design will eliminate the need for data modeling. Which statement best describes MongoDB's philosophy regarding schema design?

What is the purpose of the 'write concern' in MongoDB?

A DBA needs to optimize a query that filters on a field with high cardinality, such as email, and also sorts on a low cardinality field, such as country. The query is { email: "user@example.com" } with sort { country: 1 }. Which index would best support this query?

Which read concern provides the strongest consistency guarantee by ensuring the data returned has been acknowledged by a majority of the replica set?

Which TWO of the following are benefits of the MongoDB 'document' model over the traditional 'relational' model?

In a three-node replica set with default write concern w:1, what happens to an unacknowledged write if the primary crashes immediately after receiving the write command but before replicating it to secondaries?

You need to remove a single document from the `users` collection where the `email` field is "alice@example.com". The collection has a unique index on `email`. Which method should you use?

A financial services company shards a transactions collection using a ranged shard key on an incrementing timestamp field. Over several months, the cluster develops a single hot shard that receives almost all writes, while the other shards remain nearly idle. Which change best addresses the root cause while preserving efficient range queries on timestamp?

Which configuration file setting is used to specify the network interface and port that a mongod instance listens on?

An application frequently queries a large collection by 'user_id' and 'status', sorting the results by 'timestamp'. Which index provides the most efficient execution plan?

Which method should you use to update multiple documents in a collection and insert a new document if no matches are found?

Which read preference allows the application to read from the closest member of the replica set to minimize network latency?

When performing a findOne operation, what does MongoDB return if no document matches the query criteria?

You are administering a MongoDB 6.0 replica set with three members: a primary and two secondaries. You need to perform a rolling maintenance on the secondaries, which involves restarting each secondary one at a time. Which two actions must you take to ensure that the replica set remains available for writes during the maintenance? (Choose two.)

What is the purpose of the 'OpLog' in a MongoDB Replica Set?

Which member type in a MongoDB replica set is best suited for a geographically distant data center to provide read-only access without influencing elections?

A healthcare analytics team stores patient records in MongoDB. Each record includes a nested array of vital sign readings, and the team frequently queries for patients whose latest blood pressure reading exceeds a threshold. They decide to store each reading as a separate document in a readings collection and reference the patient. Which MongoDB design philosophy does this decision contradict?

What is the consequence of having a replica set with only two nodes and no arbiter?

A MongoDB replica set has three members: a primary and two secondaries. The DBA needs to perform maintenance on the primary node without causing an election that could lead to data loss. The maintenance requires stopping the mongod process for 30 minutes. Which step should the DBA take first to ensure the primary steps down gracefully and a secondary takes over?

Which operator would you use to remove an element from an array field in a document?

A MongoDB DBA observes that a query with filter { status: "active", created_at: { $gte: ISODate("2024-01-01") } } and sort { created_at: -1 } is performing a collection scan. The collection has an index { status: 1, created_at: -1 }. Which of the following best explains why the index is not being used efficiently?

Refer to the exhibit. What is the primary function of the node with _id 2 in this replica set?

Refer to the exhibit. Which MongoDB philosophy is represented by this document structure?

Which THREE components are mandatory architectural parts of every fully functioning MongoDB sharded cluster deployment? Choose 3 answers.

A MongoDB DBA is managing a sharded cluster where the collection 'orders' is sharded on the field 'orderDate' using ranged sharding. The DBA needs to add a new shard to the cluster to handle increasing data volume. After adding the shard, the balancer begins migrating chunks. During this migration, the DBA runs a query that includes 'orderDate' and notices increased latency. What is the most likely reason for the increased latency?

A global e-commerce platform uses MongoDB with a replica set spanning three data centers. The company wants to ensure that a write is acknowledged by a majority of voting members before it is considered successful, even if one data center experiences a network partition. Which write concern should be configured to meet this requirement?

Which feature of MongoDB allows it to maintain data consistency during primary node failure?

Which THREE factors can significantly impact the time taken for a new primary election?