Check Real MongoDB C100DBA Exam Question for Free (2024) [Q77-Q98]

NEW QUESTION 77
The MongoDB explain() method does not support which of the following verbosity mode:

executionStats

queryPlanner

customExecutionStats

allPlansExecution

NEW QUESTION 78
What is the equivalent command in MongoDB for the following SQL query?
SELECT * FROM posts WHERE author like “%john%”

db.posts.find( { author: /John/ } )

db.posts.find( { author: /AjohnA/ > )

db.posts.find( { $like: {author: /John/} } )

db.posts.find( { author: {$like: /John/} } )

NEW QUESTION 79
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.

$aggregate

$sum

$match

$group

NEW QUESTION 80
Aggregation Pipelines have a limit of:

No limit on document and 100 MB RAM

2 MB document and no limit on RAM

2 MB document and 100 MB RAM

16 MB document and 100 MB RAM

NEW QUESTION 81
The MongoDB explain() method does not support which of the following verbosity mode:

executionStats

queryPlanner

customExecutionStats

allPlansExecution

NEW QUESTION 82
Consider the following posts document:

Which of the following queries will return the documents but with only the first two tags in the tags array?

db.posts.find({author:”Tom”}.limit({tags:2})

db.posts.find({author:”Tom”}.limit($slice:{tags:2>)

Both “db.posts.find({author:”Tom”},{tags:{$slice:2}})” and
“db.posts.find({author:”Tom”}).limit($slice: {tags:2})” are valid. $slice works both with projection and limit.

db.posts.find({author:”Tom”>,{tags:{$slice:2})

NEW QUESTION 83
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({^comments.$.author”:-l});

db. posts.createIndex({^comments.author” :1});

db.posts.createIndex({^commerits.author”;-!});

NEW QUESTION 84
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.

db.toys.find( { name : “Big Rig Truck”, date : “2013-02-01”, manufacturer : “Tanko”

db.toys.find( { manufacturer : “Matteo”, name : “Barbara”, date : “2014-07-02” } )

db.toys.find( { date : “2015-03-01”, manufacturer : “Loggo”, name : “Brick Set” } )

NEW QUESTION 85
What read preference should your application use if you want to read from the primary under normal circumstances but allow reads from secondaries when a primary is unavailable?

secondaryPreferred

Secondary

nearest

primary

primaryPreferred

NEW QUESTION 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

NEW QUESTION 87
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

NEW QUESTION 88
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

NEW QUESTION 89
Consider that our posts collection contains an array field called tags that contains tags that the user enters. {

Which of the following commands will find all the posts that have been tagged as tutorial.

db.posts.find( { tags : [“tutorial”] } );

db.posts.find( { $array : {tags: “tutorial”) > );

db.posts.find( { tags : “tutorial” } );

db.posts.findInArray( { tags : “tutorial” > );

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

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

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

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

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

NEW QUESTION 91
What is the defau size of a GridFS chunk?

255 K

1 MB

16 MB

2 MB

NEW QUESTION 92
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

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

Returns 5 comments, beginning with the last 10 items

Returns 10 comments, beginning with the last

Returns 10 comments, beginning with the first

Returns 5 comments, beginning with the first 10 items

NEW QUESTION 94
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

NEW QUESTION 95
Which of the following commands can cause the database to be locked?

All of the above

Inserting data

Map-reduce

Issuing a query

NEW QUESTION 96
Which of the following commands finds all the documents in the posts collection with post timestamp field as null?

db.posts.find( { post_timestamp: { $fieldtype: null } } )

db.posts.find( { post_timestamp: { $type: null } } )

db.posts.find( { post_timestamp : { $type; 10 > > )

db.posts.find( { post_timestamp: { $fieldtype: 10 } } )

NEW QUESTION 97
Which of the following operator can be used to limit the number of documents in an array field of a document after an update is performed?

$arrayLimit

$push along with $each, $sort and $slice

$removeFromSet

None of the above

NEW QUESTION 98
Which of the following is correct about MongoDB?

MongoDB supports geospatial indexes

MongoDB supports some of the SQL functions

MongoDB uses JSON format to represent documents

MongoDB supports collection joins