Free practice · No sign-up required
15 questions with answer explanations. Choose an answer below to begin.
What is a primary function of a database administrator?
Understand core DBA responsibilities
0/15 answered · Bookmark questions to review later. Focus the practice area to use keys 1–9 and Enter.
Learn by doing
Use official documentation and hands-on labs to work through topics you missed.
Prefer to read at your own pace? Work through each question below, then open its answer to check your reasoning. You can link directly to a question or print this reference.
What is a primary function of a database administrator?
Ensuring data integrity and availability
Writing application user interfaces
Designing marketing strategies
Managing network hardware
Correct answer
Ensuring data integrity and availability
Database administrators focus on the reliability, integrity, and availability of data stores. The other roles belong to application developers, marketers, or network engineers.
Which data model does MongoDB use by default?
Document
Key-value
Graph
Column-family
Correct answer
Document
MongoDB stores data in flexible, JSON-like documents within collections. This document model allows for nested structures and dynamic schemas.
What does a replica set provide in MongoDB?
High availability and redundancy
Data compression
Query optimization
Schema enforcement
Correct answer
High availability and redundancy
A replica set maintains multiple copies of data across servers to ensure availability during outages and to enable failover. It does not inherently compress data or enforce schemas.
Which operation is typically used to add a single document to a collection?
insertOne
addOne
push
append
Correct answer
insertOne
In MongoDB, insertOne is the standard method to add one document to a collection. The other options are not native MongoDB operations for this purpose.
What is a common use case for indexing in a database?
Speeding up query performance
Reducing storage size
Encrypting sensitive fields
Enforcing user permissions
Correct answer
Speeding up query performance
Indexes improve query efficiency by allowing the database to locate documents without scanning every record. They do not reduce storage size or handle encryption directly.
Which statement about MongoDB schemas is true?
Documents in a collection can have different structures
All documents must have identical fields
Schema changes require downtime
Schema validation is disabled by default
Correct answer
Documents in a collection can have different structures
MongoDB is schema-flexible, so documents in the same collection can vary in field names and types. Schema validation can be enabled but is not required.
What is the purpose of a connection string in MongoDB?
To specify how to reach the database server
To define document structures
To store query results
To manage user roles
Correct answer
To specify how to reach the database server
A connection string contains network and authentication details so clients can locate and connect to a MongoDB deployment. It does not define schemas or store results.
Which tool is commonly used to interact with MongoDB from the command line?
mongosh
sqlplus
redis-cli
psql
Correct answer
mongosh
mongosh is the MongoDB Shell for running commands and queries. The other tools belong to different database systems.
What does the MongoDB deployment process typically involve?
Installing software and configuring replica sets
Compiling application code
Designing user interfaces
Generating reports
Correct answer
Installing software and configuring replica sets
Deployment includes installing MongoDB software, setting up replica sets for redundancy, and configuring network access. It does not involve compiling application code or UI design.
Which data format is natively supported by MongoDB for storage?
BSON
CSV
XML
YAML
Correct answer
BSON
MongoDB uses BSON (Binary JSON) to store documents, which supports additional data types beyond JSON. While CSV, XML, and YAML can be imported, they are not the native storage format.
What is a common method to ensure data durability in MongoDB?
Writing to the journal
Using read preferences
Increasing document size
Disabling indexes
Correct answer
Using read preferences
Data durability is achieved by writing operations to the journal before confirming writes. Read preferences control where reads occur, and they do not guarantee durability by themselves.
Which practice helps maintain database performance over time?
Regular monitoring and maintenance
Storing all data in a single document
Avoiding backups
Disabling authentication
Correct answer
Regular monitoring and maintenance
Ongoing monitoring, index management, and backups help sustain performance and reliability. The other options introduce security or data integrity risks.
What is a shard in a MongoDB cluster?
A partition of data across servers
A type of index
A user role
A backup file
Correct answer
A partition of data across servers
Sharding distributes data across multiple servers to support scalability. It is not an index type, user role, or backup artifact.
Which MongoDB feature supports automatic failover?
Replica sets
Collections
Views
Aggregations
Correct answer
Replica sets
Replica sets enable automatic failover by promoting a secondary node to primary if the current primary becomes unavailable. Collections, views, and aggregations do not provide failover.
What is a best practice for managing MongoDB users?
Grant least privilege access
Use the same user for all applications
Disable authentication in production
Share admin credentials widely
Correct answer
Grant least privilege access
Applying the principle of least privilege minimizes security risks. Sharing credentials or disabling authentication exposes the database to unauthorized access.
Recall the answer before opening each card.
Ensuring data integrity and availability. DBAs focus on reliability, integrity, and availability of data stores, not application development or networking.
MongoDB uses the document model, storing data in flexible, JSON-like documents within collections.
High availability and redundancy by maintaining multiple copies of data across servers, enabling automatic failover.
insertOne is the standard method to add one document. Other operations like insertMany are for multiple documents.
Speeding up query performance by allowing the database to locate documents without scanning every record.
No, MongoDB is schema-flexible; documents in a collection can have different structures. Schema validation is optional but can be enabled.
To specify how to reach the database server, including network addresses and authentication details for client connectivity.
mongosh, the MongoDB Shell, for running commands and queries. Other tools like mongo are older versions.
Installing MongoDB software, configuring replica sets for redundancy, and setting up network access. Application code compilation is not part of deployment.
BSON (Binary JSON), which supports additional data types beyond JSON, such as Date and Binary.
By writing operations to a journal before acknowledging writes, governed by write concern settings. Read preferences do not provide durability.
Regular monitoring and maintenance, including index management, slow query analysis, and backups, to sustain performance and reliability.
A partition of data across servers, used to distribute load for horizontal scaling. It is not an index, user role, or backup artifact.
Replica sets enable automatic failover by promoting a secondary node to primary if the current primary fails.
Grant least privilege access to minimize security risks. Avoid sharing credentials or disabling authentication.
Write concern specifies the level of acknowledgment required for a write, such as waiting for the primary alone or a majority of replica set members, ensuring data persistence.
If the primary becomes unavailable, the replica set holds an election and promotes a secondary to become the new primary, ensuring continued availability.
mongosh is the interactive JavaScript shell for MongoDB, used for administrative tasks, querying, and script execution.
Proper indexing improves query performance and reduces resource consumption. DBAs must monitor index usage and remove unused indexes to optimize storage and write speed.
Schema flexibility allows developers to change document structures without migration, but DBAs should enforce consistency through application logic or optional validation to prevent data irregularities.
Read the prompt, commit to an answer, then flip the card. Move through the deck at your own pace and repeat any topic that does not come back quickly.
Card 1 of 20
1 reviewed this session
Connect the concepts
Open a branch to connect a topic with its practice questions and explanations. Use the map to choose your next review topic.
This is an analysis of the practice bank, not a claim about the vendor's live exam blueprint. Use it to identify the knowledge, judgment, and recall patterns exercised here, then verify your coverage against the current official exam guide.
This section consolidates the core responsibilities of a database administrator—ensuring data integrity and availability—with MongoDB's underlying data model. The document model is the default, storing data in flexible, JSON-like documents within collections. MongoDB supports schema flexibility, meaning documents in the same collection can have varying fields and structures, though schema validation can be enforced when needed. The native storage format is BSON, a binary representation of JSON-like documents that supports additional data types. These fundamentals shape how a DBA designs databases, plans for data consistency, and leverages MongoDB's dynamic schema capabilities.
Replica sets are central to MongoDB's high-availability architecture. A replica set consists of multiple servers maintaining copies of the same data; it provides automatic failover by promoting a secondary node to primary if the current primary fails. This ensures continuous availability during outages. For scalability, sharding partitions data across multiple servers, distributing read and write loads. Deployment typically involves installing MongoDB software and configuring replica sets. Understanding these mechanisms is critical for a DBA tasked with designing resilient, scalable systems that handle growth and unexpected failures.
Performing write operations like insertOne to add documents is a basic DBA task. Indexes are essential for speeding up query performance by enabling efficient data retrieval without full collection scans. The mongosh shell is the primary command-line interface for administrative tasks and queries. Regular monitoring and maintenance—such as reviewing slow queries, optimizing indexes, and checking system resources—help sustain database performance over time. DBAs must be proficient with these operational practices to keep MongoDB deployments running smoothly and efficiently.
Connection strings specify how to reach a MongoDB deployment, including network addresses and authentication credentials. For data durability, MongoDB writes operations to a journal before confirming writes, governed by write concern settings. Read preferences, by themselves, do not guarantee durability; proper write concern and journaling are required. Security best practices include granting least privilege access to users—only the permissions necessary for their role—and avoiding shared credentials or disabled authentication. These measures protect the database from unauthorized access and data loss.
Study workflow
Download the MongoDB Community Server from the official website. Follow the installation instructions for your operating system. Start the mongod process, then connect using mongosh. Verify the instance is running by executing a simple command like 'db.version()'. This hands-on setup gives you direct experience with deployment, connection strings, and the shell.
Launch three mongod instances on different ports, each with a unique replica set name. Initialize the replica set using rs.initiate() in mongosh. Add the secondary members with rs.add(). Verify replication by inserting documents on the primary and checking the secondaries. Simulate a primary failure by stopping the primary process and observe automatic failover.
Create a collection with sample data. Use 'explain()' to analyze queries without indexes, then create indexes with createIndex(). Compare the execution time and number of documents scanned. Use the profiler by setting 'db.setProfilingLevel(1)' to capture slow operations. This exercise demonstrates how indexes drastically improve query performance.
Enable authentication by setting security.authorization to 'enabled' in the mongod configuration. Restart the instance. Create an admin user using db.createUser() with root privileges. Then create application users with limited roles (e.g., readWrite). Practice connecting with those users via connection strings to enforce least privilege.
Start a replica set. Insert documents with different write concern options (e.g., {w:1, j:true}, {w:'majority'}). Simulate a crash by killing the primary before the write is acknowledged. Observe whether the write survives failover. This demonstrates how write concern and journaling ensure data durability.
FAQ
Clear boundaries on what the bank covers, how to use it, and where official vendor information still matters.
A replica set provides high availability by maintaining identical copies of data on multiple servers, with automatic failover. A sharded cluster distributes different subsets of data (shards) across servers for horizontal scalability. Sharded clusters typically use replica sets for each shard to ensure redundancy within each data partition.
MongoDB ensures durability by writing operations to a journal before acknowledging the write. The write concern setting controls the level of acknowledgment required, such as waiting for the primary alone or a majority of replica set members. Enabling journaling (j: true) guarantees that the write is persisted even if the server crashes.
Schema flexibility allows MongoDB to store documents with varying fields in the same collection, making it easier to evolve the data model without downtime or migrations. For a DBA, this means less upfront schema design, but it also requires careful planning to ensure data consistency through application logic or optional schema validation.
A connection string specifies the hostnames, ports, and authentication credentials needed for a client to connect to a MongoDB deployment. It may also include replica set names and read/write preferences. The DBA provides connection strings to application developers, ensuring secure and reliable access to the database.
Apply the principle of least privilege: grant each user only the roles required for their tasks. Avoid using the root role for routine operations. Use role-based access control (RBAC) to assign predefined or custom roles. Regularly review user privileges and rotate credentials. Never disable authentication in production environments.
Browse another free bank or use the study strategy guide to turn your misses into spaced review.
