[2024年09月02日] 無料MongoDB Certified DBA Associate C100DBA公式認定ガイドPDFダウンロード
MongoDB C100DBA公式認定ガイドPDF
MongoDB C100DBA試験でカバーされるトピックには、MongoDBアーキテクチャ、データモデリング、インデックス作成、レプリケーション、シャーディング、セキュリティ、バックアップとリカバリ、およびパフォーマンスチューニングが含まれます。この試験は、データベースの管理における候補者の実践的なスキルをテストするために設計されており、一般的な問題のトラブルシューティング能力やデータベースのパフォーマンスを最適化する能力を含みます。
質問 # 36
If the value of totalKeysExamined is 30000 and the value of totalDocsExamined is 0, which of the following option is correct?
- A. The query used an index to fetch the results
- B. The query returned 0 documents
- C. The query returned 30000 documents after scanning the documents
- D. None of the above
正解:A
質問 # 37
Which is the correct order (lowest to highest) in which MongoDB compares the BSON types?
- A. Null, Number, Object and String
- B. Number, Null, String and Object
- C. String, Null, Number and Object
- D. Null, Number, String and Object
正解:D
質問 # 38
Which of the following node is used during election in a replication cluster?
- A. secondary
- B. primary
- C. arbiter
- D. hidden
正解:C
質問 # 39
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
正解:A
質問 # 40
Which is the default mode in which the explain() command runs?
- A. allPlansExecution
- B. queryPlanner
- C. executionStats
- D. customExecutionStats
正解:B
質問 # 41
What is the first task that a secondary would perform on being prompted by another secondary for an election?
- A. Vote for the first secondary so that it would become the next primary
- B. Start the election process for primary
- C. Connect to primary to confirm its availability
- D. Vote for itself and then call for election
正解:C
質問 # 42
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
正解:A
質問 # 43
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" : 7, "a" : 8, "c" : 1, "b" : 7}
- B. {". Jd" : 6, "a" : 1, "c" : 1, "b" : 5}
- C. {". Jd" : : 5, "a" : 3, "c" : : 0, "b" : 12}
- D. {". Jd" : : 2, "a" : 2, "c" : : 0, "b" : 1}
- E. {". Jd" : : 8, "a" : 11, "c" : 1, "b" : 0}
- F. {". Jd" : : 4, "a" : 5, "c" : : 0, "b" : 17}
- G. {". Jd" : : 1, "a" : 0, "c" : : 0, "b" : 2}
- H. {''_ _id" : 3, "a" : 4, "c" : 0, "b" : 14}
- I. { \ Jd" : 10,"a" : 3, "c" : 1, "b" : 1}
- J. { ''\ Jd" : 9, "a" : 17, "c" : 1, "b" : 1}
正解:C、D、E、I、J
質問 # 44
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. primary
- B. primaryPreferred
- C. secondaryPreferred
- D. nearest
- E. Secondary
正解:B
質問 # 45
Which of the following is a valid insert statement in mongodb? Select all valid.
- A. db.test.insert({x:2},{y:"apple"})
- B. db.test.push({x:2,y:"apple"})
- C. db.test.insert({x:2,y:"apple"})
- D. db.test.insert({"x":2, "y":"apple"})
正解:C、D
質問 # 46
In a collection that contains 100 post documents, what does the following command do? db. posts. find().skip(5).limit(5)
- A. Skip and limit nullify each other. Hence returning the first five documents.
- B. Skips the first five documents and returns the sixth document five times
- C. Skips the first five documents and returns the next five
- D. Limits the first five documents and then return them in reverse order
正解:C
質問 # 47
Which of the following aggregation commands in MongoDB does not support sharded collections?
- A. mapReduce
- B. group
- C. aggregate
- D. All of the above
正解:B
質問 # 48
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( {c: 1 } )
- B. db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )
- C. db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
- D. db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 } )
正解:A、B
質問 # 49
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: { $gte: 3, $lte: 6 } } } )
- C. db.inventory.find( { ratings: { $elemMatch: { $gt: 3, $lt: 6 }
- D. db.inventory.find( { ratings: { ratings: { $gt: 5, $lt: 9 } } } )
正解:D
質問 # 50
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. No limit, none
- B. 20, it
- C. 50, it
- D. 200, more
正解:B
質問 # 51
What is the maximum size of Index Key Limit and Number of Indexes per collection?
- A. 64 bytes and 1024 indexes
- B. 12 mega bytes and 64 indexes
- C. 1024 bytes and unlimited indexes
- D. 1024 bytes and 64 indexes
正解:D
質問 # 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( {c: 1 } )
- B. db.test.find( { a: 5, b: 3 } ).sort( { c: 1, d : 1 } )
- C. db.test.find( { a: 5, b: 3 } ).sort( { a: 1} )
- D. db.test.find( { a: 5, b: 3 } ).sort( { a: 1, b: 1, c: 1 > )
正解:A、B
質問 # 53
Which mongodb tools allow us to work with our data in a human readable format?
- A. mongodump
- B. mongoimport
- C. mongoexport
- D. mongostat
正解:B、C
質問 # 54
Below is a sample document of "orders" collection
- A. $project
正解:A
質問 # 55
......
無料C100DBA試験問題集試験点数を伸ばそう:https://jp.fast2test.com/C100DBA-premium-file.html
試験C100DBA最新ブレーン専門問題集はここFast2test:https://drive.google.com/open?id=1SeuBe7hHFQK7xqq1xLLDo34E6Oj_T9fS