MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) (C100DBA) Practice Test

Questions # 21:

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

Options:

Column and Row

Table and Row

Database and Table

Table and Column

Questions # 22:

Which of the following operator can be used to control the number of items of an array that a query returns?

Options:

$ elemMatch

$slice

MongoDB does not support partial retrieval of items from an array

Questions # 23:

What is the replication factor for a replicated cluster with 1 primary, 3 secondaries with one of them hidden. The set also has an arbiter?

Options:

None of the above

Questions # 24:

Which of the following aggregate commands in MongoDB uses a pipeline approach with the goals of improving the aggregation performance?

Options:

mapReduce

group

aggregate

All of the above

Questions # 25:

You have the following index on the toys collection:

{

"manufacturer" : 1,

"name" : 1,

"date" : -1

}

Which of the following is able to use the index for the query? Check all that apply.

Options:

db.toys.find( { name : "Big Rig Truck", date : "2013-02-01", manufacturer : "Tanko"

db.toys.find( { manufacturer : "Matteo", name : "Barbara", date : "2014-07-02" } )

db.toys.find( { date : "2015-03-01", manufacturer : "Loggo", name : "Brick Set" } )

Questions # 26:

As per the aggregation pipeline optimization concepts, if you have a $sort followed by a $match:

Options:

Providing these parameters in any order does not impact the performance

$sort moves before $match

MongoDB does not do any movements by default and will use the order provided

$match moves before $sort

Questions # 27:

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

Options:

mongorestore

mongostat

mongodump

mongotop

Questions # 28:

Which of the following is true about aggregation framework?

Options:

Each aggregation operator need to return atleast one of more documents as a result

the aggregate command operates on a multiple collection

A single aggregation framework operator can be used more than once in a query

Pipeline expressions are stateless except accumulator expressions used with $group operator

Questions # 29:

Write the command(s) are correct to enable sharding on a database "testdb" and shard a collection "testCollection" with _id as shard key.

Question # 29

Options:

Questions # 30:

The oplog (operations log) is a special capped collection that keeps a rolling record of all operations that modify the data stored in your databases. All the replica set members contain a copy of the oplog in the following collection:

Options:

oplog.rs

..oplog.rs

.oplog.rs

local.oplog.rs

Viewing page 3 out of 4 pages

Viewing questions 21-30 out of questions

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the MongoDB Certified DBA Associate C100DBA Questions and answers with ExamsMirror

Exam C100DBA Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES