Black Friday Sale - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 65percent

Welcome To DumpsPedia

C100DBA Sample Questions Answers

Questions 4

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

Options:

A.

Multi-statement transactions

B.

Joins

C.

Authentication

Buy Now
Questions 5

We can insert multiple documents in bulk using which of the following operations:

Options:

A.

initializeUnorderedBulk

B.

initializeUnorderedBulkOp

C.

initializeBulk

D.

initializeBulkOp

Buy Now
Questions 6

Consider that the posts collection contains an array called ratings which contains ratings given to the post by various users in the following format:

Which of the following query will return all the documents where the ratings array contains elements that in some combination satisfy the query conditions?

Options:

A.

db.inventory.find( { ratings: { $elemMatch: { $gte: 3, $lte: 6 } } } )

B.

db.inventory.find( { ratings: { $elemMatch: { $gt: 3, $lt: 6 }

C.

db.inventory.find( { ratings: { ratings.$: { $gt: 5, $lt: 9 } } } )

D.

db.inventory.find( { ratings: { ratings: { $gt: 5, $lt: 9 } } } )

Buy Now
Questions 7

‘$set' sets the value of

Options:

A.

Code block

B.

Name/value pair

C.

Key

D.

None of the above

Buy Now
Questions 8

In order to ensure that you can maintain high availability in the face of server failure, you should implement which of the following?

Options:

A.

Sharding

B.

Properly defined user roles

C.

Replication

D.

Put indexes on all of your documents

E.

The proper storage engine

Buy Now
Questions 9

As per the aggregation pipeline optimization concepts, if you have a $sort followed by a $match:

Options:

A.

Providing these parameters in any order does not impact the performance

B.

$sort moves before $match

C.

MongoDB does not do any movements by default and will use the order provided

D.

$match moves before $sort

Buy Now
Questions 10

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

Buy Now
Questions 11

What is the replication factor for a replicated cluster with 1 primary, 3 secondaries with one of them hidden. The set also has an arbiter?

Options:

A.

None of the above

B.

5

C.

3

D.

4

Buy Now
Questions 12

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

Buy Now
Questions 13

Which node in a replica set does accept write operation?

Options:

A.

arbiter

B.

hidden

C.

primary

D.

secondary

Buy Now
Questions 14

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

Buy Now
Questions 15

Aggregation Pipelines have a limit of:

Options:

A.

No limit on document and 100 MB RAM

B.

2 MB document and no limit on RAM

C.

2 MB document and 100 MB RAM

D.

16 MB document and 100 MB RAM

Buy Now
Questions 16

In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?

Options:

A.

mongos

B.

mongo shell

C.

individual language drivers

D.

mongod

Buy Now
Questions 17

Which mongodb tool is used to report details on number of database operations in MongoDB?

Options:

A.

mongostat

B.

mongotop

C.

mongorestore

D.

mongodump

Buy Now
Questions 18

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.

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

C.

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

D.

Skips the first five documents and returns the next five

Buy Now
Questions 19

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?

Options:

A.

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

B.

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

C.

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

Buy Now
Questions 20

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

Buy Now
Questions 21

What is the defau size of a GridFS chunk?

Options:

A.

255 K

B.

1 MB

C.

16 MB

D.

2 MB

Buy Now
Questions 22

The oplog (operations log) is a special capped collection that keeps a rolling record of all operations that modify the data stored in your databases. All the replica set members contain a copy of the oplog in the following collection:

Options:

A.

.oplog.rs

B.

oplog.rs

C.

..oplog.rs

D.

local.oplog.rs

Buy Now
Questions 23

What does the following $slice query return using the following command? db.posts.find( {}, { comments: { $slice: [ -10, 5 ] } } )

Options:

A.

Returns 5 comments, beginning with the last 10 items

B.

Returns 10 comments, beginning with the last

C.

Returns 10 comments, beginning with the first

D.

Returns 5 comments, beginning with the first 10 items

Buy Now
Questions 24

Which are the ONLY ways to project portions of an array?

Options:

A.

$slice

B.

$

C.

All of the above

D.

$ elemMatch

Buy Now
Questions 25

Dada una coleccion, cuales devuelve con la siguiente query db.coleccion.find({nombre:"ruben",apellido:"gomez"},{nombre:l,apellido:l,aficion:l});

Options:

A.

{ "-id" : Objectld("580a42b5dfblb5al7427d302"), "nombre" : "ruben", "apellido" : "gomez", "aficion" : v u "flipar" }

B.

{ "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "Luis", "apellido" : "gomez", "aficion" : u "flipar" }

C.

{ "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "Pablo" , "aficion" : u "flipar"}

D.

{ "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "gomez" >

Buy Now
Questions 26

Aggregation Pipelines have a limit of:

Options:

A.

2 MB document and 100 MB RAM

B.

16 MB document and 100 MB RAM

C.

No limit on document and 100 MB RAM

D.

2 MB document and no limit on RAM

Buy Now
Questions 27

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

Buy Now
Questions 28

JSON stands for

Options:

A.

JavaScript Object Notation

B.

JavaScript Object Naming

C.

JavaScript Object Notice

D.

None of the above

Buy Now
Questions 29

Given a replica set with five data-bearing members, suppose the primary goes down with operations in its oplog that have been copied from the primary to only one secondary. Assuming no other problems occur, which of the following describes what is most likely to happen?

Options:

A.

missing operations will need to be manually re-performed

B.

the secondary with the most current oplog will be elected primary

C.

reads will be stale until the primary comes back up

D.

the primary may roll back the operations once it recovers

E.

the most current secondary will roll back the operations following the election

Buy Now
Questions 30

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

Options:

A.

allPlansExecution

B.

customExecutionStats

C.

queryPlanner

D.

executionStats

Buy Now
Questions 31

Which of the following command inside aggregate command is used in MongoDB aggregation to filter the documents to pass only the documents that match the specified condition(s) to the next pipeline stage.

Options:

A.

$aggregate

B.

$sum

C.

$match

D.

$group

Buy Now
Questions 32

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

Buy Now
Questions 33

Which of the following is incorrect statement about find and findOne operations in MongoDB?

Options:

A.

findQ returns all the documents in a collection while findOne() retrieves only the first one.

B.

find.limit(l) is not the same query as findOne()

C.

findOneQ returns the actual first document retrieved from a collection

D.

findQ and findOneQ returns cursors to the collection documents

Buy Now
Questions 34

Which of the following node is used during election in a replication cluster?

Options:

A.

primary

B.

arbiter

C.

hidden

D.

secondary

Buy Now
Questions 35

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

Buy Now
Questions 36

Which of the following aggregate commands in MongoDB uses a pipeline approach with the goals of improving the aggregation performance?

Options:

A.

mapReduce

B.

group

C.

aggregate

D.

All of the above

Buy Now
Questions 37

Which of the following is true of the mechanics of replication in MongoDB? Check all that apply.

Options:

A.

Members of a replica set may replicate data from any other data-bearing member of the set by default

B.

Clients read from the nearest member of a replica ser by default

C.

Operations on the primary are recorded in a capped collection called the oplog

Buy Now
Questions 38

Consider the following example document from the sample collection. All documents in this collection have the same schema.

Which of the following queries will replace this with the document.

Options:

A.

db.sample.update( { "_id" : 3 } , { "$set" : { "_id" : 7 , "c" : 4 > > )

B.

db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > , { "justOne" : true > ) / □ This operation cannot be done with a single query.

C.

db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 , { "$unset" : [ "a" , "b" ] } } )

D.

db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > )

Buy Now
Questions 39

In what format does mongodump creates backup files?

Options:

A.

BSON

B.

JSON

C.

SOAP

D.

XML

Buy Now
Exam Code: C100DBA
Exam Name: MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4)
Last Update: Nov 23, 2024
Questions: 132
$57.75  $164.99
$43.75  $124.99
$36.75  $104.99
buy now C100DBA