[Aug-2021] Dumps Brief Outline Of The C100DBA Exam - SureTorrent
C100DBA Training & Certification Get Latest MongoDB Certified DBA Associate
NEW QUESTION 36
Below is a sample document in a given collection test.
{ a : 5, b : 3, c: 2, d : 1 >
Given a compound index { a: 1, b:l, c:l, d:l}, Which of the below query will not use in-memory sorting? Select all valid.
- A. db.test.find( { a: 5, b: 3 } ).sort( {c: 1 } )
- B. db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
- C. db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )
- D. db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )
Answer: A,C
NEW QUESTION 37
When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?
- A. Always
- B. When the many is not very large
- C. When the many is very large
- D. Never
Answer: B
NEW QUESTION 38
Which of the following is correct about MongoDB?
- A. MongoDB uses JSON format to represent documents
- B. MongoDB supports some of the SQL functions
- C. MongoDB supports geospatial indexes
- D. MongoDB supports collection joins
Answer: C
NEW QUESTION 39
In which of the following scenarios is sharding not the correct option. Select all that apply.
- A. The write operations on the collection are low
- B. The write operations on the collection are very high
- C. The collection is a read intensive collection with less working set
- D. The working set in the collection is expected to grow very large in size
Answer: A,C
NEW QUESTION 40
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?
- A. primaryPreferred
- B. nearest
- C. netLatency
- D. secondaryPreferred
Answer: B
NEW QUESTION 41
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 42
MongoDB is a schema-less design.
- A. True
- B. False
Answer: A
NEW QUESTION 43
Consider the following example document:
{
"_id": Objectld("5360c0a0a655a60674680bbe"),
"user"
"login": "irOn"
"description": "Made of steel"
"date": ISODate("2014-04-30T09:16:45.836Z"),
}
>
and index creation command:
db.users.createlndex( { "user.login": 1, "user.date": -1 }, "mylndex" ) When performing the following query:
db.users.find( { "user.login": /Air.*/ },
{ "user":1, "_id":0 > ).sort( { "user.date":1 > )
which of the following statements correctly describe how MongoDB will handle the query? Check all that apply.
- A. As an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an indexed field
- B. MongoDB will need to do a table/collection scan to find matching documents
- C. As an indexed query using "mylndex" because field "user.login" is indexed
- D. As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"
- E. None of the above
Answer: C
NEW QUESTION 44
You perform the following query on the sayings collection, which has the index
{ quote : "text" }:
Assuming the documents below are in the collection, which ones will the following query return? Check all that apply.
db.sayings.find( { $text : { $search : "fact find" } } )
- A. { _id : 3, quote : "Nobody will ever catch me." }
- B. { _id : 2, quote : "Find out if that fact is correct." }
- C. { _id : 1, quote : "That's a fact, Jack." }
Answer: B,C
NEW QUESTION 45
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 46
In mongodb how do you update a document partially?
- A. $set
- B. $project
- C. $update
- D. $modify
Answer: A
NEW QUESTION 47
Which option should be used to update all the documents with the specified condition in the MongoDB query?
- A. specify {updateAII: true} as the third parameter of update command
- B. updateAII instead of update
- C. specify {all: true} as the third parameter of update command
- D. specify {multi : true} as the third parameter of update command
Answer: D
NEW QUESTION 48
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. <replicasetid>.oplog.rs
- B. oplog.rs
- C. <database>..oplog.rs
- D. local.oplog.rs
Answer: D
NEW QUESTION 49
What does the output x of the following MongoDB aggregation query result into; db.posts.aggregate( [ {
$group: { _id; "$author", x: { $sum: $likes } } } ] )
- A. Sum of likes on all the posts by all the authors
- B. Average of likes on all the posts of an author, grouped by author
- C. Sum of likes on all the posts by an author, grouped by author
- D. Number of posts by an author
Answer: C
NEW QUESTION 50
Which is the correct order (lowest to highest) in which MongoDB compares the BSON types?
- A. Null, Number, Object and String
- B. Null, Number, String and Object
- C. String, Null, Number and Object
- D. Number, Null, String and Object
Answer: B
NEW QUESTION 51
What tool would you use if you want to save a gif file in mongo?
Answer:
Explanation:
mongofile
NEW QUESTION 52
Which of the following is true of the mechanics of replication in MongoDB? Check all that apply.
- A. Members of a replica set may replicate data from any other data-bearing member of the set by default
- B. Operations on the primary are recorded in a capped collection called the oplog
- C. Clients read from the nearest member of a replica ser by default
Answer: B
NEW QUESTION 53
A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?
- A. Column and Row
- B. Database and Table
- C. Table and Column
- D. Table and Row
Answer: D
NEW QUESTION 54
What is the defau size of a GridFS chunk?
- A. 2 MB
- B. 255 K
- C. 1 MB
- D. 16 MB
Answer: B
NEW QUESTION 55
Update If Correct is an approach for which of the following concepts in MongoDB:
- A. Transaction Management
- B. Performance Management
- C. Concurrency Control
- D. Atomicity
Answer: C
NEW QUESTION 56
Which is the default mode in which the explain() command runs?
- A. executionStats
- B. customExecutionStats
- C. queryPlanner
- D. allPlansExecution
Answer: C
NEW QUESTION 57
In a replica set, a_________number of members ensures that the replica set is always able to select a primary.
- A. Odd
- B. 0
- C. Even
- D. Depends on the application architecture
Answer: A
NEW QUESTION 58
......
Certification Training for C100DBA Exam Dumps Test Engine: https://www.suretorrent.com/C100DBA-exam-guide-torrent.html
MongoDB Certified DBA Associate C100DBA Real Exam Questions and Answers FREE Updated: https://drive.google.com/open?id=1icHKW3qZ2xw8BHYBp57wGStHWvIKzd7Z