Exam Questions Answers Braindumps C100DBA Exam Dumps PDF Questions [Q51-Q70]

Share

Exam Questions Answers Braindumps C100DBA Exam Dumps PDF Questions

Download Free MongoDB C100DBA Real Exam Questions

NEW QUESTION 51
Which mongodb tool is used to report details on number of database operations in MongoDB?

  • A. mongotop
  • B. mongorestore
  • C. mongostat
  • D. mongodump

Answer: C

 

NEW QUESTION 52
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( { a: 1} )
  • B. db.test.find( { a: 5, b: 3 } ).sort( {c: 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( { c: 1, d : 1 } )

Answer: B,D

 

NEW QUESTION 53
Which of the documents below will be retrieved by the following query? Assume the documents are stored in a collection called "sample". Check all that apply.
db.sample.find( { "$or" : [ { "a" : { "$in" : [ 3, 10] > }, { "b" : { "$lt" : 2 > > ] > )

  • A. {".Jd" :: 8, "a": 11, "c": 1, "b": 0}
  • B. {".Jd" :: 2, "a": 2, "c" :: 0, "b": 1}
  • C. { \Jd" :10,"a": 3, "c": 1, "b": 1}
  • D. {".Jd" :6, "a": 1, "c" :1, "b" :5}
  • E. { ''\Jd" :9, "a": 17, "c": 1, "b": 1}
  • F. {".Jd" :: 1, "a": 0, "c" :: 0, "b": 2}
  • G. {".Jd" :: 5, "a": 3, "c" :: 0, "b": 12}
  • H. {''__id" :3, "a": 4, "c" :0, "b" :14}
  • I. {''_Jd" :7, "a": 8, "c" :1, "b" :7}
  • J. {".Jd" :: 4, "a": 5, "c" :: 0, "b": 17}

Answer: A,B,C,E,G

 

NEW QUESTION 54
Update If Correct is an approach for which of the following concepts in MongoDB:

  • A. Performance Management
  • B. Transaction Management
  • C. Atomicity
  • D. Concurrency Control

Answer: D

 

NEW QUESTION 55
Which of the following is correct about MongoDB?

  • A. MongoDB supports collection joins
  • B. MongoDB supports some of the SQL functions
  • C. MongoDB supports geospatial indexes
  • D. MongoDB uses JSON format to represent documents

Answer: C

 

NEW QUESTION 56
You are in a sharded cluster. What will you do prior to initiating backup in sharded cluster?

  • A. db.stopserver()
  • B. sh.stopBalancer()
  • C. sh.stopserverQ
  • D. db.stopBalancer()

Answer: B

 

NEW QUESTION 57
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: /John/ } )
  • C. db.posts.find( { $like: {author: /John/} } )
  • D. db.posts.find( { author: /AjohnA/ > )

Answer: B

 

NEW QUESTION 58
What does the following aggregate query perform?

  • A. Groups the posts by number of likes (101, 102, 103.) by adding 1 every time
  • B. Calculates the number of posts with likes between 100 and 200
  • C. Fetches the posts with likes between 100 and 200, sets the _id of the first document as null and then increments it 1 every time
  • D. Fetches the posts with likes between 100 and 200 and sets their _id as null

Answer: B

 

NEW QUESTION 59
Which of the following are valid json documents? Select all that apply.

  • A. {"a":l, "b":{"b":l, "c":"foo", "d":"bar", "e":[l,2,4]}}
  • B. {"city":"New York", "population", 7999034, boros:{"queens", "manhattan", "staten island", "the bronx", u "brooklyn"}}
  • C. {"name":"Fred Flintstone";"occupation":"Miner";"wife":"Wilma"}
  • D. { }

Answer: A,D

 

NEW QUESTION 60
Which command is used to determine storage capacity of specific database?

  • A. mongotop
  • B. mongostat
  • C. dbstats
  • D. constats

Answer: C

 

NEW QUESTION 61
'$set' sets the value of

  • A. None of the above
  • B. Code block
  • C. Name/value pair
  • D. Key

Answer: D

 

NEW QUESTION 62
Which of the following index would be optimum for the query?
Select all valid. db.test.find( { a : 5, c : 2 })

  • A. db.test.ensurelndex( { a: 1, b :1, c:l, d:l})
  • B. CH db.test.ensurelndex( { a :1, c:l})
  • C. db.test.ensurelndex( { a : 1, c: 1, d: 1, b : 1})
  • D. db.test.ensurelndex( { c:l, a: 1})

Answer: B,C

 

NEW QUESTION 63
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?

  • A. netLatency
  • B. nearest
  • C. primaryPreferred
  • D. secondaryPreferred

Answer: B

 

NEW QUESTION 64
Which features of relational database management systems were deliberately omitted in MongoDB and help us to obtain horizontal scalability? Check all that apply.

  • A. Multi-statement transactions
  • B. Joins
  • C. Authentication

Answer: A,B

 

NEW QUESTION 65
Which of the following node is used during election in a replication cluster?

  • A. secondary
  • B. primary
  • C. arbiter
  • D. hidden

Answer: C

 

NEW QUESTION 66
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 67
To add a new user and enable authentication in MongoDB, which of the following steps need be executed?

  • A. All of the above
  • B. update users collection and run db.enableAuthenticationQ
  • C. update users collection and restart mongodb with -auth option
  • D. update users collection and restart mongodb

Answer: C

 

NEW QUESTION 68
Suposse tou have the following collection with only 2 documents:

If you run an aggregation query and use { $unwind: "$traits" } as the first stage, how many documents will be passed to the next stage of the aggregation pipeline?

  • A. 0
  • B. 1
  • C. 2
  • D. 3
  • E. 4

Answer: D

 

NEW QUESTION 69
Which operations add new documents to a collection?

  • A. delete
  • B. Create
  • C. insert
  • D. update

Answer: B,C

 

NEW QUESTION 70
......

Latest MongoDB C100DBA Real Exam Dumps PDF: https://www.newpassleader.com/MongoDB/C100DBA-exam-preparation-materials.html

C100DBA Exam Dumps, C100DBA Practice Test Questions: https://drive.google.com/open?id=1mphsRYDp5n-Th7FpwKj_yploKsUNfnKL