[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