究極のガイド準備で無料MongoDB C100DBA試験問題と解答 [Q33-Q52]

Share

究極のガイド準備で無料MongoDB C100DBA試験問題と解答

合格させるMongoDB C100DBAテストエンジンPDFで完全版無料問題集

質問 33
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( { name : "Big Rig Truck", date : "2013-02-01", manufacturer : "Tanko"
  • B. db.toys.find( { manufacturer : "Matteo", name : "Barbara", date : "2014-07-02" } )
  • C. db.toys.find( { date : "2015-03-01", manufacturer : "Loggo", name : "Brick Set" } )

正解: A,B,C

 

質問 34
What is the equivalent command in MongoDB for the following SQL query?
SELECT * FROM posts WHERE author like "%john%"

  • A. db.posts.find( { $like: {author: /John/} } )
  • B. db.posts.find( { author: {$like: /John/} } )
  • C. db.posts.find( { author: /John/ } )
  • D. db.posts.find( { author: /AjohnA/ > )

正解: C

 

質問 35
'$set' sets the value of

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

正解: B

 

質問 36
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: "$pop" } } }] )
  • B. db.population.aggregate( [{ $group: { _id: { city: "$city" },pop: { $sum: "$pop" } } }] )Multi Document Transaction is not supported by MongoDB
  • C. db.population.aggregate( [{ $group: { _id: { state: Estate", city: "$city" },pop: { $sum: 1 > > >] )
  • D. db.population.aggregate( [{ $group: { _id: { state: "$state", city: "$city" },pop: { $pop: 1 } } }] )

正解: A

 

質問 37
If you have created a compound index on (A,B, C) which of the following access pattern will not be able to utilize the index?

  • A. A
  • B. A, B, C
  • C. A, B
  • D. B, C

正解: D

 

質問 38
Which of the following needs to be performed prior to initiate backup on a sharded cluster?

  • A. db.stopServer( )
  • B. sh.stopServer( )
  • C. db.stopBalancer( )
  • D. sh.stopBalancer( )

正解: D

 

質問 39
Which of the tags in a replica set configuration specify the operations to be read from the node with the least network latency?

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

正解: A

 

質問 40
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. None of the above
  • B. As a covered query using "mylndex" because we are filtering out "_id" and only returning "user.login"
  • C. As an indexed query using "mylndex" because field "user.login" is indexed
  • D. MongoDB will need to do a table/collection scan to find matching documents
  • E. As an optimized sort query (scanAndOrder = false) using "mylndex" because we are sorting on an indexed field

正解: C

 

質問 41
JSON stands for

  • A. None of the above
  • B. JavaScript Object Notice
  • C. JavaScript Object Notation
  • D. JavaScript Object Naming

正解: C

 

質問 42
Write the command(s) are correct to enable sharding on a database "testdb" and shard a collection "testCollection" with _id as shard key.

正解:

解説:
sh.enableSharding("testdb") & sh.shardCollection("testdb.testCollection", {_id : 1 }, true )

 

質問 43
Which of the following node is used during election in a replication cluster?

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

正解: B

 

質問 44
By default, the MongoDB cursor in mongo shell is configured to return how many documents? To get the next set of documents, which command is used?

  • A. 20, it
  • B. 200, more
  • C. No limit, none
  • D. 50, it

正解: A

 

質問 45
Which option should be used to update all the documents with the specified condition in the MongoDB query?

  • A. specify {all: true} as the third parameter of update command
  • B. updateAII instead of update
  • C. specify {multi : true} as the third parameter of update command
  • D. specify {updateAII: true} as the third parameter of update command

正解: C

 

質問 46
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. $match
  • B. $project
  • C. $aggregate
  • D. $group

正解: B

 

質問 47
What is the replication factor for a replicated cluster with 1 primary, 3 secondaries with one of them hidden.
The set also has an arbiter?

  • A. None of the above
  • B. 0
  • C. 1
  • D. 2

正解: B

 

質問 48
The________operator can be used to identify an element in the array to be updated without explicitly specifying the position of the element.

  • A. Updating an array field without knowing its index is not possible.
  • B. $
  • C. $ elemMatch
  • D. $slice

正解: B

 

質問 49
You are in a sharded cluster. What will you do prior to initiating backup in sharded cluster?

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

正解: B

 

質問 50
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. $match
  • B. $sum
  • C. $aggregate
  • D. $group

正解: A

 

質問 51
What is the output of the following program?

  • A. 100 ms
  • B. 60 s
  • C. 1s
  • D. 100 s

正解: B

 

質問 52
......

MongoDB Certified DBA Associate Exam (Based on MongoDB 4.4)練習テスト2022年最新のC100DBAをストレスなしで合格!:https://drive.google.com/open?id=1pAQxTp0h7hoEnRINcAQL7ljUB7dN65-L

オンライン試験練習テストと詳細な解説付き!:https://www.passtest.jp/MongoDB/C100DBA-shiken.html