C100DBA Philosophy and Features Practice Test 2 — 15 Questions

Question 1

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

Accepted Answer

Documents in a collection can have varying fields.. Schema-less means that MongoDB does not require an explicit definition of data structures before inserting data. This flexibility allows different documents in the same collection to have entirely different sets of fields. It is a fundamental feature that empowers developers to experiment and evolve their applications in real-time without the overhead of disruptive migrations, which is a significant advantage over traditional relational databases that require rigid DDL statements.

Answer

The database cannot store data if it doesn't have a template.

Answer

The database does not support data types for fields.

Answer

Indexes can only be created on fields that exist in all documents.

Question 2

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

Accepted Answer

Built-in support for complex, hierarchical data structures.. The document model excels in developer agility and data modeling flexibility. By grouping related data, it optimizes for common access patterns, which enhances read performance by reducing the need for joins. This approach aligns with modern programming paradigms where objects are the primary unit of development, allowing for faster iterations and easier maintenance compared to relational models that require complex schema changes and manual data normalization across multiple tables.

Answer

Requirement for strict normalization of all data.

Answer

Guaranteed consistency through mandatory schema migrations.

Answer

Automatic translation of SQL queries to BSON.

Question 3

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

Accepted Answer

It enables read distribution across multiple nodes.. Replica sets require the driver to be aware of the topology to perform automatic discovery and routing. Since a replica set has a primary node for writes and multiple secondaries for reads, the application must manage read preferences and connection strings correctly. Understanding this architecture is crucial for writing resilient applications that can handle failover events without losing connection or experiencing data consistency issues during node promotions.

Answer

Applications must manually hardcode all secondary IP addresses.

Answer

It mandates that all reads must be 'strong' consistency.

Answer

It forces the application to implement custom failover logic.

Question 4

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

Accepted Answer

Model data based on the application's read and write patterns.. The primary principle for data modeling in MongoDB is the 'access pattern.' You should model data to match how your application queries it. If data is almost always retrieved together, it should be embedded. If the data is accessed independently or is extremely large, it should be referenced. This ensures that the system remains performant by minimizing the number of disk reads and network round-trips required to serve requests.

Answer

Always embed to prevent any possibility of data duplication.

Answer

Always reference to keep the database size as small as possible.

Answer

Use embedding for all data to ensure ACID compliance.

Question 5

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

Accepted Answer

It provides a mechanism for asynchronous data replication.. The OpLog (Operations Log) is a capped collection that records all modifications to the data in the database. It is the core component that allows secondary nodes to replicate data from the primary node. By replaying the operations found in the OpLog, secondaries maintain an identical state to the primary. Understanding the OpLog is essential for diagnosing replication lag and ensuring the system is effectively synchronized across all nodes in the cluster.

Answer

It stores user credentials for database authentication.

Answer

It is used for storing index definitions and metadata.

Answer

It acts as a permanent, immutable backup of all data.

Question 6

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

Accepted Answer

Aligning data storage with object-oriented application models.. MongoDB utilizes a document model to align data structures with how applications represent objects, promoting developer productivity and flexibility. By allowing nested structures, developers avoid complex joins required in relational systems, which significantly improves read performance for related data. This philosophy enables schemas to evolve organically as application requirements change, supporting agile development cycles where modifying a table's structure across millions of rows would otherwise impose significant operational overhead or downtime.

Answer

Normalization of data to reduce storage footprints.

Answer

Strict enforcement of data types via ACID compliance.

Answer

Ensuring all related data is stored in separate collections.

Question 7

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

Accepted Answer

It allows MongoDB to skip fields without parsing them.. BSON (Binary JSON) is essential to MongoDB because it extends the JSON model by adding support for more data types like Date and BinData while optimizing for traversal. By encoding length prefixes into the binary format, MongoDB can quickly skip over fields without parsing the entire document. This design balance ensures that MongoDB maintains the human-readability benefits of JSON while achieving the performance characteristics necessary for high-throughput, enterprise-scale database operations.

Answer

It requires less storage space than raw JSON text.

Answer

It forces strict schema validation on all incoming data.

Answer

It provides native encryption for all document keys.

Question 8

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

Accepted Answer

Data locality for optimized retrieval patterns.. This document structure demonstrates the principle of embedding data. Instead of creating a separate collection for sensor readings and joining them via foreign keys, the readings are nested directly within the document. This approach minimizes the need for multi-table joins, which is a key tenet of MongoDB's design to keep data that is accessed together stored together, resulting in faster read performance and simplified application logic for time-series or hierarchical datasets.

Answer

Normalization for maximum data consistency.

Answer

Enforcement of a rigid schema using array types.

Answer

The use of an Oplog to track document changes.

Question 9

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

Accepted Answer

Automatic failover via replica set elections.. MongoDB uses replica sets to ensure high availability. When a primary node becomes unavailable, the remaining nodes in the replica set conduct an election to select a new primary. This process is governed by the consensus algorithm, ensuring that only a node with the most up-to-date data can become the new primary, thereby preventing data loss and maintaining the consistency of the cluster during automated failover scenarios.

Answer

Manual shard intervention by the administrator.

Answer

The use of a secondary index for read-only access.

Answer

The mongos router forcing a global write lock.

Question 10

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

Accepted Answer

Store data that is accessed together in the same document.. MongoDB's data modeling philosophy emphasizes placing data that is accessed together into the same document (embedding). It promotes flexibility by allowing schemas to be dynamic rather than rigid. Furthermore, it encourages developers to design schemas based on the application's specific query patterns, ensuring that the database layout directly supports the most frequent operations, which leads to optimal performance in high-scale environments where relational joins would otherwise create bottlenecks.

Answer

Normalize data to the third normal form.

Answer

Always prioritize write consistency over read performance.

Question 11

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

Accepted Answer

To manage data size limits and complex relationships.. Embedding is ideal for performance when data is accessed together, but referencing is necessary for handling unbounded data, complex relationships, or avoiding document size limits (16MB). By offering both, MongoDB provides the flexibility to choose the right strategy based on the specific cardinality and access frequency of the data, allowing developers to balance performance and storage constraints effectively without forcing a one-size-fits-all architectural approach.

Answer

To support legacy relational database imports.

Answer

To force developers to use ACID transactions.

Answer

To eliminate the need for indexes in the database.

Question 12

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

Accepted Answer

The ability to index and query nested document fields.. While key-value stores are limited to looking up data by a single key, MongoDB allows for deep inspection and querying of the document content. MongoDB indexes fields within the document, enables complex aggregation pipelines, and supports ad-hoc queries on any field. This versatility transforms the database from a simple lookup engine into a powerful analytical and transactional system, allowing it to handle diverse workloads that require rich data exploration and complex filtering.

Answer

The ability to store binary data as BSON.

Answer

The use of a primary key for document retrieval.

Answer

The support for horizontal scaling across clusters.

Question 13

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

Accepted Answer

It ensures the data is durable on a majority of nodes.. The 'w: majority' write concern ensures that a write operation is acknowledged only after it has been replicated to a majority of nodes in the replica set. This philosophy prioritizes data durability and consistency over the absolute lowest latency. By requiring a majority, MongoDB ensures that even if a primary node fails immediately after a write, the data persists on other nodes, minimizing the window for data loss during failover.

Answer

It guarantees that the write is applied to all shards.

Answer

It optimizes for the fastest possible write performance.

Answer

It forces an immediate sync to the storage disk.

Question 14

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

Accepted Answer

MongoDB prioritizes universal language and driver support.. The log entry indicates that MongoDB accepts standard TCP connections from client applications. This reflects the philosophy of providing a simple, standard-based interface for developers. By using standard socket-based communication, MongoDB allows drivers to be implemented in virtually any programming language, enabling widespread compatibility and easy integration into diverse application ecosystems without requiring custom protocols or proprietary communication middleware for database interaction.

Answer

MongoDB uses a proprietary, non-standard transport protocol.

Answer

All clients must be authenticated via a central service.

Answer

The database requires persistent, long-lived connections.

Question 15

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

Accepted Answer

To increase throughput by reducing write contention.. Early MongoDB versions used a global write lock, which hindered performance by serializing all write requests. Document-level concurrency control allows multiple clients to write to different documents in the same collection simultaneously. This is a critical architectural shift that enables high write throughput, as it drastically reduces contention and allows the database to fully utilize multi-core server architectures, directly supporting MongoDB's promise of high performance at scale.

Answer

To allow for faster reading of large binary objects.

Answer

To support atomic, multi-document transactions.

Answer

To provide automatic index creation in the background.