C100DEV Practice Test 4 — 10 Questions

Question 1

A developer is working with a MongoDB collection that stores product data. The collection has documents with a field 'price' that is sometimes stored as a double and sometimes as a string, due to inconsistent data entry. A query is run to find all products with a price greater than 100. What is the expected behavior of this query?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

The query will return only documents where 'price' is a double greater than 100.. MongoDB uses type bracketing for comparison operators: only values of the same BSON type as the operand are considered. Since 100 is a double, only double prices greater than 100 are returned. Strings are not converted, and no error occurs. This underscores the importance of consistent data types in a collection.

Answer

The query will return an error because of the mixed data types in the 'price' field.

Answer

The query will return documents where 'price' is a string greater than '100' lexicographically, as well as doubles greater than 100.

Answer

The query will return all documents where 'price' is greater than 100, regardless of whether it is a double or string.

Question 2

An application stores customer profiles in a MongoDB collection. A developer notices that documents created by different services have inconsistent shapes: some use a string for phone, others an array of strings, and some omit the field entirely. The team wants to enforce a consistent structure for new writes while still allowing existing documents to remain. Which MongoDB feature should they use?

Accepted Answer

A JSON Schema validator attached to the collection with the $jsonSchema operator and validationLevel set to strict.. MongoDB supports schema validation through the $jsonSchema operator, configured on a collection with collMod. Setting validationLevel to strict applies the rules to all inserts and updates, so new writes must match the declared structure. Existing documents that are not modified remain untouched, which satisfies the requirement to leave current data as is while enforcing consistency going forward.

Answer

A unique index on the phone field, which forces every document to use the same BSON type for that field.

Answer

A partial index with a filter expression that excludes documents lacking the phone field.

Answer

A change stream that watches the collection and rejects documents whose shape differs from a template.

Question 3

An application using the MongoDB Node.js driver must ensure that a multi-document transaction is retried correctly when it encounters a transient error. Which two practices are required? (Choose two.)

Accepted Answer

On a commit error with the UnknownTransactionCommitResult label, retry the commit operation.. The Node.js driver exposes error labels that tell the application how to recover. A TransientTransactionError requires restarting the entire transaction, while UnknownTransactionCommitResult requires retrying the commit. These two behaviors are the documented retry pattern for multi-document transactions. Other options either misplace read concern, misunderstand the lifetime limit or weaken durability without addressing retries.

Answer

Increase the transaction lifetime limit beyond 60 seconds to avoid all retries.

Answer

Set the readConcern to 'snapshot' on every individual operation inside the transaction.

Answer

Disable write concern to make commits faster and reduce retries.

Question 4

A development team is modeling a MongoDB collection for a ticketing system. Each ticket has a unique ticketId, a status, and a variable set of custom fields that differ by department. The team wants to ensure that queries on ticketId and status can use indexes efficiently and that the custom fields remain flexible. Which statement best describes how the document model supports this requirement?

Accepted Answer

Documents in the same collection can have different fields, and indexes on ticketId and status can be created regardless of the custom fields present.. The document model allows each ticket to have its own shape while sharing common fields. Indexes are created on specific fields such as ticketId and status, and they work even when documents contain additional custom fields. This gives the team efficient lookups on the common fields and the flexibility to store department-specific data without schema migrations.

Answer

MongoDB enforces a collection-level schema, so the team must define all custom fields in a validator before inserting tickets.

Answer

Custom fields must be stored in a separate collection because MongoDB does not allow arrays or subdocuments in the same collection as scalar fields.

Answer

Indexes in MongoDB are created on collections, not fields, so the team cannot index ticketId and status without also indexing all custom fields.

Question 5

A developer needs to create an Atlas Search index that supports autocomplete on a `name` field. Which Atlas Search index definition is required?

Accepted Answer

An index with a field of type 'autocomplete' and an analyzer such as 'lucene.standard' or a custom edge-gram analyzer.. Atlas Search uses the `autocomplete` field type to support prefix suggestions. The field must be configured with an analyzer that produces edge-grams or n-grams, such as a custom analyzer using the edgeGram tokenizer. Standard string or text indexes do not provide this behavior. Wildcard indexes are unrelated to Atlas Search and cannot satisfy the autocomplete requirement.

Answer

A text index with the default language analyzer.

Answer

A standard string index with dynamic mapping enabled.

Answer

A wildcard index on the `name` field.

Question 6

A developer needs to quickly inspect the contents of a collection and run ad-hoc queries against a MongoDB Atlas cluster without installing any additional software. Which tool should be used?

Accepted Answer

Atlas Data Explorer. Atlas Data Explorer is a web-based interface integrated into MongoDB Atlas that lets users view and query data without installing any software. It is the most convenient tool for quick inspection and ad-hoc queries, as it is accessible directly from the Atlas UI and requires no local setup.

Answer

MongoDB Database Tools

Answer

MongoDB Compass

Answer

mongosh

Question 7

A financial application stores transaction records in a MongoDB collection. Each transaction document includes a Decimal128 amount field and a Date field for the transaction time. A developer needs to query for transactions with amounts greater than 100.00 and times within the last 24 hours, and wants the queries to use indexes efficiently. Which statement about the document model and BSON types is correct for this scenario?

Accepted Answer

Date values are stored as 64-bit integers representing milliseconds since the Unix epoch, and they can be indexed and compared with range operators.. BSON Date is stored as a 64-bit integer of milliseconds since the Unix epoch, which makes it directly comparable and indexable for range queries. Decimal128 is a separate numeric type that also supports range comparisons and indexing. Together, they allow the application to filter by amount and time efficiently using appropriate indexes, without converting values to strings or avoiding range queries.

Answer

Range queries on Decimal128 fields are not supported; only equality queries can use an index on a Decimal128 field.

Answer

Decimal128 values are stored as strings, so range queries on the amount field require a text index rather than a numeric index.

Answer

Because Decimal128 and Date are both binary types, they cannot be used together in a compound index on the same collection.

Question 8

A developer is designing a MongoDB collection to store sensor readings. Each reading document contains a sensorId, a timestamp, and a readings array of subdocuments with type and value fields. The application frequently queries for readings where the readings array contains a subdocument with type "temperature" and value greater than 30. Which document model feature allows the query to match elements within the array efficiently?

Accepted Answer

Multikey indexes, which are created automatically when an index is built on a field that contains an array, allow the query to match individual array elements.. A multikey index is created when an index is built on a field containing an array. MongoDB generates an index entry for each array element, so queries that filter on subdocument fields within the array can use the index. This allows the sensor reading query to match temperature readings above 30 efficiently, as long as an appropriate index exists on the readings field.

Answer

The _id index, which is created on every collection, includes all array elements and can be used to match subdocument fields.

Answer

Capped collections, which store documents in insertion order, automatically index array elements for fast lookups.

Answer

Array flattening, which merges all subdocuments into a single document, allows the query to treat the readings array as a flat set of fields.

Question 9

A developer needs to load a large JSON file into a collection named 'inventory' in the 'retail' database on a MongoDB server running on localhost. The file contains one JSON document per line. Which command-line tool should be used?

Accepted Answer

mongoimport --db retail --collection inventory --file inventory.json. The correct tool is mongoimport, which is part of the MongoDB Database Tools and specifically built to import data from JSON, CSV, or TSV files into a collection. The other tools serve different purposes: mongorestore restores BSON dumps, mongoexport exports data, and mongofiles manages GridFS files. Only mongoimport matches the requirement of loading a JSON file into a collection.

Answer

mongofiles --db retail --collection inventory --file inventory.json

Answer

mongoexport --db retail --collection inventory --file inventory.json

Answer

mongorestore --db retail --collection inventory inventory.json

Question 10

You are the lead developer for a high-traffic e-commerce application using MongoDB 6.0. A query on the `orders` collection that filters on `customerId` and sorts by `orderDate` in descending order is performing poorly. You decide to create an index to improve its performance. Which of the following indexes would be most efficient for this query?

Accepted Answer

db.orders.createIndex({ customerId: 1, orderDate: -1 }). The most efficient index for a query with an equality filter and a sort is one that follows the Equality, Sort, Range (ESR) rule: equality fields first, then sort fields. The index must also match the sort direction. Here, the query filters on `customerId` (equality) and sorts by `orderDate` descending. Therefore, an index on `{ customerId: 1, orderDate: -1 }` allows MongoDB to use the index for both filtering and sorting, avoiding an expensive in-memory sort and ensuring optimal performance.

Answer

db.orders.createIndex({ customerId: 1, orderDate: 1 })

Answer

db.orders.createIndex({ orderDate: -1, customerId: 1 })

Answer

db.orders.createIndex({ orderDate: 1, customerId: 1 })