C100DBA問題集123問でMongoDB Certified DBA Associateを確実実践
リアル最新C100DBA試験問題C100DBA問題集
質問 17
Which of the following commands can cause the database to be locked?
- A. Issuing a query
- B. Inserting data
- C. All of the above
- D. Map-reduce
正解: C
質問 18
Which of the following command is used to get all the indexes on a collection?
- A. db.collection.showIndexes()
- B. db.showIndexes()
- C. db.collection.findlndexes()
- D. db.collection.getlndexesQ
正解: D
質問 19
Which format/standard is used by MongoDB internally to store documents?
- A. BSON
- B. JSON - Extended
- C. JSON
- D. B+ Trees
正解: C
質問 20
What read preference should your application use if you want to read from the primary under normal circumstances but allow reads from secondaries when a primary is unavailable?
- A. Secondary
- B. primary
- C. nearest
- D. primaryPreferred
- E. secondaryPreferred
正解: D
質問 21
The difference between $push and $addToSet is:
- A. $addToSet adds the item to the field only if the new item is of the same datatype
- B. There is no major difference between them. $addToSet is a deprecated version of $push.
- C. $addToSet adds the item to the field only if it does not exist already; while $push pushes the item to the field irrespective of whether it was present or not
- D. $addToSet needs the fields to be already present while $push will work even if the field is not present
正解: C
質問 22
What does the totalKeysExamined field returned by the explain method indicate?
- A. Details the completed execution of the winning plan as a tree of stages
- B. Number of documents scanned
- C. Number of index entries scanned
- D. Number of documents that match the query condition
正解: C
質問 23
A collection and a document in MongoDB is equivalent to which of the SQL concepts respectively?
- A. Table and Row
- B. Column and Row
- C. Database and Table
- D. Table and Column
正解: A
質問 24
Which of the following is true about sharding?
- A. We cannot change a shard key directly/automatically once it is set up
- B. Sharding is enabled at the database level
- C. A sharded environment does not support sorting functionality since the documents lie on various mongod instances
- D. Creating a sharded key automatically creates an index on the collection using that key
正解: A
質問 25
Which of the following does MongoDB use to provide High Scalability?
- A. Replication
- B. Sharding
- C. Write Concern
- D. Indexing
正解: B
質問 26
Consider that the posts collection contains an array called ratings which contains ratings given to the post by various users in the following format:
Which of the following query will return all the documents where the ratings array contains elements that in some combination satisfy the query conditions?
- A. db.inventory.find( { ratings: { ratings: { $gt: 5, $lt: 9 } } } )
- B. db.inventory.find( { ratings: { $elemMatch: { $gt: 3, $lt: 6 }
- C. db.inventory.find( { ratings: { ratings.$: { $gt: 5, $lt: 9 } } } )
- D. db.inventory.find( { ratings: { $elemMatch: { $gte: 3, $lte: 6 } } } )
正解: A
質問 27
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" :: 5, "a": 3, "c" :: 0, "b": 12}
- B. {".Jd" :: 2, "a": 2, "c" :: 0, "b": 1}
- C. { \Jd" :10,"a": 3, "c": 1, "b": 1}
- D. {".Jd" :: 8, "a": 11, "c": 1, "b": 0}
- E. {".Jd" :6, "a": 1, "c" :1, "b" :5}
- F. {".Jd" :: 1, "a": 0, "c" :: 0, "b": 2}
- G. {''_Jd" :7, "a": 8, "c" :1, "b" :7}
- H. { ''\Jd" :9, "a": 17, "c": 1, "b": 1}
- I. {''__id" :3, "a": 4, "c" :0, "b" :14}
- J. {".Jd" :: 4, "a": 5, "c" :: 0, "b": 17}
正解: A,B,C,D,H
質問 28
As per the aggregation pipeline optimization concepts, if you have a $sort followed by a $match:
- A. MongoDB does not do any movements by default and will use the order provided
- B. $match moves before $sort
- C. $sort moves before $match
- D. Providing these parameters in any order does not impact the performance
正解: B
質問 29
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 } , { "$set" : { "_id" : 7 , "c" : 4 > > )
- B. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > , { "justOne" : true > ) / This operation cannot be done with a single query.
- C. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 , { "$unset" : [ "a" , "b" ] } } )
- D. db.sample.update( { "_id" : 3 > , { "_id" : 7 , "c" : 4 > )
正解: C
質問 30
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. db.posts.find({author:"Tom"}.limit({tags: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>)
正解: A
質問 31
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
正解: B
質問 32
JSON stands for
- A. JavaScript Object Notice
- B. JavaScript Object Notation
- C. None of the above
- D. JavaScript Object Naming
正解: B
質問 33
Which of the following is supported by MongoDB?
- A. Journaling
- B. Transaction Management
- C. ACID Transactions
- D. Relationships between Collections (Primary Key Foreign Key)
正解: A
質問 34
You perform the following query on the sayings collection, which has the index
{ quote : "text" }:
Assuming the documents below are in the collection, which ones will the following query return? Check all that apply.
db.sayings.find( { $text : { $search : "fact find" } } )
- A. { _id : 3, quote : "Nobody will ever catch me." }
- B. { _id : 2, quote : "Find out if that fact is correct." }
- C. { _id : 1, quote : "That's a fact, Jack." }
正解: B,C
質問 35
......
C100DBA別格な問題集で最上級の成績にさせるC100DBA問題：https://jp.fast2test.com/C100DBA-premium-file.html
手に入れよう！最新C100DBA認定の有効な試験問題集解答：https://drive.google.com/open?id=1SeuBe7hHFQK7xqq1xLLDo34E6Oj_T9fS