Dec-2024 Free MongoDB C100DBA Exam Question Practice Exams
Ace C100DBA Certification with 130 Actual Questions
The MongoDB C100DBA exam consists of multiple-choice questions and lasts for 90 minutes. The candidates need to score at least 65% to pass the exam and obtain the MongoDB Certified DBA Associate certification. C100DBA exam fee is $150, and it can be taken online or at a testing center. MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) certification is valid for two years, after which the candidates need to renew it by passing a recertification exam. The MongoDB C100DBA certification is recognized globally and can help professionals enhance their career prospects and improve their credibility in the industry.
MongoDB C100DBA exam is an essential certification for professionals who work with MongoDB. It is a globally recognized certification that validates the skills and knowledge required to become a MongoDB Certified DBA Associate. Passing C100DBA exam demonstrates the ability to manage and maintain MongoDB databases, troubleshoot issues, and optimize performance. Candidates who pass C100DBA exam will have a valuable credential that can help advance their careers.
NEW QUESTION # 21
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" : : 8, "a" : 11, "c" : 1, "b" : 0}
- B. { ''\ Jd" : 9, "a" : 17, "c" : 1, "b" : 1}
- C. {". Jd" : : 2, "a" : 2, "c" : : 0, "b" : 1}
- D. {''_ _id" : 3, "a" : 4, "c" : 0, "b" : 14}
- E. {''_ Jd" : 7, "a" : 8, "c" : 1, "b" : 7}
- F. {". Jd" : : 5, "a" : 3, "c" : : 0, "b" : 12}
- G. { \ Jd" : 10,"a" : 3, "c" : 1, "b" : 1}
- H. {". Jd" : : 1, "a" : 0, "c" : : 0, "b" : 2}
- I. {". Jd" : : 4, "a" : 5, "c" : : 0, "b" : 17}
- J. {". Jd" : 6, "a" : 1, "c" : 1, "b" : 5}
Answer: A,B,C,F,G
NEW QUESTION # 22
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:
- A. <database>..oplog.rs
- B. <replicasetid>.oplog.rs
- C. oplog.rs
- D. local.oplog.rs
Answer: D
NEW QUESTION # 23
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 } , { "justOne" : true } ) // This operation cannot be done with a single query.
- B. db.sample.update( { "_id" : 3 } , { "$set" : { "_id" : 7 , "c" : 4 } } )
- C. db.sample.update( { "_id" : 3 } , { "_id" : 7 , "c" : 4 } )
- D. db.sample.update( { "_id" : 3 } , { "_id" : 7 , "c" : 4 , { "$unset" : [ "a" , "b" ] } } )
Answer: D
NEW QUESTION # 24
If you have created a compound index on (A,B, C) which of the following access pattern will not be able to utilize the index?
- A. B, C
- B. A, B, C
- C. A
- D. A, B
Answer: A
NEW QUESTION # 25
Write the command(s) are correct to enable sharding on a database "testdb" and shard a collection "testCollection" with _id as shard key.
Answer:
Explanation:
sh.enableSharding("testdb") & sh.shardCollection("testdb.testCollection", {_id : 1 }, true )
NEW QUESTION # 26
Which of the following is a valid insert statement in mongodb? Select all valid.
- A. db.test.insert{"x":2, "y":"apple"})
- B. db.test.insert({x:2},{y:"apple"})
- C. db.test.insert({x:2,y:"apple"})
- D. db.test.push({x:2,y:"apple"})
Answer: A,C
NEW QUESTION # 27
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^ } } } )
- A. 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)
- B. Returns the complete document but retrieves only the size field from the array
- C. Returns the complete document since MongoDB does not support partial array retrieval
- D. Returns the document but with only one element in the variations array (corresponding to size L)
Answer: D
NEW QUESTION # 28
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":-l});
- B. db.posts.createIndex({comments.$.author": {$desc:l>});
- C. db.posts.createIndex({commerits.$.author":-l});
Answer: A
NEW QUESTION # 29
Which type of indexes does MongoDB support?
- A. All of the above
- B. Geospatial Indexes
- C. Compound Indexes
- D. Multikey Indexes
Answer: A
NEW QUESTION # 30
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: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
- B. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: 1 > > >] )
- C. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: "$pop" } } }] )
- D. db.population.aggregate( [{ $group: { _id: { state: "$state", city: "$city" },pop: { $pop: 1 } } }] )
Answer: C
NEW QUESTION # 31
Consider that the posts collection contains an array called ratings which contains ratings given to the post by various users in the following format:
Which of the following query will return all the documents where the ratings array contains elements that in some combination satisfy the query conditions?
- A. db.inventory.find( { ratings: { $elemMatch: { $gt: 3, $lt: 6 }
- B. db.inventory.find( { ratings: { $elemMatch: { $gte: 3, $lte: 6 } } } )
- C. db.inventory.find( { ratings: { ratings: { $gt: 5, $lt: 9 } } } )
- D. db.inventory.find( { ratings: { ratings.$: { $gt: 5, $lt: 9 } } } )
Answer: C
NEW QUESTION # 32
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("580a42acdfblb5al7427d301"), "nombre" : "Luis", "apellido" : "gomez", "aficion" : u "flipar" }
- B. { "-id" : Objectld("580a42b5dfblb5al7427d302"), "nombre" : "ruben", "apellido" : "gomez", "aficion" : v u "flipar" }
- C. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "Pablo" , "aficion" : u "flipar"}
- D. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "gomez" >
Answer: B,D
NEW QUESTION # 33
In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?
- A. individual language drivers
- B. mongod
- C. mongo shell
- D. mongos
Answer: A
NEW QUESTION # 34
What does the output x of the following MongoDB aggregation query result into; db.posts.aggregate( [ { $group: { _id; "$author", x: { $sum: $likes } } } ] )
- A. Average of likes on all the posts of an author, grouped by author
- B. Sum of likes on all the posts by an author, grouped by author
- C. Sum of likes on all the posts by all the authors
- D. Number of posts by an author
Answer: B
NEW QUESTION # 35
Which mongodb tools allow us to work with our data in a human readable format?
- A. mongodump
- B. mongoexport
- C. mongoimport
- D. mongostat
Answer: B,C
NEW QUESTION # 36
What is the output of following two commands in MongoDB: db. posts. insert({n_id":l}) db.posts.insert({"_id":l})
- A. Two documents will be inserted with _id as 1
- B. MongoDB will automatically increment the _id of the second document as 2
- C. This will throw a duplicate key error
- D. It will insert two documents and throw a warning to the user
Answer: C
NEW QUESTION # 37
In a replica set, a_________number of members ensures that the replica set is always able to select a primary.
- A. Depends on the application architecture
- B. Even
- C. Odd
- D. 0
Answer: C
NEW QUESTION # 38
Which of the following is a valid insert statement in mongodb? Select all valid.
- A. db.test.insert({"x":2, "y":"apple"})
- B. db.test.insert({x:2},{y:"apple"})
- C. db.test.insert({x:2,y:"apple"})
- D. db.test.push({x:2,y:"apple"})
Answer: A,C
NEW QUESTION # 39
What tool do you use if you want to extract a CSV from mongo?
Answer:
Explanation:
mongoexport
NEW QUESTION # 40
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?
- A. db.posts.findOne({post_text: 1})
- B. db.posts.find({},{_id:Of post_text:1})
- C. db.posts.finOne{},{post_text:l})
- D. db.posts.finOne({},{_id:0, post_text:1})
Answer: D
NEW QUESTION # 41
Which of the following is true about aggregation framework?
- A. Pipeline expressions are stateless except accumulator expressions used with $group operator
- B. Each aggregation operator need to return atleast one of more documents as a result
- C. A single aggregation framework operator can be used more than once in a query
- D. the aggregate command operates on a multiple collection
Answer: A,B,C
NEW QUESTION # 42
Which of the following is a valid Replica Set configuration if you want:
1-Have 3 copies of everything
2- That RS3 is never primary
2- That RSI and RS2 can be primary?
You had to see the different configurations, RS3 could be hidden or priority 0 (But not a referee because we need
3 replicas), while RSI and RS2 could NOT have priority 0 or be hidden or anything like that In a 4-member RS RSO , RSI, RS2 and RS3 + Referee, RSO (primary) falls after some write operations that have replicated RSI and RS2 (but NOT RS3), who can get up as the new primary?
The configuration comes and in it we see that RS2 has a hidden: true (or a priority: 0, (I don't remember)
- A. ORS1
- B. O arbiter
- C. ORS2
- D. RSO
- E. ORS3
Answer: A
NEW QUESTION # 43
......
To pass the C100DBA exam, candidates need to have a deep understanding of MongoDB's architecture, replication, sharding, and backup and recovery processes. Additionally, candidates need to know how to manage users and roles, configure security, and troubleshoot issues related to MongoDB. C100DBA exam also covers topics such as indexing, performance tuning, and monitoring. MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) certification helps candidates demonstrate their expertise in MongoDB database administration and provides them with recognition and credibility in the industry.
C100DBA Questions PDF [2024] Use Valid New dump to Clear Exam: https://exampdf.dumpsactual.com/C100DBA-actualtests-dumps.html
