Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65pass65

Free MongoDB Associate Database Administrator(Based on MongoDB 6.0 and 7.0+) Practice Questions

Exams4sure Dumps

Exam style questions across every C100DBA domain

Last Update 2 days ago
Total Questions : 172

Start with our free C100DBA practice questions, carefully crafted to mirror the domains, phrasing, and difficulty of the real MongoDB Certified DBA Associate exam. Each C100DBA exam question comes with a detailed rationale that explains not just which answer is correct but why the others fall short. That's how concepts stick. Use the free set to benchmark yourself: identify your MongoDB weak domains, see where you're losing marks, and build a focused study plan in minutes.

C100DBA PDF

C100DBA PDF (Printable)
$54.25
$154.99

C100DBA Testing Engine

C100DBA PDF (Printable)
$59.5
$169.99

C100DBA PDF + Testing Engine

C100DBA PDF (Printable)
$74.55
$212.99
Question # 1

A MongoDB database administrator needs to improve the performance of the following query:

db.employees.find(

{},

{ name: 1, department: 0, salary: 1 }

).sort({ department: 1, salary: -1 });

What index should the administrator use to achieve this goal?

Options:

A.  

db.employees.createIndex({ department: 1, salary: 1, name: 1 });

B.  

db.employees.createIndex({ department: 1, salary: -1 });

C.  

db.employees.createIndex({ salary: 1, name: 1, department: 0 });

D.  

db.employees.createIndex({ name: 1, department: 1, salary: -1 });

Discussion 0
Question # 2

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

Discussion 0
Question # 3

What command will successfully start the mongod daemon with all default settings as a background task?

Options:

A.  

mongod --fork --port 27017

B.  

mongod --fork --dbpath default

C.  

mongod --fork --logpath /var/log/mongodb/mongod.log

D.  

mongod --default

Discussion 0
Question # 4

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

Discussion 0
Question # 5

Consider the following document:

> db.c.find()

{ " _id " : 12, b : [ 3, 5, 7, 2, 1, -4, 3, 12 ] }

Which of the following queries on the " c " collection will return only the first five elements of the array in the " b "

field?

E.  

g.,

Document you want returned by your query:

{ " _id " : 12, " b " : [ 3, 5, 7, 2, 1 ] >

Options:

A.  

db.c.find( { > , { b : { $slice : [ 0 , 5 ] } } )

B.  

db.c.find( { b : [ 0 , 5 ] > )

C.  

db.c.find( { > , { b : { $substr[ 0 , 5 ] > > )

D.  

db.c.find( { > , { b : [ 0, 1, 2, 3, 4, 5 ] > )

E.  

db.c.find( { > , { b : [ 0 , 5 ] > )

Discussion 0
Question # 6

Which of the following does MongoDB use to provide High Availability and fault tolerance?

Options:

A.  

Sharding

B.  

Indexing

C.  

Replication

D.  

Write Concern

Discussion 0
Question # 7

What command is used to grant a role " customRole1 " to an existing user called " user1 " ?

Options:

A.  

db.grantRoles( " user1 " , [ " customRole1 " ])

B.  

db.createUser({ user: " user1 " , pwd: " pwd1 " , roles: [{ role: " customRole1 " , db: " admin " }] })

C.  

db.addRoleToUser( " user1 " , [ " customRole1 " ])

D.  

db.grantRolesToUser( " user1 " , [ " customRole1 " ])

Discussion 0
Question # 8

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

Options:

Discussion 0
Question # 9

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

Discussion 0
Question # 10

What command lists all indexes for a collection?

Options:

A.  

db.collection.info()

B.  

db.collection.indexStats()

C.  

db.collection.findIndexes()

D.  

db.collection.getIndexes()

Discussion 0

Free Exams Sample Questions