MongoDB C100DBA Exam Practice Test Instant Access

Question 1

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

See Below Explanation:

Answer : A

Question 2

The MongoDB explain() method does not support which of the following verbosity mode:

AexecutionStats

BqueryPlanner

CcustomExecutionStats

DallPlansExecution

Answer : A

Question 3

The MongoDB explain() method does not support which of the following verbosity mode:

AexecutionStats

BqueryPlanner

CcustomExecutionStats

DallPlansExecution

Answer : C

Question 4

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

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

Adb.posts.find( { author: /John/ } )

Bdb.posts.find( { author: /AjohnA/ > )

Cdb.posts.find( { $like: {author: /John/} } )

Ddb.posts.find( { author: {$like: /John/} } )

Answer : A

Question 5

Which of the following about Capped Collections is correct?

AFixed Size

BOnly 'Fixed Size' and 'High-throughput operations that insert and retrieve documents based on insertion order'

CHigh-throughput operations that insert and retrieve documents based on insertion order

DIf the allocated space for a capped collection exceeds, it stops inserting new documents

Answer : B

Question 6

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

AProviding these parameters in any order does not impact the performance

B$sort moves before $match

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

D$match moves before $sort

Answer : D

Question 7

What does the following $slice query return using the following command? db.posts.find( {}, { comments: { $slice: [ -10, 5 ] } } )

MongoDB C100DBA MongoDB Certified DBA Associate Exam Practice Test