[Q68-Q88] Master 2024 Latest The Questions MongoDB Certified DBA Associate and Pass C100DBA Real Exam! : Exams Labs Braindumps : http://blog.examslabs.com

NO.68 In what format does mongodump creates backup files?

BSON

JSON

SOAP

XML

NO.69 MongoDB is

None of the above

Object-oriented DBMS

Relational DBMS

Document-oriented DBMS

NO.70 Addding the index {a:l} can potentially decrease the speed of which of the following operations? Check all that apply.

db.collection.update({b:456>, {$inc: {a:l> })

db.collection.find( {a : 232} )

db.collection.insert( { a:341})

NO.71 When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?

When the many is not very large

When the many is very large

Always

Never

NO.72 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 ] >

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

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

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

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

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

NO.73 JSON stands for

JavaScript Object Notation

JavaScript Object Naming

JavaScript Object Notice

None of the above

NO.74 Which format/standard is used by MongoDB internally to store documents?

JSON

BSON

B+ Trees

JSON – Extended

NO.75 You are comparing values of different BSON types in mongodb. You want to compare from lowest to highest.
Which comparison order is used?

MinKey, Null, Numbers,Symbol, String,Object,Array,BinData

MinKey, Null, Numbers,Object,Array,BinData,Symbol, String

Object/Array^inData/Symbol,MinKey, Null, Numbers,String

Objec^Array^inData,Symbol, String,MinKey, Null, Numbers

NO.76 To add a new user and enable authentication in MongoDB, which of the following steps need be executed?

update users collection and restart mongodb

All of the above

update users collection and restart mongodb with -auth option

update users collection and run db.enableAuthenticationQ

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

mongos

mongo shell

individual language drivers

mongod

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

mongorestore

mongostat

mongodump

mongotop

NO.79 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?

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

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

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

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

db.stopBalancer()

db.stopserver()

sh.stopBalancer()

sh.stopserverQ

NO.81 Write the command(s) are correct to enable sharding on a database “testdb” and shard a collection “testCollection” with _id as shard key.

NO.82 Which of the documents below will be retrieved by the following query? Assume the documents are stored in a collection called “sample”. Check all that apply.
db.sample.find( { “$or” : [ { “a” : { “$in” : [ 3, 10] > }, { “b” : { “$lt” : 2 > > ] > )

{”__id” :3, “a”: 4, “c” :0, “b” :14}

{”_Jd” :7, “a”: 8, “c” :1, “b” :7}

{“.Jd” :6, “a”: 1, “c” :1, “b” :5}

{ ”Jd” :9, “a”: 17, “c”: 1, “b”: 1}

{ Jd” :10,”a”: 3, “c”: 1, “b”: 1}

{“.Jd” :: 2, “a”: 2, “c” :: 0, “b”: 1}

{“.Jd” :: 4, “a”: 5, “c” :: 0, “b”: 17}

{“.Jd” :: 1, “a”: 0, “c” :: 0, “b”: 2}

{“.Jd” :: 5, “a”: 3, “c” :: 0, “b”: 12}

{“.Jd” :: 8, “a”: 11, “c”: 1, “b”: 0}

NO.83 Which of the following are valid json documents? Select all that apply.

{“a”:l, “b”:{“b”:l, “c”:”foo”, “d”:”bar”, “e”:[l,2,4]}}

{“city”:”New York”, “population”, 7999034, boros:{“queens”, “manhattan”, “staten island”, “the bronx”, u “brooklyn”}}

{“name”:”Fred Flintstone”;”occupation”:”Miner”;”wife”:”Wilma”}

{ }

NO.84 Consider the following document from the products collection:

What does the following query using $elemMatch return? db.products.find( { product_code: “345678” }, { variations: { $elemMatch: { size: ^L^ } } } )

Returns the complete document but retrieves only the size field from the array

Returns the document but with only one element in the variations array (corresponding to size L)

Returns the complete document since MongoDB does not support partial array retrieval

Returns the complete document but retrieves only the size field from the array and also with only one element in the variations array (corresponding to size L)

NO.85 MongoDB is a schema-less design.

False

True

NO.86 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?

None of the above

NO.87 Which of the following command is used to get all the indexes on a collection?

db.collection.showIndexes()

db.collection.findlndexes()

db.showIndexes()

db.collection.getlndexesQ

NO.88 Which of the following is a valid Replica Set configuration if you want:
1-Have 3 copies of everything
2- That RS3 is never primary
2- That RSI and RS2 can be primary?
You had to see the different configurations, RS3 could be hidden or priority 0 (But not a referee because we need
3 replicas), while RSI and RS2 could NOT have priority 0 or be hidden or anything like that In a 4-member RS RSO , RSI, RS2 and RS3 + Referee, RSO (primary) falls after some write operations that have replicated RSI and RS2 (but NOT RS3), who can get up as the new primary?
The configuration comes and in it we see that RS2 has a hidden: true (or a priority: 0, (I don’t remember)

ORS1

ORS2

ORS3

O arbiter

RSO