[2024年04月] 最新のMongoDB Certified DBA Associate C100DBA試験解答豪華セット問題集 [Q52-Q75]

Share

[2024年04月] 最新のMongoDB Certified DBA Associate C100DBA試験解答豪華セット問題集

MongoDBコンテンツをマスターしてC100DBA試験合格保証つき問題集!

質問 # 52
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: /AjohnA/ > )
  • D. db.posts.find( { author: /John/ } )

正解:D


質問 # 53
In a sharded replica set environment, the w Option provides ability for write concern and j Option provides ability for the data to be written on disk journal. Consider that we have a seven member replica set and we want to assure that the writes are committed to journal. What should be the value of j?

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

正解:D


質問 # 54
Which are the ONLY ways to project portions of an array?

  • A. $
  • B. All of the above
  • C. $slice
  • D. $ elemMatch

正解:B


質問 # 55
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">,{tags:{$slice: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"}.limit($slice:{tags:2})

正解:B


質問 # 56
Which of the following statements are true about the $match pipeline operator? Check all that apply.

  • A. It has a sintax similar to findQ commands.
  • B. You should use it early as possible in the pipeline
  • C. It can be used as many time as needed.

正解:A、B、C


質問 # 57
Which format/standard is used by MongoDB internally to store documents?

  • A. JSON - Extended
  • B. B+ Trees
  • C. JSON
  • D. BSON

正解:C


質問 # 58
Which of the following is correct about MongoDB?

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

正解:A


質問 # 59
Which of the following about Capped Collections is correct?

  • A. Only "Fixed Size" and "High-throughput operations that insert and retrieve documents based on insertion order"
  • B. If the allocated space for a capped collection exceeds, it stops inserting new documents
  • C. Fixed Size
  • D. High-throughput operations that insert and retrieve documents based on insertion order

正解:A


質問 # 60
Which is the default mode in which the explain() command runs?

  • A. customExecutionStats
  • B. allPlansExecution
  • C. executionStats
  • D. queryPlanner

正解:D


質問 # 61
You are comparing values of different BSON types in mongodb. You want to compare from lowest to highest.
Which comparison order is used?

  • A. Objec^Array^inData,Symbol, String,MinKey, Null, Numbers
  • B. Object/Array^inData/Symbol,MinKey, Null, Numbers,String
  • C. MinKey, Null, Numbers,Object,Array,BinData,Symbol, String
  • D. MinKey, Null, Numbers,Symbol, String,Object,Array,BinData

正解:D


質問 # 62
In a sharded replicas set environment with multiple mongos servers, which of the following would decide the mongos failover?

  • A. mongo shell
  • B. mongos
  • C. mongod
  • D. individual language drivers

正解:D


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

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

正解:A


質問 # 64
Which of the following operators is used to updated a document partially?

  • A. $project
  • B. $set
  • C. $update
  • D. $modify

正解:B


質問 # 65
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


質問 # 66
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" :6, "a": 1, "c" :1, "b" :5}
  • B. {''__id" :3, "a": 4, "c" :0, "b" :14}
  • C. { ''\Jd" :9, "a": 17, "c": 1, "b": 1}
  • D. {".Jd" :: 1, "a": 0, "c" :: 0, "b": 2}
  • E. {".Jd" :: 2, "a": 2, "c" :: 0, "b": 1}
  • F. {''_Jd" :7, "a": 8, "c" :1, "b" :7}
  • G. {".Jd" :: 4, "a": 5, "c" :: 0, "b": 17}
  • H. {".Jd" :: 5, "a": 3, "c" :: 0, "b": 12}
  • I. { \Jd" :10,"a": 3, "c": 1, "b": 1}
  • J. {".Jd" :: 8, "a": 11, "c": 1, "b": 0}

正解:C、E、H、I、J


質問 # 67
Which of the following are valid json documents? Select all that apply.

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

正解:A、C


質問 # 68
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" :1});
  • B. db.posts.createIndex({^comments.$.author":-l});
  • C. db.posts.createIndex({^commerits.author";-!});

正解:C


質問 # 69
When should we consider representing a one-to-many relationship in an embedded collection instead of separate collection?

  • A. When the many is very large
  • B. When the many is not very large
  • C. Always
  • D. Never

正解:B


質問 # 70
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. 0
  • B. 1
  • C. 2
  • D. None of the above

正解:C


質問 # 71
Which of the following is incorrect statement about find and findOne operations in MongoDB?

  • A. findOneQ returns the actual first document retrieved from a collection
  • B. find.limit(l) is not the same query as findOne()
  • C. findQ and findOneQ returns cursors to the collection documents
  • D. findQ returns all the documents in a collection while findOne() retrieves only the first one.

正解:C


質問 # 72
Dada una coleccion, cuales devuelve con la siguiente query db.coleccion.find({nombre:"ruben",apellido:"gomez"},{nombre:l,apellido:l,aficion:l});

  • A. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "Luis", "apellido" : "gomez", "aficion" : u "flipar" }
  • B. { "-id" : Objectld("580a42b5dfblb5al7427d302"), "nombre" : "ruben", "apellido" : "gomez", "aficion" : v u "flipar" }
  • C. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "gomez" >
  • D. { "_id" : Objectld("580a42acdfblb5al7427d301"), "nombre" : "ruben", "apellido" : "Pablo" , "aficion" : u "flipar"}

正解:B、C


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

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

正解:D


質問 # 74
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

正解:C


質問 # 75
......

あなたを合格させるMongoDB C100DBA試験専門問題集はここにある:https://www.passtest.jp/MongoDB/C100DBA-shiken.html

最新MongoDB Certified DBA Associate C100DBA練習テストに最速準備問題をゲットせよ:https://drive.google.com/open?id=1pAQxTp0h7hoEnRINcAQL7ljUB7dN65-L