MongoDB C100DBA Deluxe Study Guide with Online Test Engine [Q36-Q58] : IT Certification Exam Braindumps : http://blog.braindumpsit.com

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

db.posts.finOne({},{_id:0, post_text:1})

db.posts.findOne({post_text: 1})

db.posts.find({},{_id:Of post_text:1})

db.posts.finOne{},{post_text:l})

NO.37 What is the use of mongodump and mongorestore tools?

backup mongodb deployment

audit mongodb deployment

performance tune mongodb deployment

replicate mongodb deployments

NO.38 Below is a sample document of “orders” collection

NO.39 Update If Correct is an approach for which of the following concepts in MongoDB:

Concurrency Control

Atomicity

Performance Management

Transaction Management

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

netLatency

secondaryPreferred

nearest

primaryPreferred

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

$slice

All of the above

$ elemMatch

NO.42 In mongodb how do you update a document partially?

$project

$update

$modify

$set

NO.43 A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?

Column and Row

Table and Row

Database and Table

Table and Column

NO.44 What is the output of following two commands in MongoDB: db. posts. insert({n_id”:l}) db.posts.insert({“_id”:l})

Two documents will be inserted with _id as 1

MongoDB will automatically increment the _id of the second document as 2

This will throw a duplicate key error

It will insert two documents and throw a warning to the user

NO.45 You have designed a web application with mongoDB. You have configured replication. The replica set is in place and function properly. What happens in case of failure?

Switchover needs to be done manually

Failover happens automatically

Switchover happens automatically

Failover needs to be done manually

NO.46 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:

<replicasetid>.oplog.rs

oplog.rs

<database>..oplog.rs

local.oplog.rs

NO.47 What does the following query do when performed on the posts collection? db.posts.update({_id:l},{Title:This is post with ID 1″})

Syntax error

Replaces the complete document with _id as 1 with the document specified in second parameter

Updates the Title of the post

Updating a document is possible only with $set

NO.48 Consider the following documents:

You perform the following query;

How many documents will be updated by the query?

NO.49 Which command can be used to rebuild the indexes on a collection in MongoDB?

db.collection.createlndex({relndex:l})

db.collection.reIndex({author:l})

db.collection.relndexQ

db.collection.createIndex({author:l}).reIndex()

NO.50 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.

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

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

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

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

NO.51 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.52 Which of the following does MongoDB use to provide High Availability and fault tolerance?

Sharding

Indexing

Replication

Write Concern

NO.53 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.54 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.55 Which type of indexes does MongoDB support?

All of the above

Compound Indexes

Multikey Indexes

Geospatial Indexes

NO.56 What does the following aggregate query perform?

Fetches the posts with likes between 100 and 200 and sets their _id as null

Groups the posts by number of likes (101, 102, 103.) by adding 1 every time

Calculates the number of posts with likes between 100 and 200

Fetches the posts with likes between 100 and 200, sets the _id of the first document as null and then increments it 1 every time

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

MongoDB C100DBA Deluxe Study Guide with Online Test Engine [Q36-Q58]

How could you focus on MongoDB C100DBA Certification