[Oct 31, 2021] Passing Key To Getting C100DBA Certified Exam Engine PDF [Q31-Q49]

Share

[Oct 31, 2021] Passing Key To Getting C100DBA Certified Exam Engine PDF

C100DBA Exam Dumps Pass with Updated Oct-2021 Tests Dumps

NEW QUESTION 31
Update If Correct is an approach for which of the following concepts in MongoDB:

  • A. Atomicity
  • B. Performance Management
  • C. Concurrency Control
  • D. Transaction Management

Answer: C

 

NEW QUESTION 32
Which of the following is true about sharding?

  • A. Creating a sharded key automatically creates an index on the collection using that key
  • B. We cannot change a shard key directly/automatically once it is set up
  • 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: B

 

NEW QUESTION 33
What is the maximum size of a MongoDB document

  • A. 12 MB
  • B. 2 MB
  • C. 16 MB
  • D. There is no maximum size. It depends on the RAM.

Answer: C

 

NEW QUESTION 34
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. 04
  • C. 06
  • D. 03

Answer: B

 

NEW QUESTION 35
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. Updates the Title of the post
  • B. Updating a document is possible only with $set
  • C. Syntax error
  • D. Replaces the complete document with _id as 1 with the document specified in second parameter

Answer: D

 

NEW QUESTION 36
As per the aggregation pipeline optimization concepts, if you have a $sort followed by a $match:

  • A. $sort moves before $match
  • B. MongoDB does not do any movements by default and will use the order provided
  • C. Providing these parameters in any order does not impact the performance
  • D. $match moves before $sort

Answer: D

 

NEW QUESTION 37
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: n$city" },pop: { $sum: "$pop" } } }] )
  • C. db.population.aggregate( [{ $group: { _id: { state: "$state", city; "$city" },pop: { $sum: 1 > > >] )
  • D. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $pop: 1 } } }] )

Answer: B

 

NEW QUESTION 38
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.find({},{_id:Of post_text:1})
  • B. db.posts.findOne({post_text: 1})
  • C. db.posts.finOne{},{post_text:l})
  • D. db.posts.finOne({},{_id:0, post_text:1})

Answer: D

 

NEW QUESTION 39
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 secondary with the most current oplog will be elected primary
  • C. reads will be stale until the primary comes back up
  • D. the primary may roll back the operations once it recovers
  • E. the most current secondary will roll back the operations following the election

Answer: B

 

NEW QUESTION 40
You have designed a web application with mongoDB. You have configured replication. The replica set is in place and function properly. What happens in case of failure?

  • A. Failover happens automatically
  • B. Switchover happens automatically
  • C. Switchover needs to be done manually
  • D. Failover needs to be done manually

Answer: A

 

NEW QUESTION 41
When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?

  • A. When the many is very large
  • B. Always
  • C. Never
  • D. When the many is not very large

Answer: D

 

NEW QUESTION 42
In which of the following scenarios is sharding not the correct option. Select all that apply.

  • A. The write operations on the collection are very high
  • B. The working set in the collection is expected to grow very large in size
  • C. The collection is a read intensive collection with less working set
  • D. The write operations on the collection are low

Answer: C,D

 

NEW QUESTION 43
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": {$desc:l>});
  • B. db.posts.createIndex({commerits.$.author":-l});
  • C. db.posts.createIndex({comments.author":-l});

Answer: C

 

NEW QUESTION 44
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. 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.
  • D. db.posts.find({author:"Tom"}.limit($slice:{tags:2>)

Answer: B

 

NEW QUESTION 45
Which of the following commands can cause the database to be locked?

  • A. All of the above
  • B. Map-reduce
  • C. Issuing a query
  • D. Inserting data

Answer: A

 

NEW QUESTION 46
Addding the index {a:l} can potentially decrease the speed of which of the following operations? Check all that apply.

  • A. db.collection.insert( { a:341})
  • B. db.collection.update({b:456>, {$inc: {a:l> })
  • C. db.collection.find( {a : 232} )

Answer: A,B

 

NEW QUESTION 47
What is the on-premise solution having functionality equivalent to cloud manager?

  • A. Journaling
  • B. Service Manager
  • C. Ops Manager
  • D. Replica Manager

Answer: C

 

NEW QUESTION 48
Which are the ONLY ways to project portions of an array?

  • A. $slice
  • B. All of the above
  • C. $ elemMatch
  • D. $

Answer: B

 

NEW QUESTION 49
......

C100DBA exam questions for practice in 2021 Updated 123 Questions: https://www.examslabs.com/MongoDB/MongoDB-Certified-DBA-Associate/best-C100DBA-exam-dumps.html

Updated Premium C100DBA Exam Engine pdf: https://drive.google.com/open?id=1q6k5BhVM0Z_VEpHNcTAUwVZoqB5j7n68