Valid C100DBA Exam Q&A PDF C100DBA Dump is Ready (Updated 123 Questions)
Exam Questions and Answers for C100DBA Study Guide
NEW QUESTION 56
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. {"a":l, "b":{"b":l, "c":"foo", "d":"bar", "e":[l,2,4]}}
- C. { }
- D. {"name":"Fred Flintstone";"occupation":"Miner";"wife":"Wilma"}
Answer: B,C
NEW QUESTION 57
Which of the following collections stores authentication credentials in MongoDB?
- A. system.users
- B. local.users
- C. test.users
- D. users.users
Answer: A
NEW QUESTION 58
Which of the following statements are true about the $match pipeline operator? Check all that apply.
- A. It can be used as many time as needed.
- B. You should use it early as possible in the pipeline
- C. It has a sintax similar to findQ commands.
Answer: A,B,C
NEW QUESTION 59
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 60
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 61
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 62
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( { date : "2015-03-01", manufacturer : "Loggo", name : "Brick Set" } )
- B. db.toys.find( { name : "Big Rig Truck", date : "2013-02-01", manufacturer : "Tanko"
- C. db.toys.find( { manufacturer : "Matteo", name : "Barbara", date : "2014-07-02" } )
Answer: A,B,C
NEW QUESTION 63
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 64
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 65
What is the output of following two commands in MongoDB: db. posts. insert({n_id":l}) db.posts.insert({"_id":l})
- A. It will insert two documents and throw a warning to the user
- B. Two documents will be inserted with _id as 1
- C. This will throw a duplicate key error
- D. MongoDB will automatically increment the _id of the second document as 2
Answer: C
NEW QUESTION 66
What is the maximum size of Index Key Limit and Number of Indexes per collection?
- A. 1024 bytes and 64 indexes
- B. 12 mega bytes and 64 indexes
- C. 64 bytes and 1024 indexes
- D. 1024 bytes and unlimited indexes
Answer: A
NEW QUESTION 67
Which of the following is incorrect statement about find and findOne operations in MongoDB?
- A. findQ returns all the documents in a collection while findOne() retrieves only the first one.
- B. findQ and findOneQ returns cursors to the collection documents
- C. find.limit(l) is not the same query as findOne()
- D. findOneQ returns the actual first document retrieved from a collection
Answer: B
NEW QUESTION 68
JSON stands for
- A. JavaScript Object Notation
- B. JavaScript Object Naming
- C. None of the above
- D. JavaScript Object Notice
Answer: A
NEW QUESTION 69
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 70
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 71
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"}.limit($slice:{tags: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">,{tags:{$slice:2})
Answer: D
NEW QUESTION 72
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. Replaces the complete document with _id as 1 with the document specified in second parameter
- B. Updates the Title of the post
- C. Syntax error
- D. Updating a document is possible only with $set
Answer: A
NEW QUESTION 73
Consider the following document from the products collection:
What does the following query using $elemMatch return? db.products.find( { product_code: "345678" }, { variations: { $elemMatch: { size: ^L^ } } } )
- A. Returns the document but with only one element in the variations array (corresponding to size L)
- B. Returns the complete document but retrieves only the size field from the array
- C. Returns the complete document but retrieves only the size field from the array and also with only one element in the variations array (corresponding to size L)
- D. Returns the complete document since MongoDB does not support partial array retrieval
Answer: A
NEW QUESTION 74
Which format/standard is used by MongoDB internally to store documents?
- A. JSON
- B. B+ Trees
- C. BSON
- D. JSON - Extended
Answer: A
NEW QUESTION 75
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 76
......
Certification dumps - MongoDB Certified DBA Associate C100DBA guides - 100% valid: https://www.crampdf.com/C100DBA-exam-prep-dumps.html
100% Pass Your C100DBA MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4) at First Attempt with CramPDF: https://drive.google.com/open?id=1iq-wyy85qurE9xmyDtrAxGRU3XwTwzwj