Updated Jan-2024 Exam Materials for You to Prepare & Pass C100DBA Exam.
Pass Your C100DBA Exam at the First Try with 100% Real Exam
NEW QUESTION # 30
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: {$like: /John/} } )
- C. db.posts.find( { author: /AjohnA/ > )
- D. db.posts.find( { $like: {author: /John/} } )
Answer: A
NEW QUESTION # 31
If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?
- A. The query returned 0 documents
- B. The query returned 30000 documents after scanning the documents
- C. None of the above
- D. The query used an index to fetch the results
Answer: D
NEW QUESTION # 32
Which of the following collections stores authentication credentials in MongoDB?
- A. system.users
- B. local.users
- C. users.users
- D. test.users
Answer: A
NEW QUESTION # 33
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: { $sum: 1 > > >] )
- B. db.population.aggregate( [{ $group: { _id: { state: Estate", city: n$city" },pop: { $sum: "$pop" } } }] )
- C. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
- D. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $pop: 1 } } }] )
Answer: B
NEW QUESTION # 34
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 > > ] > )
- A. {".Jd" :: 2, "a": 2, "c" :: 0, "b": 1}
- B. {".Jd" :: 8, "a": 11, "c": 1, "b": 0}
- C. { ''\Jd" :9, "a": 17, "c": 1, "b": 1}
- D. { \Jd" :10,"a": 3, "c": 1, "b": 1}
- E. {".Jd" :: 4, "a": 5, "c" :: 0, "b": 17}
- F. {".Jd" :: 5, "a": 3, "c" :: 0, "b": 12}
- G. {''__id" :3, "a": 4, "c" :0, "b" :14}
- H. {".Jd" :6, "a": 1, "c" :1, "b" :5}
- I. {".Jd" :: 1, "a": 0, "c" :: 0, "b": 2}
- J. {''_Jd" :7, "a": 8, "c" :1, "b" :7}
Answer: A,B,C,D,F
NEW QUESTION # 35
What does the totalKeysExamined field returned by the explain method indicate?
- A. Details the completed execution of the winning plan as a tree of stages
- B. Number of documents scanned
- C. Number of documents that match the query condition
- D. Number of index entries scanned
Answer: D
NEW QUESTION # 36
By default, the MongoDB cursor in mongo shell is configured to return how many documents? To get the next set of documents, which command is used?
- A. 50, it
- B. 200, more
- C. No limit, none
- D. 20, it
Answer: D
NEW QUESTION # 37
Using an arbiter allows one to easily ensure an odd number of voters in replica sets. Why is this important?
- A. For more efficient backup operations
- B. To help in disaster recovery
- C. To add greather redundancy
- D. To enable certain read preference settings
- E. To protect agains network partitions
Answer: E
NEW QUESTION # 38
Which of the following operators is used to updated a document partially?
- A. $set
- B. $project
- C. $modify
- D. $update
Answer: A
NEW QUESTION # 39
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.
- A. $aggregate
- B. $sum
- C. $group
- D. $match
Answer: D
NEW QUESTION # 40
Which of the following command is used to get all the indexes on a collection?
- A. db.collection.showIndexes()
- B. db.showIndexes()
- C. db.collection.findlndexes()
- D. db.collection.getlndexesQ
Answer: D
NEW QUESTION # 41
Which of the following statements are true about the $match pipeline operator? Check all that apply.
- A. It can be used as many time as needed.
- B. It has a sintax similar to findQ commands.
- C. You should use it early as possible in the pipeline
Answer: A,B,C
NEW QUESTION # 42
What is the use of mongodump and mongorestore tools?
- A. replicate mongodb deployments
- B. audit mongodb deployment
- C. performance tune mongodb deployment
- D. backup mongodb deployment
Answer: D
NEW QUESTION # 43
Which of the following commands finds all the documents in the posts collection with post timestamp field as null?
- A. db.posts.find( { post_timestamp: { $fieldtype: 10 } } )
- B. db.posts.find( { post_timestamp: { $fieldtype: null } } )
- C. db.posts.find( { post_timestamp: { $type: null } } )
- D. db.posts.find( { post_timestamp : { $type; 10 > > )
Answer: D
NEW QUESTION # 44
Which of the following does MongoDB use to provide High Availability and fault tolerance?
- A. Write Concern
- B. Indexing
- C. Sharding
- D. Replication
Answer: D
NEW QUESTION # 45
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($slice:{tags:2>)
- B. 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. - C. db.posts.find({author:"Tom"}.limit({tags:2})
- D. db.posts.find({author:"Tom">,{tags:{$slice:2})
Answer: D
NEW QUESTION # 46
The difference between $push and $addToSet is:
- A. There is no major difference between them. $addToSet is a deprecated version of $push.
- B. $addToSet adds the item to the field only if it does not exist already; while $push pushes the item to the field irrespective of whether it was present or not
- C. $addToSet adds the item to the field only if the new item is of the same datatype
- D. $addToSet needs the fields to be already present while $push will work even if the field is not present
Answer: B
NEW QUESTION # 47
MongoDB is
- A. Object-oriented DBMS
- B. Document-oriented DBMS
- C. Relational DBMS
- D. None of the above
Answer: B
NEW QUESTION # 48
Consider the following documents:
You perform the following query;
How many documents will be updated by the query?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
NEW QUESTION # 49
What is the defau size of a GridFS chunk?
- A. 1 MB
- B. 255 K
- C. 2 MB
- D. 16 MB
Answer: B
NEW QUESTION # 50
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?
- A. secondaryPreferred
- B. primaryPreferred
- C. netLatency
- D. nearest
Answer: D
NEW QUESTION # 51
The________operator can be used to identify an element in the array to be updated without explicitly specifying the position of the element.
- A. $
- B. $slice
- C. $ elemMatch
- D. Updating an array field without knowing its index is not possible.
Answer: A
NEW QUESTION # 52
......
Updated C100DBA Certification Exam Sample Questions: https://www.pass4surecert.com/MongoDB/C100DBA-practice-exam-dumps.html
Get Real Exam Questions for C100DBA with New Questions: https://drive.google.com/open?id=1kVBBNvwcdkTamTltHJ3MF0Lvs9Y_YP6w