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

Viewing page 4 out of 4 pages
Viewing questions 31-40 out of questions
Questions # 31:

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


Expert Solution
Questions # 32:

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

Options:

A.

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


B.

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


C.

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


D.

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


Expert Solution
Questions # 33:

Which of the following aggregation commands in MongoDB does not support sharded collections?

Options:

A.

mapReduce


B.

group


C.

aggregate


D.

All of the above


Expert Solution
Questions # 34:

Which of the following is true about aggregation framework?

Options:

A.

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


B.

the aggregate command operates on a multiple collection


C.

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


D.

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


Expert Solution
Questions # 35:

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 # 35

Options:

A.

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


B.

db.posts.createIndex({comments.$.author": {$desc:l>});


C.

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


Expert Solution
Questions # 36:

What is the maximum size of a MongoDB document?

Options:

A.

2 MB


B.

12 MB


C.

There is no maximum size. It depends on the RAM.


D.

16 MB


Expert Solution
Questions # 37:

‘$set' sets the value of

Options:

A.

Code block


B.

Name/value pair


C.

Key


D.

None of the above


Expert Solution
Questions # 38:

In a collection that contains 100 post documents, what does the following command do? db. posts. find().skip(5).limit(5)

Options:

A.

Skip and limit nullify each other. Hence returning the first five documents.


B.

Skips the first five documents and returns the next five


C.

Limits the first five documents and then return them in reverse order


D.

Skips the first five documents and returns the sixth document five times


Expert Solution
Questions # 39:

Which of the following is correct about MongoDB?

Options:

A.

MongoDB supports geospatial indexes


B.

MongoDB supports some of the SQL functions


C.

MongoDB uses JSON format to represent documents


D.

MongoDB supports collection joins


Expert Solution
Viewing page 4 out of 4 pages
Viewing questions 31-40 out of questions