75only - Ends in 0d 00h 00m 00s - Coupon code = 75only

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

Exam C100DBA Premium Access

View all detail and faqs for the C100DBA exam

Go to Exam
Practice at least 50% of the questions to maximize your chances of passing.
Viewing page 4 out of 6 pages
Viewing questions 31-40 out of questions
Questions # 31:

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 > > );

Questions # 32:

In a replica set, a_________number of members ensures that the replica set is always able to select a primary.

Options:

A.

Even

B.

Odd

C.

2

D.

Depends on the application architecture

Questions # 33:

Which of the following is a valid insert statement in mongodb? Select all valid.

Options:

A.

db.test.push({x:2,y: " apple " })

B.

db.test.insert« " x " :2, " y " : " apple " })

C.

db.test.insert({x:2,y: " apple " })

D.

db.test.insert({x:2},{y: " apple " })

Questions # 34:

What attribute of the oplog ensures consistency in a replicated dataset?

Options:

A.

Natural Ordering

B.

Concurrency Control

C.

Flow Control

D.

Idempotent

Questions # 35:

Consider that you have a collection called population which has fields state and city. Which of the following query will calculate the population grouped by state and city?

Options:

A.

db.population.aggregate( [{ $group: { _id: { state: " $state " , city; " $city " },pop: { $sum: 1 > > > ] )

B.

db.population.aggregate( [{ $group: { _id: { state: Estate " , city: " $city " },pop: { $pop: 1 } } }] )

C.

db.population.aggregate( [{ $group: { _id: { state: Estate " , city: n$city " },pop: { $sum: " $pop " } } }] )

D.

db.population.aggregate( [{ $group: { _id: { city: " $city " },pop: { $sum: " $pop " } } }] )Multi Document Transaction is not supported by MongoDB

Questions # 36:

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

Questions # 37:

You perform the following query on the sayings collection, which has the index

{ quote : " text " }:

Assuming the documents below are in the collection, which ones will the following query return? Check all that

apply.

db.sayings.find( { $text : { $search : " fact find " } } )

Options:

A.

{ _id : 3, quote : " Nobody will ever catch me. " }

B.

{ _id : 1, quote : " That ' s a fact, Jack. " }

C.

{ _id : 2, quote : " Find out if that fact is correct. " }

Questions # 38:

What is the output of following two commands in MongoDB: db. posts. insert({n_id " :l}) db.posts.insert({ " _id " :l})

Options:

A.

Two documents will be inserted with _id as 1

B.

MongoDB will automatically increment the _id of the second document as 2

C.

This will throw a duplicate key error

D.

It will insert two documents and throw a warning to the user

Questions # 39:

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/} } )

Questions # 40:

You are in a sharded cluster. What will you do prior to initiating backup in sharded cluster?

Options:

A.

db.stopBalancer()

B.

db.stopserver()

C.

sh.stopBalancer()

D.

sh.stopserverQ

Viewing page 4 out of 6 pages
Viewing questions 31-40 out of questions