Dec-2023 MongoDB C100DBA Certification Real 2023 Mock Exam
C100DBA Exam Questions and Valid PMP Dumps PDF
The C100DBA certification exam is based on the latest version of MongoDB, version 4.4. It covers a wide range of topics related to database administration, including installation and configuration, performance optimization, security, backup and recovery, and data modeling. C100DBA exam is designed to test the skills and knowledge of professionals who work with MongoDB databases on a daily basis and are responsible for ensuring that they are running smoothly and efficiently.
NEW QUESTION # 51
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 : [ 0 , 5 ] > )
- B. db.c.find( { > , { b : { $slice : [ 0 , 5 ] } } )
- C. db.c.find( { > , { b : [ 0 , 5 ] > )
- D. db.c.find( { > , { b : [ 0, 1, 2, 3, 4, 5 ] > )
- E. db.c.find( { > , { b : { $substr[ 0 , 5 ] > > )
Answer: B
NEW QUESTION # 52
Which of the following is true about sharding?
- A. We cannot change a shard key directly/automatically once it is set up
- B. Creating a sharded key automatically creates an index on the collection using that key
- C. Sharding is enabled at the database level
- D. A sharded environment does not support sorting functionality since the documents lie on various mongod instances
Answer: A
NEW QUESTION # 53
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 used an index to fetch the results
- C. The query returned 30000 documents after scanning the documents
- D. None of the above
Answer: B
NEW QUESTION # 54
Which of the following node is used during election in a replication cluster?
- A. secondary
- B. arbiter
- C. primary
- D. hidden
Answer: B
NEW QUESTION # 55
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.
- A. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > )
- B. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 , { "$unset" : [ "a" , "b" ] } } )
- C. db.sample.update( { "_id" : 3 } , { "$set" : { "_id" : 7 , "c" : 4 > > )
- D. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > , { "justOne" : true > ) / This operation cannot be done with a single query.
Answer: B
NEW QUESTION # 56
Aggregation Pipelines have a limit of:
- A. No limit on document and 100 MB RAM
- B. 2 MB document and 100 MB RAM
- C. 16 MB document and 100 MB RAM
- D. 2 MB document and no limit on RAM
Answer: C
NEW QUESTION # 57
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: Estate", city: n$city" },pop: { $sum: "$pop" } } }] )
- B. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $pop: 1 } } }] )
- C. db.population.aggregate( [{ $group: { _id: { state: "$state", city; "$city" },pop: { $sum: 1 > > >] )
- D. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
Answer: A
NEW QUESTION # 58
Which of the following are valid json documents? Select all that apply.
- A. {"city":"New York", "population", 7999034, boros:{"queens", "manhattan", "staten island", "the bronx", u "brooklyn"}}
- B. {"a":l, "b":{"b":l, "c":"foo", "d":"bar", "e":[l,2,4]}}
- C. {"name":"Fred Flintstone";"occupation":"Miner";"wife":"Wilma"}
- D. { }
Answer: B,D
NEW QUESTION # 59
Which operations add new documents to a collection?
- A. insert
- B. Create
- C. update
- D. delete
Answer: A,B
NEW QUESTION # 60
What is the maximum size of Index Key Limit and Number of Indexes per collection?
- A. 1024 bytes and unlimited indexes
- B. 12 mega bytes and 64 indexes
- C. 64 bytes and 1024 indexes
- D. 1024 bytes and 64 indexes
Answer: D
NEW QUESTION # 61
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?
- A. secondaryPreferred
- B. nearest
- C. primaryPreferred
- D. primary
- E. Secondary
Answer: C
NEW QUESTION # 62
You have a replicated cluster with 1 primary, 3 secondary, 1 arbiter. One of the secondary is hidden. What is the replication factor of this replicated cluster?
- A. 0
- B. 03
- C. 06
- D. 04
Answer: D
NEW QUESTION # 63
Which of the following collections stores authentication credentials in MongoDB?
- A. local.users
- B. test.users
- C. users.users
- D. system.users
Answer: D
NEW QUESTION # 64
Which mongodb tool is used to report details on number of database operations in MongoDB?
- A. mongorestore
- B. mongostat
- C. mongodump
- D. mongotop
Answer: B
NEW QUESTION # 65
Which type of indexes does MongoDB support?
- A. Geospatial Indexes
- B. Compound Indexes
- C. All of the above
- D. Multikey Indexes
Answer: C
NEW QUESTION # 66
'$set' sets the value of
- A. Name/value pair
- B. Code block
- C. None of the above
- D. Key
Answer: D
NEW QUESTION # 67
What is the maximum size of a MongoDB document
- A. There is no maximum size. It depends on the RAM.
- B. 12 MB
- C. 2 MB
- D. 16 MB
Answer: D
NEW QUESTION # 68
JSON stands for
- A. JavaScript Object Notice
- B. None of the above
- C. JavaScript Object Notation
- D. JavaScript Object Naming
Answer: C
NEW QUESTION # 69
What is the equivalent command in MongoDB for the following SQL query?
SELECT * FROM posts WHERE author like "%john%"
- A. db.posts.find( { $like: {author: /John/} } )
- B. db.posts.find( { author: {$like: /John/} } )
- C. db.posts.find( { author: /John/ } )
- D. db.posts.find( { author: /AjohnA/ > )
Answer: C
NEW QUESTION # 70
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({^comments.author" :1});
- B. db.posts.createIndex({^comments.$.author":-l});
- C. db.posts.createIndex({^commerits.author";-!});
Answer: C
NEW QUESTION # 71
......
C100DBA Question Bank: Free PDF Download Recently Updated Questions: https://www.practicetorrent.com/C100DBA-practice-exam-torrent.html
C100DBA Brain Dump: A Study Guide with Tips & Tricks for passing Exam: https://drive.google.com/open?id=1-jKCq-3JBYw010p4Gzy4ggJa2z1kAx8j