[2021] Pass C100DBA Exam - Real Questions & Answers
C100DBA Exam Questions Get Updated [2021] with Correct Answers
NEW QUESTION 31
In which of the following scenarios is sharding not the correct option. Select all that apply.
- A. The working set in the collection is expected to grow very large in size
- B. The write operations on the collection are very high
- C. The write operations on the collection are low
- D. The collection is a read intensive collection with less working set
Answer: C,D
NEW QUESTION 32
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, $lt : 200 > > );
- C. db.posts.find({ likes : { $gte : 100, $lt : 200 } } );
- D. db.posts.find({ likes : { $gt : 100 , $lte : 200 } } );
Answer: A
NEW QUESTION 33
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.
- A. db.posts.find( { $array : {tags: "tutorial") > );
- B. db.posts.find( { tags : ["tutorial"] } );
- C. db.posts.find( { tags : "tutorial" } );
- D. db.posts.findInArray( { tags : "tutorial" > );
Answer: C
NEW QUESTION 34
Which command is used to determine storage capacity of specific database?
- A. dbstats
- B. mongotop
- C. constats
- D. mongostat
Answer: A
NEW QUESTION 35
MongoDB is a schema-less design.
- A. True
- B. False
Answer: A
NEW QUESTION 36
Which of the following operator can be used to control the number of items of an array that a query returns?
- A. $slice
- B. MongoDB does not support partial retrieval of items from an array
- C. $ elemMatch
- D. $
Answer: A
NEW QUESTION 37
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. db.posts.find({author:"Tom"}.limit({tags:2})
- C. db.posts.find({author:"Tom">,{tags:{$slice: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: C
NEW QUESTION 38
Which option can be used with update command so that a new document gets created if no matching document is found based on the query condition?
- A. upsert command instead of update command
- B. {update: true, insert: true} as the third parameter of update command
- C. Specify {upsert : true } as the third parameter of update command
- D. This has to be handled in application code (Node.js, PHP, JAVA, C#, etc.) and cannot be handled in mongo shell query
Answer: C
NEW QUESTION 39
Which of the following command is used to get all the indexes on a collection?
- A. db.collection.getlndexesQ
- B. db.showIndexes()
- C. db.collection.showIndexes()
- D. db.collection.findlndexes()
Answer: A
NEW QUESTION 40
Which is the default mode in which the explain() command runs?
- A. queryPlanner
- B. allPlansExecution
- C. executionStats
- D. customExecutionStats
Answer: A
NEW QUESTION 41
In order to ensure that you can maintain high availability in the face of server failure, you should implement which of the following?
- A. Replication
- B. The proper storage engine
- C. Put indexes on all of your documents
- D. Properly defined user roles
- E. Sharding
Answer: A
NEW QUESTION 42
In a sharded cluster, from which node does one stop the balancer process before initiating backup?
- A. Any node
- B. replicaset primary node
- C. mongos node
- D. config server node
Answer: C
NEW QUESTION 43
You perform the following operation in the shell: db.foo.insert( { } ); What gets inserted?
- A. No document will be inserted; an error will be raised
- B. A document that matches the collection's existing schema, but with null fields
- C. A document with an _id assigned to be an Objectld
- D. An empty document
- E. A document will be inserted with the same _id as the last document inserted
Answer: C
NEW QUESTION 44
Which mongodb tool is used to report details on number of database operations in MongoDB?
- A. mongorestore
- B. mongotop
- C. mongodump
- D. mongostat
Answer: D
NEW QUESTION 45
Which type of indexes does MongoDB support?
- A. Multikey Indexes
- B. Compound Indexes
- C. All of the above
- D. Geospatial Indexes
Answer: C
NEW QUESTION 46
Which of the following does MongoDB use to provide High Scalability?
- A. Replication
- B. Indexing
- C. Write Concern
- D. Sharding
Answer: D
NEW QUESTION 47
Which of the following aggregation commands in MongoDB does not support sharded collections?
- A. All of the above
- B. group
- C. aggregate
- D. mapReduce
Answer: B
NEW QUESTION 48
Which command can be used to rebuild the indexes on a collection in MongoDB?
- A. db.collection.reIndex({author:l})
- B. db.collection.createlndex({relndex:l})
- C. db.collection.createIndex({author:l}).reIndex()
- D. db.collection.relndexQ
Answer: D
NEW QUESTION 49
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: "$city" },pop: { $pop: 1 } } }] )
- B. db.population.aggregate( [{ $group: { _id: { state: "$state", city; "$city" },pop: { $sum: 1 > > >] )
- C. db.population.aggregate( [{ $group: { _id: { state: Estate", city: n$city" },pop: { $sum: "$pop" } } }] )
- D. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
Answer: C
NEW QUESTION 50
......
Practice C100DBA Questions With Certification guide Q&A from Training Expert TestKingsIT: https://www.testkingit.com/MongoDB/latest-C100DBA-exam-dumps.html
Free MongoDB C100DBA Test Practice Test Questions Exam Dumps: https://drive.google.com/open?id=1hdfNWzTgsemalSalTbc5QGX7n1A3G_LL