Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
MongoDB
MongoDB Certified DBA Associate
C100DBA
MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) Questions and Answers

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

Practice at least 50% of the questions to maximize your chances of passing.

Exam C100DBA Premium Access

View all detail and faqs for the C100DBA exam

Go to Exam

522 Students Passed

96% Average Score

91% Same Questions

Viewing page 1 out of 4 pages

Viewing questions 1-10 out of questions

Questions # 1:

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?

Question # 1

Options:

db.posts.createIndex({^comments.$.author":-l});

db. posts.createIndex({^comments.author" :1});

db.posts.createIndex({^commerits.author";-!});

Answer

Questions # 2:

What does the totalKeysExamined field returned by the explain method indicate?

Options:

Number of documents that match the query condition

Number of index entries scanned

Details the completed execution of the winning plan as a tree of stages

Number of documents scanned

Answer

Questions # 3:

Which of the following commands will return all the posts with number of likes greater than 100 and less than 200, both inclusive?

Options:

db.posts.find({ likes : { $gte : 100 , $lte : 200 } } );

db.posts.find({ likes : { $gt : 100 , $lte : 200 } } );

db.posts.find({ likes : { $gte : 100, $lt : 200 } } );

db.posts.find({ likes : { $gt : 100, $lt : 200 > > );

Answer

Questions # 4:

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

Options:

arbiter

primary

hidden

secondary

Answer

Questions # 5:

What does the following query do when performed on the posts collection? db.posts.update({_id:l},{Title:This is post with ID 1"})

Options:

Syntax error

Replaces the complete document with _id as 1 with the document specified in second parameter

Updates the Title of the post

Updating a document is possible only with $set

Answer

Questions # 6:

Which of the following statements are true about the $match pipeline operator? Check all that apply.

Options:

You should use it early as possible in the pipeline

It can be used as many time as needed.

It has a sintax similar to findQ commands.

Answer

A, B, C

Questions # 7:

In a sharded replica set environment, the w Option provides ability for write concern and j Option provides ability for the data to be written on disk journal. Consider that we have a seven member replica set and we want to assure that the writes are committed to journal. What should be the value of j?

Options:

Answer

Questions # 8:

Which command is used to determine storage capacity of specific database?

Options:

mongotop

dbstats

mongostat

constats

Answer

Questions # 9:

Consider the following document from the products collection:

Question # 9

What does the following query using $elemMatch return? db.products.find( { product_code: "345678" }, { variations: { $elemMatch: { size: ^L^ } } } )

Options:

Returns the complete document but retrieves only the size field from the array

Returns the document but with only one element in the variations array (corresponding to size L)

Returns the complete document since MongoDB does not support partial array retrieval

Returns the complete document but retrieves only the size field from the array and also with only one element in the variations array (corresponding to size L)

Answer

Questions # 10:

Which option can be used with update command so that a new document gets created if no matching document is found based on the query condition?