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

Viewing page 1 out of 4 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

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

Options:

A.

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


B.

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


C.

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


D.

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


Expert Solution
Questions # 2:

Which operations add new documents to a collection?

Options:

A.

Create


B.

update


C.

insert


D.

delete


Expert Solution
Questions # 3:

Which of the following index would be optimum for the query?

Select all valid. db.test.find( { a : 5, c : 2 })

Options:

A.

db.test.ensurelndex( { c:l, a: 1})


B.

db.test.ensurelndex( { a : 1, c: 1, d: 1, b : 1})


C.

CH db.test.ensurelndex( { a :1, c:l})


D.

db.test.ensurelndex( { a: 1, b :1, c:l, d:l})


Expert Solution
Questions # 4:

In what format does mongodump creates backup files?

Options:

A.

BSON


B.

JSON


C.

SOAP


D.

XML


Expert Solution
Questions # 5:

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

Options:

A.

allPlansExecution


B.

customExecutionStats


C.

queryPlanner


D.

executionStats


Expert Solution
Questions # 6:

What is the maximum size of Index Key Limit and Number of Indexes per collection?

Options:

A.

1024 bytes and 64 indexes


B.

12 mega bytes and 64 indexes


C.

64 bytes and 1024 indexes


D.

1024 bytes and unlimited indexes


Expert Solution
Questions # 7:

Consider the following documents:

Question # 7

You perform the following query;

Question # 7

How many documents will be updated by the query?

Options:

A.

0


B.

1


C.

2


D.

3


E.

5


Expert Solution
Questions # 8:

The following aggregation option is used to specify the specific fields that needs to be passed to the next stage of the aggregation pipeline:

Options:

A.

$project


B.

$aggregate


C.

$match


D.

$group


Expert Solution
Questions # 9:

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

Options:

A.

executionStats


B.

queryPlanner


C.

customExecutionStats


D.

allPlansExecution


Expert Solution
Questions # 10:

Which of the following is supported by MongoDB?

Options:

A.

Transaction Management


B.

ACID Transactions


C.

Journaling


D.

Relationships between Collections (Primary Key Foreign Key)


Expert Solution
Viewing page 1 out of 4 pages
Viewing questions 1-10 out of questions