2024 Updated MongoDB C100DBA Dumps PDF - Want To Pass C100DBA Fast
C100DBA Practice Exam Dumps - 99% Marks In MongoDB Exam
NEW QUESTION # 71
What does the totalKeysExamined field returned by the explain method indicate?
- A. Number of documents that match the query condition
- B. Details the completed execution of the winning plan as a tree of stages
- C. Number of documents scanned
- D. Number of index entries scanned
Answer: D
NEW QUESTION # 72
What tool would you use if you want to save a gif file in mongo?
Answer:
Explanation:
mongofile
NEW QUESTION # 73
Which are the ONLY ways to project portions of an array?
- A. $ elemMatch
- B. $
- C. All of the above
- D. $slice
Answer: C
NEW QUESTION # 74
What does the following $slice query return using the following command? db.posts.find( {}, { comments: {
$slice: [ -10, 5 ] } } )
- A. Returns 10 comments, beginning with the first
- B. Returns 5 comments, beginning with the first 10 items
- C. Returns 5 comments, beginning with the last 10 items
- D. Returns 10 comments, beginning with the last
Answer: C
NEW QUESTION # 75
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?
- A. db.posts.createIndex({commerits.$.author":-l});
- B. db.posts.createIndex({comments.$.author": {$desc:l>});
- C. db.posts.createIndex({comments.author":-l});
Answer: C
NEW QUESTION # 76
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?
- A. db.posts.find({author:"Tom"}.limit({tags:2})
- B. db.posts.find({author:"Tom">,{tags:{$slice:2})
- C. db.posts.find({author:"Tom"}.limit($slice:{tags:2>)
- D. 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.
Answer: B
NEW QUESTION # 77
What does the following query do when performed on the posts collection? db.posts.update({_id:l},{Title:This is post with ID 1"})
- A. Replaces the complete document with _id as 1 with the document specified in second parameter
- B. Updating a document is possible only with $set
- C. Updates the Title of the post
- D. Syntax error
Answer: A
NEW QUESTION # 78
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 ] }
- A. db.c.find( { > , { b : { $slice : [ 0 , 5 ] } } )
- B. db.c.find( { > , { b : [ 0 , 5 ] > )
- C. db.c.find( { > , { b : { $substr[ 0 , 5 ] > > )
- D. db.c.find( { b : [ 0 , 5 ] > )
- E. db.c.find( { > , { b : [ 0, 1, 2, 3, 4, 5 ] > )
Answer: A
NEW QUESTION # 79
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?
- A. missing operations will need to be manually re-performed
- B. the most current secondary will roll back the operations following the election
- C. the secondary with the most current oplog will be elected primary
- D. reads will be stale until the primary comes back up
- E. the primary may roll back the operations once it recovers
Answer: C
NEW QUESTION # 80
Which of the following operators is used to updated a document partially?
- A. $project
- B. $set
- C. $modify
- D. $update
Answer: B
NEW QUESTION # 81
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 } )
- 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, d : 1 } )
Answer: A,D
NEW QUESTION # 82
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( { $like: {author: /John/} } )
- C. db.posts.find( { author: {$like: /John/} } )
- D. db.posts.find( { author: /AjohnA/ > )
Answer: A
NEW QUESTION # 83
Dada una coleccion, cuales devuelve con la siguiente query
db.coleccion.find({nombre:"ruben",apellido:"gomez"},{nombre:l,apellido:l,aficion:l});
- A. { "-id" : Objectld("580a42b5dfblb5al7427d302"), "nombre" : "ruben", "apellido" : "gomez", "aficion" :
v u "flipar" } - B. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "Pablo" , "aficion" : u
"flipar"} - C. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "Luis", "apellido" : "gomez", "aficion" : u
"flipar" } - D. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "gomez" >
Answer: A,D
NEW QUESTION # 84
What is the output of the following program?
- A. 1s
- B. 60 s
- C. 100 ms
- D. 100 s
Answer: B
NEW QUESTION # 85
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?
- A. db.population.aggregate( [{ $group: { _id: { state: "$state", city: "$city" },pop: { $pop: 1 } } }] )
- B. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
- C. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: 1 > > >] )
- D. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: "$pop" } } }] )
Answer: D
NEW QUESTION # 86
Which of the following commands will return all the posts with number of likes greater than 100 and less than 200, both inclusive?
- 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 > > );
Answer: A
NEW QUESTION # 87
......
Updated Verified C100DBA Q&As - Pass Guarantee: https://www.actual4exams.com/C100DBA-valid-dump.html
C100DBA Certification with Actual Questions: https://drive.google.com/open?id=1AZoWm3RQmRFVi4_H9WDXhKXgH6defyfo