Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

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.

A.

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

B.

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

C.

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

D.

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

Consider the following example document:

{

"_id": Objectld("5360c0a0a655a60674680bbe"),

"user"

"login": "irOn"

"description": "Made of steel"

"date": ISODate("2014-04-30T09:16:45.836Z"),

}

>

and index creation command:

db.users.createlndex( { "user.login": 1, "user.date": -1 }, "mylndex" )

When performing the following query:

db.users.find( { "user.login": /Air.*/ },

{ "user":1, "_id":0 > ).sort( { "user.date":1 > )

which of the following statements correctly describe how MongoDB will handle the query? Check all that apply.

A.

As an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an indexed field

B.

As an indexed query using "mylndex" because field "user.login" is indexed

C.

MongoDB will need to do a table/collection scan to find matching documents

D.

None of the above

E.

As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"

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

A.

JSON

B.

BSON

C.

B+ Trees

D.

JSON - Extended

'mongoimport' command is used for

A.

Batch data insertion

B.

None of the above

C.

Multiple command import

D.

Multiple command insertion

In a sharded cluster, from which node does one stop the balancer process before initiating backup?

A.

Any node

B.

replicaset primary node

C.

config server node

D.

mongos node

In a sharded replica set environment, the w Option provides ability for write concern and j Option provides ability for the data to be written on disk journal. Consider that we have a seven member replica set and we want to assure that the writes are committed to journal. What should be the value of j?

A.

7

B.

2

C.

1

D.

0

Which of the following is correct about MongoDB?

A.

MongoDB supports geospatial indexes

B.

MongoDB supports some of the SQL functions

C.

MongoDB uses JSON format to represent documents

D.

MongoDB supports collection joins

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.

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

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

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

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

Which option should be used to update all the documents with the specified condition in the MongoDB query?

A.

specify {all: true} as the third parameter of update command

B.

updateAII instead of update

C.

specify {updateAII: true} as the third parameter of update command

D.

specify {multi : true} as the third parameter of update command