Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

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

Demo: 19 questions
Total 132 questions

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

Question 1

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

Options:

A.

When the many is not very large

B.

When the many is very large

C.

Always

D.

Never

Question 2

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

Options:

A.

mongoexport

B.

mongostat

C.

mongoimport

D.

mongodump

Question 3

Which of the following is true about sharding?

Options:

A.

Creating a sharded key automatically creates an index on the collection using that key

B.

We cannot change a shard key directly/automatically once it is set up

C.

A sharded environment does not support sorting functionality since the documents lie on various mongod instances

D.

Sharding is enabled at the database level

Question 4

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:

A.

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

B.

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

C.

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

Question 5

Which of the following are common uses of the mongo shell? Check all that apply

Options:

A.

Perform queries against MongoDB collections

B.

Perform administrative tasks

C.

Use as a JavaScript framework for your production system

Question 6

JSON stands for

Options:

A.

JavaScript Object Notation

B.

JavaScript Object Naming

C.

JavaScript Object Notice

D.

None of the above

Question 7

Mongodb does provide high availability via which option?

Options:

A.

Replication

B.

Indexing

C.

Sharding

D.

Journaling

Question 8

Consider a collection posts which has fields: Jd, post_text, post_author, post_timestamp, post_tags etc. Which of the following query retrieves ONLY the key named post_text from the first document retrieved?

Options:

A.

db.posts.finOne({},{_id:0, post_text:1})

B.

db.posts.findOne({post_text: 1})

C.

db.posts.find({},{_id:Of post_text:1})

D.

db.posts.finOneĀ«},{post_text:l})

Question 9

What is the output of the following program?

Options:

A.

60 s

B.

1s

C.

100 s

D.

100 ms

Question 10

Which of the following command is used to get all the indexes on a collection?

Options:

A.

db.collection.showIndexes()

B.

db.collection.findlndexes()

C.

db.showIndexes()

D.

db.collection.getlndexesQ

Question 11

Which option should be used to update all the documents with the specified condition in the MongoDB query?

Options:

A.

specify {all: true} as the third parameter of update command

B.

updateAII instead of update

C.

specify {updateAII: true} as the third parameter of update command

D.

specify {multi : true} as the third parameter of update command

Question 12

Which is the correct order (lowest to highest) in which MongoDB compares the BSON types?

Options:

A.

Number, Null, String and Object

B.

Null, Number, Object and String

C.

Null, Number, String and Object

D.

String, Null, Number and Object

Question 13

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

Options:

A.

findQ returns all the documents in a collection while findOne() retrieves only the first one.

B.

find.limit(l) is not the same query as findOne()

C.

findOneQ returns the actual first document retrieved from a collection

D.

findQ and findOneQ returns cursors to the collection documents

Question 14

You are comparing values of different BSON types in mongodb. You want to compare from lowest to highest. Which comparison order is used?

Options:

A.

MinKey, Null, Numbers,Symbol, String,Object,Array,BinData

B.

MinKey, Null, Numbers,Object,Array,BinData,Symbol, String

C.

Object/Array^inData/Symbol,MinKey, Null, Numbers,String

D.

Objec^Array^inData,Symbol, String,MinKey, Null, Numbers

Question 15

What is the defau size of a GridFS chunk?

Options:

A.

255 K

B.

1 MB

C.

16 MB

D.

2 MB

Question 16

Consider the following documents:

You perform the following query;

How many documents will be updated by the query?

Options:

A.

0

B.

1

C.

2

D.

3

E.

5

Question 17

Below is a sample document in a given collection test.

{ a : 5, b : 3, c: 2, d : 1 >

Given a compound index { a: 1, b:l, c:l, d:l}, Which of the below query will not use in-memory sorting? Select

all valid.

Options:

A.

db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )

B.

db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )

C.

db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )

D.

db.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )

Question 18

Aggregation Pipelines have a limit of:

Options:

A.

No limit on document and 100 MB RAM

B.

2 MB document and no limit on RAM

C.

2 MB document and 100 MB RAM

D.

16 MB document and 100 MB RAM

Question 19

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:

A.

1

B.

2

C.

0

D.

7

Demo: 19 questions
Total 132 questions