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

Questions # 31:

What is the first task that a secondary would perform on being prompted by another secondary for an election?

Options:

Start the election process for primary

Vote for the first secondary so that it would become the next primary

Vote for itself and then call for election

Connect to primary to confirm its availability

Questions # 32:

Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?

Options:

netLatency

secondaryPreferred

nearest

primaryPreferred

Questions # 33:

Which of the following needs to be performed prior to initiate backup on a sharded cluster?

Options:

db.stopBalancer( )

sh.stopServer( )

db.stopServer( )

sh.stopBalancer( )

Questions # 34:

In mongodb how do you update a document partially?

Options:

$project

$update

$modify

$set

Questions # 35:

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?

Options:

upsert command instead of update command

{update: true, insert: true} as the third parameter of update command

This has to be handled in application code (Node.js, PHP, JAVA, C#, etc.) and cannot be handled in mongo shell query

Specify {upsert : true } as the third parameter of update command

Questions # 36:

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:

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

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

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

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

Questions # 37:

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

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

Options:

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

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

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

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

Questions # 38:

Which features of relational database management systems were deliberately omitted in MongoDB and help us to obtain horizontal scalability? Check all that apply.

Options:

Multi-statement transactions

Joins

Authentication

Questions # 39:

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:

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

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

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

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

Viewing page 4 out of 4 pages

Viewing questions 31-40 out of questions

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

Exam C100DBA Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES