Prepare Top MongoDB C100DEV Exam Study Guide Practice Questions Edition [Q89-Q106]

NO.89 Consider a one-to-one relationship observed between users and the users details. Basic information about application users is separated from detailed information. Which of the following are true about modeling this one-to-one relationship with the document model in MongoDB?

NO.90 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)

NO.91 How to shutdown the server? (Mongo shell)

NO.92 Which of the following read preference options may not result in out-of-date data?

NO.93 You have a companies collection with the following document structure: { _id: ObjectId(’52cdef7c4bab8bd675297dac’), name: ‘Veoh’, homepage_url: ‘http://www.veoh.com’, category_code: ‘games_video’, number_of_employees: null, founded_year: 2004, tag_list: ‘veoh, video, veohtv, socialvideo, videosharing, crunchbase, inuyasha’, email_address: ‘[email protected]’, description: ‘Internet TV service’ } How can you use projection to extract all documents with the following fields: name, homepage_url, tag_list?

NO.94 Suppose you have a mobile_games collection with the following document structure:
{ game: “Fishing Clash”, company: “Ten Square Games”, platforms: [‘Android’, ‘IOS’], …
release_USA: ISODate(“2017-04-09T01:00:00+01:00”),
release_France: ISODate(“2017-04-09T01:00:00+01:00”),
release_Italy: ISODate(“2017-08-17T01:00:00+01:00”), … }
You want to redesign your document structure as below:
{ game: “Fishing Clash”, company: “Ten Square Games”, platforms: [‘Android’, ‘IOS’],
releases: [ { location: “USA”, date: ISODate(“2017-04-09T01:00:00+01:00”) },
{ location: “France”, date: ISODate(“2017-04-09T01:00:00+01:00”) },
{ location: “Italy”, date: ISODate(“2017-08-17T01:00:00+01:00”) }, ], }
Which pattern solution will you use to solve this problem?

NO.95 Suppose you have the following index on a routes collection: db.routes.createIndex( { airplane: 1, src_airport: 1, dst_airport: 1, stops: 1 } ) Which of the following queries will be able to use this index for sorting. Check all that apply.

NO.96 Which of the following scenarios best suits the use of the Tree Pattern?

NO.97 We can use this pattern to work with different schema versions. It mainly involves adding a new field to the document structure, such as schema_version. This field will allow our application to know how to handle particular document. Which pattern does this description apply to?

NO.98 Select all true statements about MongoDB documents.

NO.99 What can you deduce from the explain() method?
For example:
db.collection.find().explain()

NO.100 What do you mean by collection scan during query execution?

NO.101 Which of the following actions are granted to the built-in userAdmin role?

NO.102 Which of the following scenarios is best suited for applying the Attribute Pattern?

NO.103 Select true statements about capped collections.

NO.104 Suppose we have database with the following collections: db.users.insertMany([ { _id: 1, user_name: ‘karo243’, account_id: 1010 }, { _id: 2, user_name: ‘jano23’, account_id: 3213 }, { _id: 3, user_name: ‘fac_data’, account_id: 4336 } ]) db.accounts.insertMany([ { account_id: 1010, type: ‘investment’, limit: 1000000 }, { account_id: 4336, type: ‘derivatives’, limit: 100000 } ]) We want to perform so-called left join. To the users collection join account details from accounts collection based on account_id field. See below. Expected output: [ { _id: 1, user_name: ‘karo243’, account_id: 1010, account_details: [ { _id: ObjectId(“61af47c6e29861661d063714”), account_id: 1010, type: ‘investment’, limit: 1000000 } ] }, { _id: 2, user_name: ‘jano23’, account_id: 3213, account_details: [] }, { _id: 3, user_name: ‘fac_data’, account_id: 4336, account_details: [ { _id: ObjectId(“61af47c6e29861661d063715”), account_id: 4336, type: ‘derivatives’, limit: 100000 } ] } ]
Which query do you need to use?

NO.105 Can you create a unique index in MongoDB?

NO.106 Which of the following built-in roles provides the greatest cluster management access?