Master 2023 Latest The Questions MongoDB Certified DBA Associate and Pass C100DBA Real Exam!
Penetration testers simulate C100DBA exam PDF
NEW QUESTION # 35
Which are the ONLY ways to project portions of an array?
- A. All of the above
- B. $
- C. $slice
- D. $ elemMatch
Answer: A
NEW QUESTION # 36
The MongoDB explain() method does not support which of the following verbosity mode:
- A. queryPlanner
- B. allPlansExecution
- C. customExecutionStats
- D. executionStats
Answer: C
NEW QUESTION # 37
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( { c: 1, d : 1 } )
- C. db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )
- D. db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
Answer: A,B
NEW QUESTION # 38
Which node in a replica set does accept write operation?
- A. primary
- B. arbiter
- C. secondary
- D. hidden
Answer: A
NEW QUESTION # 39
You have the following index on the toys collection:
{
"manufacturer" : 1,
"name" : 1,
"date" : -1
}
Which of the following is able to use the index for the query? Check all that apply.
- A. db.toys.find( { manufacturer : "Matteo", name : "Barbara", date : "2014-07-02" } )
- B. db.toys.find( { name : "Big Rig Truck", date : "2013-02-01", manufacturer : "Tanko"
- C. db.toys.find( { date : "2015-03-01", manufacturer : "Loggo", name : "Brick Set" } )
Answer: A,B,C
NEW QUESTION # 40
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 # 41
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. Joins
- C. Multi-statement transactions
Answer: B,C
NEW QUESTION # 42
Which of the following command is used to get all the indexes on a collection?
- A. db.collection.getlndexesQ
- B. db.collection.findlndexes()
- C. db.collection.showIndexes()
- D. db.showIndexes()
Answer: A
NEW QUESTION # 43
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. netLatency
- C. secondaryPreferred
- D. nearest
Answer: D
NEW QUESTION # 44
In a collection that contains 100 post documents, what does the following command do? db. posts.
find().skip(5).limit(5)
- A. Limits the first five documents and then return them in reverse order
- B. Skip and limit nullify each other. Hence returning the first five documents
- C. Skips the first five documents and returns the sixth document five times
- D. Skips the first five documents and returns the next five
Answer: D
NEW QUESTION # 45
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 # 46
What is the first task that a secondary would perform on being prompted by another secondary for an election?
- A. Vote for the first secondary so that it would become the next primary
- B. Start the election process for primary
- C. Connect to primary to confirm its availability
- D. Vote for itself and then call for election
Answer: C
NEW QUESTION # 47
In what format does mongodump creates backup files?
- A. SOAP
- B. BSON
- C. XML
- D. JSON
Answer: B
NEW QUESTION # 48
Which of the following node is used during election in a replication cluster?
- A. primary
- B. arbiter
- C. secondary
- D. hidden
Answer: B
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: { $sum: 1 > > >] )
- B. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: "$pop" } } }] )
- C. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
- D. db.population.aggregate( [{ $group: { _id: { state: "$state", city: "$city" },pop: { $pop: 1 } } }] )
Answer: B
NEW QUESTION # 50
Which of the following commands can cause the database to be locked?
- A. All of the above
- B. Map-reduce
- C. Inserting data
- D. Issuing a query
Answer: A
NEW QUESTION # 51
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 # 52
Which of the following aggregate commands in MongoDB uses a pipeline approach with the goals of improving the aggregation performance?
- A. All of the above
- B. mapReduce
- C. group
- D. aggregate
Answer: D
NEW QUESTION # 53
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. $match
- C. $project
- D. $group
Answer: C
NEW QUESTION # 54
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 : 1, quote : "That's a fact, Jack." }
- C. { _id : 2, quote : "Find out if that fact is correct." }
Answer: B,C
NEW QUESTION # 55
Which of the following about Capped Collections is correct?
- A. High-throughput operations that insert and retrieve documents based on insertion order
- B. If the allocated space for a capped collection exceeds, it stops inserting new documents
- C. Fixed Size
- D. Only "Fixed Size" and "High-throughput operations that insert and retrieve documents based on insertion order"
Answer: D
NEW QUESTION # 56
Which operations add new documents to a collection?
- A. Create
- B. update
- C. insert
- D. delete
Answer: A,C
NEW QUESTION # 57
......
Penetration testers simulate C100DBA exam: https://www.examsreviews.com/C100DBA-pass4sure-exam-review.html
Bestselling On-The-Job Reference Exam Questions: https://drive.google.com/open?id=1EBke_f3VAZJ9DBniYFLyie-dg4csoEzb