Best C100DEV Exam Dumps for the Preparation of Latest C100DEV Exam Questions [Q146-Q162]

QUESTION 146
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 were made in 2000 or 2010?

QUESTION 147
Which of the following statements are true regarding MongoDB views?

QUESTION 148
Select all true statements about one-to-zillions relationships (a special case of the one-to-many relationship in MongoDB).

QUESTION 149
You have the following query: db.gamers.find( { “level”: { “$gte” : 70 }, “map”: “Inferno” } ).sort( { “points”: 1, “group”: 1 } ) Which of the following indexes best supports this query? Keep in mind the equality, sort, range rule.

QUESTION 150
A social media company needs to implement a data model that describes te relationships between users. When loading real data into the system, it turned out that one user has too many contacts to store them in the designated array. Instead of redesigning the entire system what pattern can you use?

QUESTION 151
Select all true statements regarding to Aggregation Framework.

QUESTION 152
How to create a new user with the root role named root_user with password root123?

QUESTION 153
Use case: e-learning platform Which of the following scenarios is the best candidate to use the Extended Reference Pattern to avoid additional reads by joins/lookups?

QUESTION 154
Suppose you have a posts collection of documents in your social_app database.
What namespace are these documents stored in?

QUESTION 155
Select all true statements about differences between using aggregate() and find() methods?

QUESTION 156
We have the following index in a movies collection: { title: 1, genres: 1 } We want to insert the following document: { “title”: “The Immigrant”, “year”: 1917, “genres”: [ “Short”, “Comedy”, “Drama” ] } How many index entries will be created?

QUESTION 157
Suppose you have a sales collection with the following document structure: { _id: ObjectId(“5bd761dcae323e45a93ccfe8”), saleDate: ISODate(“2015-03-23T21:06:49.506Z”), items: [ { name: ‘printer paper’, tags: [ ‘office’, ‘stationary’ ], price: Decimal128(“40.01”), quantity: 2 } { name: ‘pens’, tags: [ ‘writing’, ‘office’, ‘school’, ‘stationary’ ], price: Decimal128(“56.12”), quantity: 5 }, { name: ‘notepad’, tags: [ ‘office’, ‘writing’, ‘school’ ], price: Decimal128(“18.47”), quantity: 2 } ], storeLocation: ‘Denver’, couponUsed: true, purchaseMethod: ‘Online’ } Which operator should you use to extract all sales documents that have ‘notepad’ name in items field?

QUESTION 158
Select all true statements regarding to schema validation in MongoDB.

QUESTION 159
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.

QUESTION 160
Which of the following commands will delete a collection named restaurants?

QUESTION 161
We have a movies collection with the following document structure: { _id: ObjectId(“573a1390f29313caabcd6223”), genres: [ ‘Comedy’, ‘Drama’, ‘Family’ ], title: ‘The Poor Little Rich Girl’, released: ISODate(“1917-03-05T00:00:00.000Z”), year: 1917, imdb: { rating: 6.9, votes: 884, id: 8443 } } We need to extract all movies from this collection where genres includes both ‘Crime’ and ‘Mystery’. Which query should we use?

QUESTION 162
Suppose you are connected to mongod instance that is already running on port 27000 as admin user. You have to create a new user for an application that has the readWrite role. Use the db.createUser() command to create a user for data analysis. The requirements for this user are: -> role: read on esmartdata database -> username: dataScientist -> password: ds123sci456 Which command should you use?