Real Exam Questions C100DBA Dumps Exam Questions in here [Sep-2021]
Get Latest Sep-2021 Conduct effective penetration tests using C100DBA
NEW QUESTION 22
Which node in a replica set does accept write operation?
- A. secondary
- B. arbiter
- C. hidden
- D. primary
Answer: D
NEW QUESTION 23
Which of the following about Capped Collections is correct?
- A. Fixed Size
- B. Only "Fixed Size" and "High-throughput operations that insert and retrieve documents based on insertion order"
- C. If the allocated space for a capped collection exceeds, it stops inserting new documents
- D. High-throughput operations that insert and retrieve documents based on insertion order
Answer: B
NEW QUESTION 24
MongoDB is a schema-less design.
- A. True
- B. False
Answer: A
NEW QUESTION 25
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. primaryPreferred
- B. primary
- C. nearest
- D. Secondary
- E. secondaryPreferred
Answer: A
NEW QUESTION 26
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({comments.author":-l});
- C. db.posts.createIndex({commerits.$.author":-l});
Answer: B
NEW QUESTION 27
Which of the following index would be optimum for the query?
Select all valid. db.test.find( { a : 5, c : 2 })
- A. db.test.ensurelndex( { c:l, a: 1})
- B. db.test.ensurelndex( { a: 1, b :1, c:l, d:l})
- C. db.test.ensurelndex( { a : 1, c: 1, d: 1, b : 1})
- D. CH db.test.ensurelndex( { a :1, c:l})
Answer: C,D
NEW QUESTION 28
Mongodb does provide high availability via which option?
- A. Indexing
- B. Sharding
- C. Replication
- D. Journaling
Answer: C
NEW QUESTION 29
What does the totalKeysExamined field returned by the explain method indicate?
- A. Number of index entries scanned
- B. Number of documents that match the query condition
- C. Details the completed execution of the winning plan as a tree of stages
- D. Number of documents scanned
Answer: A
NEW QUESTION 30
Which features of relational database management systems were deliberately omitted in MongoDB and help us to obtain horizontal scalability? Check all that apply.
- A. Authentication
- B. Multi-statement transactions
- C. Joins
Answer: B,C
NEW QUESTION 31
Which of the following operator can be used to limit the number of documents in an array field of a document after an update is performed?
- A. $removeFromSet
- B. $push along with $each, $sort and $slice
- C. $arrayLimit
- D. None of the above
Answer: B
NEW QUESTION 32
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 protect agains network partitions
- D. To enable certain read preference settings
- E. To add greather redundancy
Answer: C
NEW QUESTION 33
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. $sum
- B. $aggregate
- C. $match
- D. $group
Answer: C
NEW QUESTION 34
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: { $pop: 1 } } }] )
- 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: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
Answer: C
NEW QUESTION 35
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( { $like: {author: /John/} } )
- C. db.posts.find( { author: {$like: /John/} } )
- D. db.posts.find( { author: /AjohnA/ > )
Answer: A
NEW QUESTION 36
To add a new user and enable authentication in MongoDB, which of the following steps need be executed?
- A. update users collection and restart mongodb
- B. update users collection and run db.enableAuthenticationQ
- C. All of the above
- D. update users collection and restart mongodb with -auth option
Answer: D
NEW QUESTION 37
Which mongodb tools allow us to work with our data in a human readable format?
- A. mongodump
- B. mongostat
- C. mongoimport
- D. mongoexport
Answer: C,D
NEW QUESTION 38
The following aggregation option is used to specify the specific fields that needs to be passed to the next stage of the aggregation pipeline:
- A. $aggregate
- B. $group
- C. $project
- D. $match
Answer: C
NEW QUESTION 39
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 30000 documents after scanning the documents
- B. The query used an index to fetch the results
- C. None of the above
- D. The query returned 0 documents
Answer: B
NEW QUESTION 40
Aggregation Pipelines have a limit of:
- A. 16 MB document and 100 MB RAM
- B. No limit on document and 100 MB RAM
- C. 2 MB document and 100 MB RAM
- D. 2 MB document and no limit on RAM
Answer: A
NEW QUESTION 41
......
Authentic Best resources for C100DBA Online Practice Exam: https://www.passsureexam.com/C100DBA-pass4sure-exam-dumps.html
Get the superior quality C100DBA Dumps with explanations waiting just for you, get it now: https://drive.google.com/open?id=1Vc7ZWbvmiZGWO1elXMIEXkA1efij4LAY