Free C100DBA Questions for MongoDB C100DBA Exam [May-2024]
Validate your C100DBA Exam Preparation with C100DBA Practice Test (Online & Offline)
NEW QUESTION # 53
Which operations add new documents to a collection?
- A. Create
- B. insert
- C. update
- D. delete
Answer: A,B
NEW QUESTION # 54
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 # 55
Below is a sample document of "orders" collection
Answer:
Explanation:
$sort
NEW QUESTION # 56
You are in a sharded cluster. What will you do prior to initiating backup in sharded cluster?
- A. sh.stopBalancer()
- B. sh.stopserverQ
- C. db.stopserver()
- D. db.stopBalancer()
Answer: A
NEW QUESTION # 57
Which of the following are valid json documents? Select all that apply.
- A. {"city":"New York", "population", 7999034, boros:{"queens", "manhattan", "staten island", "the bronx", u "brooklyn"}}
- B. { }
- C. {"name":"Fred Flintstone";"occupation":"Miner";"wife":"Wilma"}
- D. {"a":l, "b":{"b":l, "c":"foo", "d":"bar", "e":[l,2,4]}}
Answer: B,D
NEW QUESTION # 58
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":-l});
- B. db.posts.createIndex({commerits.$.author":-l});
- C. db.posts.createIndex({comments.$.author": {$desc:l>});
Answer: A
NEW QUESTION # 59
In what format does mongodump creates backup files?
- A. JSON
- B. SOAP
- C. XML
- D. BSON
Answer: D
NEW QUESTION # 60
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?
- A. secondaryPreferred
- B. netLatency
- C. nearest
- D. primaryPreferred
Answer: C
NEW QUESTION # 61
Which of the following command is used to get all the indexes on a collection?
- A. db.collection.getlndexesQ
- B. db.collection.showIndexes()
- C. db.collection.findlndexes()
- D. db.showIndexes()
Answer: A
NEW QUESTION # 62
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. $aggregate
- B. $match
- C. $sum
- D. $group
Answer: B
NEW QUESTION # 63
In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?
- A. individual language drivers
- B. mongod
- C. mongo shell
- D. mongos
Answer: A
NEW QUESTION # 64
MongoDB is a schema-less design.
- A. True
- B. False
Answer: A
NEW QUESTION # 65
Which of the following does MongoDB use to provide High Availability and fault tolerance?
- A. Replication
- B. Sharding
- C. Write Concern
- D. Indexing
Answer: A
NEW QUESTION # 66
Which is the correct order (lowest to highest) in which MongoDB compares the BSON types?
- A. Number, Null, String and Object
- B. Null, Number, Object and String
- C. Null, Number, String and Object
- D. String, Null, Number and Object
Answer: C
NEW QUESTION # 67
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. $arrayLimit
- C. None of the above
- D. $push along with $each, $sort and $slice
Answer: D
NEW QUESTION # 68
The MongoDB explain() method does not support which of the following verbosity mode:
- A. allPlansExecution
- B. executionStats
- C. customExecutionStats
- D. queryPlanner
Answer: B
NEW QUESTION # 69
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( { tags : ["tutorial"] } );
- B. db.posts.find( { tags : "tutorial" } );
- C. db.posts.find( { $array : {tags: "tutorial") > );
- D. db.posts.findInArray( { tags : "tutorial" > );
Answer: B
NEW QUESTION # 70
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 indexed query using "mylndex" because field "user.login" is indexed
- B. As an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an indexed field
- C. MongoDB will need to do a table/collection scan to find matching documents
- D. None of the above
- E. As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"
Answer: A
NEW QUESTION # 71
Below is a sample document of "orders" collection
- A. $sort
Answer: A
NEW QUESTION # 72
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 # 73
The difference between $push and $addToSet is:
- A. $addToSet needs the fields to be already present while $push will work even if the field is not present
- B. There is no major difference between them. $addToSet is a deprecated version of $push.
- C. $addToSet adds the item to the field only if it does not exist already; while $push pushes the item to the field irrespective of whether it was present or not
- D. $addToSet adds the item to the field only if the new item is of the same datatype
Answer: C
NEW QUESTION # 74
Consider the following documents:
You perform the following query;
How many documents will be updated by the query?
- A. 0
- B. 1
- C. 2
- D. 3
- E. 4
Answer: C
NEW QUESTION # 75
Which of the following collections stores authentication credentials in MongoDB?
- A. test.users
- B. local.users
- C. system.users
- D. users.users
Answer: C
NEW QUESTION # 76
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: /AjohnA/ > )
- D. db.posts.find( { author: {$like: /John/} } )
Answer: A
NEW QUESTION # 77
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 # 78
......
Check Real MongoDB C100DBA Exam Question for Free (2024): https://certkingdom.practicedump.com/C100DBA-practice-dumps.html