C100DBA Practice Exam Questions with Answers MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) Certification

What is the equivalent command in MongoDB for the following SQL query?

SELECT * FROM posts WHERE author like "%john%"

Which features of relational database management systems were deliberately omitted in MongoDB and help us to obtain horizontal scalability? Check all that apply.

In a replicated cluster, which of the following node would only be used during an election?

Given a collection posts as shown below having a document array comments, which of the following command will create an index on the comment author descending?

Suposse tou have the following collection with only 2 documents:

If you run an aggregation query and use { $unwind: "$traits" } as the first stage, how many documents will be passed to the next stage of the aggregation pipeline?

Below is a sample document of "orders" collection

Given a replica set with five data-bearing members, suppose the primary goes down with operations in its oplog that have been copied from the primary to only one secondary. Assuming no other problems occur, which of the following describes what is most likely to happen?

Which of the following is correct about MongoDB?

The difference between $push and $addToSet is:

Which mongodb tool is used to report details on number of database operations in MongoDB?

A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?

JSON stands for

In a collection that contains 100 post documents, what does the following command do? db. posts. find().skip(5).limit(5)

What is the defau size of a GridFS chunk?

Which of the following is incorrect statement about find and findOne operations in MongoDB?

In mongodb how do you update a document partially?

In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?

What is the on-premise solution having functionality equivalent to cloud manager?

Which mongodb tools allow us to work with our data in a human readable format?

MongoDB is

Which of the following operator can be used to limit the number of documents in an array field of a document after an update is performed?

Which format/standard is used by MongoDB internally to store documents?

Consider that the posts collection contains an array called ratings which contains ratings given to the post by various users in the following format:

Which of the following query will return all the documents where the ratings array contains elements that in some combination satisfy the query conditions?

What tool do you use if you want to extract a CSV from mongo?

What is the maximum size of a MongoDB document?

When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?

Which of the following collections stores authentication credentials in MongoDB?

Update If Correct is an approach for which of the following concepts in MongoDB:

What is the first task that a secondary would perform on being prompted by another secondary for an election?

By default, the MongoDB cursor in mongo shell is configured to return how many documents? To get the next set of documents, which command is used?

What read preference should your application use if you want to read from the primary under normal circumstances but allow reads from secondaries when a primary is unavailable?

Which node in a replica set does accept write operation?

Which is the default mode in which the explain() command runs?

You perform the following query on the sayings collection, which has the index

{ quote : "text" }:

Assuming the documents below are in the collection, which ones will the following query return? Check all that

apply.

db.sayings.find( { $text : { $search : "fact find" } } )