2023年最新のMongoDBテストC100DEV問題集豪華セット無料最新の問題集をゲット！
完全版C100DEV練習テスト253特別な問題と解答が待ってます！今すぐゲットせよ！
質問 # 125
Suppose you want to join two collections in the same database. What aggregation stage do you need to use?
- A. $project
- B. $out
- C. $lookup
正解：C
解説：
https://docs.mongodb.com/manual/reference/operator/aggregation/lookup/
質問 # 126
You want to execute the following query quite often in your application: db.hotels.aggregate([ { "$match": { "stars": { "$gt": 4.5 } } }, { "$sort": { "stars": 1 } } ]) Your collection doesn't have any additional indexes. Which index should you create to support this query?
- A. db.hotels.createIndex( { "stars": 1 } )
- B. db.hotels.createIndex( { "match": 1 } )
- C. In this case, the index could not be created.
正解：A
解説：
https://docs.mongodb.com/manual/indexes/
質問 # 127
Select all true statements regarding to the insert operation.
- A. If you insert document with a _id field value that already exists, an error will be raised.
- B. If you insert a document with no _id value specified, it will result in a write error.
- C. MongoDB will automatically add an _id field when inserting document without specified _id field into a collection.
正解：A、C
解説：
https://docs.mongodb.com/manual/reference/method/db.collection.insert/
質問 # 128
You have to create a simple configuration file for mongod instance. Here are the requirements of your mongod instance: * run on port 27100 * authentication is enabled Which of the following configuration file meet these requirements?
- A. net:
port: 27100
security:
authorization: enabled - B. net:
port: 27000
processManagement:
fork: true - C. net:
port: 27100
security:
authorization: disabled
正解：A
解説：
https://docs.mongodb.com/manual/reference/configuration-options/
質問 # 129
Suppose you insert the following documents into companies collection: db.companies.insertMany([ {"_id": 1, "name": "Facebook"}, {"_id": 1, "name": "Twitter"}, {"_id": 2, "name": "Tesla"}, {"_id": 3, "name": "Amazon"} ], {"ordered": false}) Select all true statements about this operation. (select 3)
- A. MongoDB will insert each document with a unique _id value into the collection.
- B. One document will be inserted into the collection.
- C. Two documents will be inserted into the collection.
- D. This insert is unordered.
- E. Three documents will be inserted into the collection.
正解：A、D、E
解説：
https://docs.mongodb.com/manual/reference/method/db.collection.insertMany/
質問 # 130
In your database a movies collection is given where each document has the following structure: { _id: ObjectId("573a1391f29313caabcd9264"), genres: [ 'Romance', 'Drama' ], title: 'The Divorcee', languages: [ 'English', 'French' ], year: 1930, imdb: { rating: 6.9, votes: 1740, id: 20827 }, countries: [ 'USA' ] } Which of the following queries will return all movies that are in the Fantasy and Drama (both) genre?
- A. db.movies.find( { genres: { $all: ['Fantasy', 'Drama'] } } )
- B. db.movies.find( { genres: { $in: ['Fantasy', 'Drama'] } } )
- C. db.movies.find( { genres: { $size: ['Fantasy', 'Drama'] } } )
- D. db.movies.find( { genres: { $elemMatch: ['Fantasy', 'Drama'] } } )
正解：A
解説：
https://docs.mongodb.com/manual/reference/operator/query/all/
質問 # 131
Which of the following commands will add a collection that is stored in BSON file to a MongoDB cluster?
- A. mongorestore
- B. mongoimport
- C. mongodump
- D. mongoexport
正解：A
解説：
https://docs.mongodb.com/database-tools/mongorestore/
質問 # 132
Given a movies collection where each document has the following structure: { _id: ObjectId("573a1390f29313caabcd60e4"), genres: [ 'Short', 'Comedy', 'Drama' ], title: 'The Immigrant', year: 1917, imdb: { rating: 7.8, votes: 4680, id: 8133 }, countries: [ 'USA' ] } Which of the following queries will find all movies that do not contain the Comedy and Romance genres?
- A. db.movies.find( { genres: { $in: ["Comedy", "Romance"] } } )
- B. db.movies.find( { genres: { $nin: ["Comedy", "Romance"] } } )
- C. db.movies.find( { genres: { $or: ["Comedy", "Romance"] } } )
正解：B
解説：
https://docs.mongodb.com/manual/reference/operator/query/nin/
質問 # 133
Given a companies collection where each document has the following structure: { _id: ObjectId("52cdef7c4bab8bd675297efd"), name: 'ZoomInfo', homepage_url: 'http://www.zoominfo.com', blog_url: 'http://zoominfoblogger.wordpress.com/', twitter_username: 'ZoomInfo', founded_year: 2000, email_address: '' } Extract all companies from this collection that have the same Twitter username as the company name. Which query should you use?
- A. db.companies.find( { $expr: { $ne: ['$name', '$twitter_username'] } } )
- B. db.companies.find( { $expr: { $eq: ['$name', '$twitter_username'] } } )
- C. db.companies.find( { $expr: { $eq: ['$name', 'twitter_username'] } } )
- D. db.companies.find( { $expr: { $eq: ['name', 'twitter_username'] } } )
正解：B
解説：
db.companies.find( { $expr: { $eq: ['$name', 'twitter_username'] } } ) You have to use $ sign to evaluate twitter_username field. db.companies.find( { $expr: { $eq: ['name', 'twitter_username'] } } ) You have to use $ sign to evaluate name and twitter_username fields. https://docs.mongodb.com/manual/reference/operator/query/expr/
質問 # 134
Which of the following built-in roles provides the greatest cluster management access?
- A. clusterMonitor
- B. clusterAdmin
- C. clusterManager
正解：B
解説：
Explanation: https://docs.mongodb.com/manual/reference/built-in-roles/#mongodb-authrole-clusterAdmin
質問 # 135
In your database there is a movies collection with the following document structure: { _id: ObjectId("573a1390f29313caabcd42e8"), genres: [ 'Short', 'Western' ], title: 'The Great Train Robbery', rated: 'TV-G', year: 1903, imdb: { rating: 7.4, votes: 9847, id: 439 }, countries: [ 'USA' ] }, { _id: ObjectId("573a1390f29313caabcd4323"), genres: [ 'Short', 'Drama', 'Fantasy' ], rated: 'UNRATED', title: 'The Land Beyond the Sunset', year: 1912, imdb: { rating: 7.1, votes: 448, id: 488 }, countries: [ 'USA' ] }, { _id: ObjectId("573a1390f29313caabcd446f"), genres: [ 'Short', 'Drama' ], title: 'A Corner in Wheat', rated: 'G', year: 1909, imdb: { rating: 6.6, votes: 1375, id: 832 }, countries: [ 'USA' ] } How can you group these documents to extract the distribution of rated field?
- A. db.movies.aggregate( { $group: { _id: 'rated', count: { $sum: 1 } } } )
- B. db.movies.aggregate( { $group: { _id: '$rated', $count: { $sum: 1 } } } )
- C. db.movies.aggregate( { $group: { _id: '$rated', count: { $sum: 1 } } } )
- D. db.movies.aggregate( { $group: { _id: '$rated', count: { $avg: 1 } } } )
正解：C
解説：
https://docs.mongodb.com/manual/reference/method/db.collection.aggregate/
質問 # 136
Select all default configurations for mongod.
- A. The default data directory for mongod is /data/db
- B. By default, mongod doesn't enforce authentication.
- C. By default, mongod is only bound to localhost (or 127.0.0.1).
- D. The default port for mongod is 27017.
正解：A、B、C、D
解説：
https://docs.mongodb.com/manual/reference/configuration-options/
質問 # 137
Which of the following roles provides the same read-only privileges as read role on all databases except local and config?
- A. readAnyDatabase
- B. userAdminAnyDatabase
- C. readWriteAnyDatabase
正解：A
解説：
https://docs.mongodb.com/manual/reference/built-in-roles/#mongodb-authrole-readAnyDatabase
質問 # 138
Which of the following commands can you use to exports data in BSON format from a MongoDB cluster?
- A. mongoimport
- B. mongodump
- C. mongostore
- D. mongoexport
正解：B
解説：
https://docs.mongodb.com/database-tools/mongodump/
質問 # 139
Suppose you have a companies collection in your database. Only the following documents are stored in this collection: { _id: ObjectId("52cdef7c4bab8bd675297da4"), name: 'Powerset', category_code: 'search', founded_year: 2006 }, { _id: ObjectId("52cdef7c4bab8bd675297da5"), name: 'Technorati', category_code: 'advertising', founded_year: 2002 }, { _id: ObjectId("52cdef7c4bab8bd675297da7"), name: 'AddThis', category_code: 'advertising', founded_year: 2004 }, { _id: ObjectId("52cdef7c4bab8bd675297da8"), name: 'OpenX', category_code: 'advertising', founded_year: 2008 }, { _id: ObjectId("52cdef7c4bab8bd675297daa"), name: 'Sparter', category_code: 'games_video', founded_year: 2007 }, { _id: ObjectId("52cdef7c4bab8bd675297dac"), name: 'Veoh', category_code: 'games_video', founded_year: 2004 }, { _id: ObjectId("52cdef7c4bab8bd675297dae"), name: 'Thoof', category_code: 'web', founded_year: 2006 } What is the default sort order in the result set returned in response to the following query?
- A. ascending
- B. descending
- C. db.companies.aggregate( [ { "$sortByCount": "$category_code" } ] )
正解：B
解説：
https://docs.mongodb.com/manual/reference/operator/aggregation/sortByCount/
質問 # 140
There is a collection named products in MongoDB database. Your coworker wants to know how many products are in this collection (number of documents in the collection) from the United States. Which query should you use?
- A. db.products.find( { country: "USA" } ).count()
- B. db.products.find( country == "USA" ).count()
- C. db.products.find( country = "USA" ).count()
- D. db.products.find( { country: "USA" } )
正解：A
解説：
https://docs.mongodb.com/manual/reference/method/db.collection.find/
質問 # 141
Assign typical operational tasks to the Data Scientist.
- A. write data
- B. read data
- C. write data, read data
- D. create user, create index
正解：B
質問 # 142
In which situations can we consider sharding?
- A. Our dataset is too big to fit in one MongoDB instance.
- B. It takes too long to backup and restore the data set.
- C. A new developer will join your development team soon.
- D. We want to improve read performance for our application.
正解：A、B、D
解説：
https://docs.mongodb.com/manual/sharding/
質問 # 143
Given a flights collection that is sharded on the following shard key: { "airline_id" : 1, "departure_airport" : 1 } Which of the following queries results in a targeted query?
- A. db.flights.find( { departure_airport: "JFK" } )
- B. db.flights.find( { airline_id: 2946863, departure_airport: "JFK" } )
- C. db.flights.find( { departure_airport: "JFK", airline_id: 2946863 } )
- D. db.flights.find( { airline_id: 2946863 } )
正解：B、C、D
解説：
db.flights.find( { departure_airport: "JFK" } ) This query doesn't include the airline_id prefix, and cannot be targeted. https://docs.mongodb.com/manual/core/sharding-shard-key/
質問 # 144
Select all true statements about text search in MongoDB.
- A. Text indexes can include any field whose value is a string.
- B. To perform text searches on a collection we use $text operator.
- C. A collection can only have one text search index, but that index can cover multiple fields.
- D. Text indexes cannot include any field whose value is an array of string elements.
- E. MongoDB provides text indexes to support text search queries on string content.
- F. To perform text search queries, you must have a text index on your collection.
正解：A、B、C、E、F
解説：
https://docs.mongodb.com/manual/text-search/
質問 # 145
Which of the following queries can use an index on the title field?
- A. db.movies.find( { genres: "Drama", type: "series" } )
- B. db.movies.find()
- C. db.movies.find()
- D. db.movies.find( { title: "Death Note" } )
- E. db.movies.find( { _id: 245 } )
正解：D
解説：
https://docs.mongodb.com/manual/indexes/
質問 # 146
......
[2023年11月] 合格させるMongoDB C100DEV試験一発合格保証：https://drive.google.com/open?id=1mtFI6Z_Vx8B-2yd0z5-VvIrP9QwgTb1x
あなたの合格率を上げろうC100DEV試験問題集：https://www.jpntest.com/shiken/C100DEV-mondaishu