[2024] Earn Quick And Easy Success With C100DBA Dumps
Free C100DBA pdf Files With Updated and Accurate Dumps Training
NEW QUESTION # 10
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({^comments.author" :1});
- C. db.posts.createIndex({^commerits.author";-!});
Answer: C
NEW QUESTION # 11
What is the maximum size of Index Key Limit and Number of Indexes per collection?
- A. 12 mega bytes and 64 indexes
- B. 1024 bytes and unlimited indexes
- C. 1024 bytes and 64 indexes
- D. 64 bytes and 1024 indexes
Answer: C
NEW QUESTION # 12
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">,{tags:{$slice:2})
- B. 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. - C. db.posts.find({author:"Tom"}.limit({tags:2})
- D. db.posts.find({author:"Tom"}.limit($slice:{tags:2>)
Answer: A
NEW QUESTION # 13
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. {"a":l, "b":{"b":l, "c":"foo", "d":"bar", "e":[l,2,4]}}
- D. {"name":"Fred Flintstone";"occupation":"Miner";"wife":"Wilma"}
Answer: B,C
NEW QUESTION # 14
What is the equivalent command in MongoDB for the following SQL query?
SELECT * FROM posts WHERE author like "%john%"
- A. db.posts.find( { author: {$like: /John/} } )
- B. db.posts.find( { author: /AjohnA/ > )
- C. db.posts.find( { author: /John/ } )
- D. db.posts.find( { $like: {author: /John/} } )
Answer: C
NEW QUESTION # 15
What is the use of mongodump and mongorestore tools?
- A. backup mongodb deployment
- B. performance tune mongodb deployment
- C. audit mongodb deployment
- D. replicate mongodb deployments
Answer: A
NEW QUESTION # 16
Which option should be used to update all the documents with the specified condition in the MongoDB query?
- A. updateAII instead of update
- B. specify {all: true} as the third parameter of update command
- C. specify {updateAII: true} as the third parameter of update command
- D. specify {multi : true} as the third parameter of update command
Answer: D
NEW QUESTION # 17
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. As an indexed query using "mylndex" because field "user.login" is indexed
- C. MongoDB will need to do a table/collection scan to find matching documents
- D. As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"
- E. None of the above
Answer: B
NEW QUESTION # 18
What is the maximum size of a MongoDB document
- A. 16 MB
- B. There is no maximum size. It depends on the RAM.
- C. 12 MB
- D. 2 MB
Answer: A
NEW QUESTION # 19
Which is the default mode in which the explain() command runs?
- A. customExecutionStats
- B. executionStats
- C. allPlansExecution
- D. queryPlanner
Answer: D
NEW QUESTION # 20
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. oplog.rs
- B. <replicasetid>.oplog.rs
- C. local.oplog.rs
- D. <database>..oplog.rs
Answer: C
NEW QUESTION # 21
Consider the following example document from the sample collection. All documents in this collection have the same schema.
Which of the following queries will replace this with the document.
- A. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > )
- B. db.sample.update( { "_id" : 3 } , { "$set" : { "_id" : 7 , "c" : 4 > > )
- C. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 , { "$unset" : [ "a" , "b" ] } } )
- D. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > , { "justOne" : true > ) / This operation cannot be done with a single query.
Answer: C
NEW QUESTION # 22
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({commerits.$.author":-l});
- B. db.posts.createIndex({comments.author":-l});
- C. db.posts.createIndex({comments.$.author": {$desc:l>});
Answer: B
NEW QUESTION # 23
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 an author, grouped by author
- B. Average of likes on all the posts of an author, grouped by author
- C. Sum of likes on all the posts by all the authors
- D. Number of posts by an author
Answer: A
NEW QUESTION # 24
Which of the following aggregation commands in MongoDB does not support sharded collections?
- A. mapReduce
- B. group
- C. aggregate
- D. All of the above
Answer: B
NEW QUESTION # 25
Below is a sample document of "orders" collection
Answer:
Explanation:
$project
NEW QUESTION # 26
'$set' sets the value of
- A. Code block
- B. Key
- C. None of the above
- D. Name/value pair
Answer: B
NEW QUESTION # 27
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 complete document since MongoDB does not support partial array retrieval
- 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 document but with only one element in the variations array (corresponding to size L)
Answer: D
NEW QUESTION # 28
In which of the following scenarios is sharding not the correct option. Select all that apply.
- A. The collection is a read intensive collection with less working set
- B. The working set in the collection is expected to grow very large in size
- C. The write operations on the collection are very high
- D. The write operations on the collection are low
Answer: A,D
NEW QUESTION # 29
Which format/standard is used by MongoDB internally to store documents?
- A. JSON - Extended
- B. JSON
- C. B+ Trees
- D. BSON
Answer: B
NEW QUESTION # 30
Which mongodb tool is used to report details on number of database operations in MongoDB?
- A. mongotop
- B. mongorestore
- C. mongodump
- D. mongostat
Answer: D
NEW QUESTION # 31
You perform the following operation in the shell: db.foo.insert( { } ); What gets inserted?
- A. No document will be inserted; an error will be raised
- B. A document that matches the collection's existing schema, but with null fields
- C. A document will be inserted with the same _id as the last document inserted
- D. An empty document
- E. A document with an _id assigned to be an Objectld
Answer: E
NEW QUESTION # 32
Consider the following document:
> db.c.find()
{ "_id" : 12, b : [ 3, 5, 7, 2, 1, -4, 3, 12 ] }
Which of the following queries on the "c" collection will return only the first five elements of the array in the
"b"
field? E.g.,
Document you want returned by your query:
{ "_id" : 12, "b" : [ 3, 5, 7, 2, 1 ] >
- A. db.c.find( { > , { b : { $substr[ 0 , 5 ] > > )
- B. db.c.find( { > , { b : [ 0, 1, 2, 3, 4, 5 ] > )
- C. db.c.find( { b : [ 0 , 5 ] > )
- D. db.c.find( { > , { b : [ 0 , 5 ] > )
- E. db.c.find( { > , { b : { $slice : [ 0 , 5 ] } } )
Answer: E
NEW QUESTION # 33
MongoDB is a schema-less design.
- A. False
- B. True
Answer: B
NEW QUESTION # 34
......
Real Updated C100DBA Questions Pass Your Exam Easily: https://www.examcollectionpass.com/MongoDB/C100DBA-practice-exam-dumps.html
Top-Class C100DBA Question Answers Study Guide: https://drive.google.com/open?id=17rH4iiGrOWvHgN9cskGU6ANlc6PbFz-m