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

QUESTION 37
You have the following index in a movies collection: { “title”: 1, “imdb.rating”: -1, “imdb.votes”: -1, “type”: 1 } Can the following query use the given index for both filtering and sorting?
db.movies.find( { “title”: “James Bond”, “imdb.rating”: { “$gt”: 8} } ).sort( { “imdb.rating”: 1 } )

QUESTION 38
You have the following configuration file: storage: dbPath: /var/mongodb/db net: bindIp: localhost port: 27000 security: authorization: enabled You have to update this file such that: * mongod sends logs to /var/mongodb/logs/mongod.log * mongod is forked and run as a daemon Select correct Answer.

QUESTION 39
What do you mean by collection scan during query execution?

QUESTION 40
Which of the following rules (when ordering) should be followed when building query indexes?

QUESTION 41
Data modeling. You are considering the use of nesting or references in your data model. Your data may change frequently. Which option would be more appropriate?

QUESTION 42
Select all true statements regarding to $out stage.

QUESTION 43
In your database there is a collection named trips with the following document structure: { ‘_id’: ObjectId(“572bb8222b288919b68abf6d”), ‘trip_duration’: 858, ‘start_station id’: 532, ‘end_station_id’: 401, ‘bike_id’: 17057, ‘start_station_location’: { type: ‘Point’, coordinates: [ -73.960876, 40.710451 ] }, ‘end_station_location’: { type: ‘Point’, coordinates: [ -73.98997825, 40.72019576 ] }, ‘start_time’: ISODate(“2016-01-01T00:09:31.000Z”), ‘stop_time’: ISODate(“2016-01-01T00:23:49.000Z”) } How can you extract all trips from this collection ended at stations that are to the west of the -73.5 longitude coordinate?

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

QUESTION 45
Select all options when you should deploy a MongoDB deployment with security enabled.

QUESTION 46
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 of the following queries will return all document sales with ‘printer paper’ sold?

QUESTION 47
Select true statements about the selection of the shard key.

QUESTION 48
Use case: e-learning platform Which of the following scenarios is the best candidate to use the Subset Pattern?

QUESTION 49
Suppose you want to familiarize with a new collection and want to display a single document. Which collection method should you use in this case?

QUESTION 50
What is data modeling in MongoDB world?

QUESTION 51
Select all true statements regarding to the role of fields and values in a MongoDB document. (select 2)

QUESTION 52
Which cursor method should you use to get information about the query plan?

QUESTION 53
Which of the following documents are valid JSON format? (select 2)

QUESTION 54
Suppose you have a restaurants collection with the following document structure: { _id: ObjectId(“5eb3d668b31de5d588f42931”), address: { building: ‘6409’, coord: [ -74.00528899999999, 40.628886 ], street: ’11 Avenue’, zipcode: ‘11219’ }, borough: ‘Brooklyn’, cuisine: ‘American’, grades: [ { date: ISODate(“2014-07-18T00:00:00.000Z”), grade: ‘A’, score: 12 }, { date: ISODate(“2013-07-30T00:00:00.000Z”), grade: ‘A’, score: 12 }, { date: ISODate(“2013-02-13T00:00:00.000Z”), grade: ‘A’, score: 11 }, { date: ISODate(“2012-08-16T00:00:00.000Z”), grade: ‘A’, score: 2 }, { date: ISODate(“2011-08-17T00:00:00.000Z”), grade: ‘A’, score: 11 } ], name: ‘Regina Caterers’, restaurant_id: ‘40356649’ } You have the following index: { “cuisine”: 1, “borough”: 1 } What will the query plan look like for the following query?
db.restaurants.find( { “cuisine”: “American”, “borough”: { “$gt”: “S” } } )

QUESTION 55
Select all true statements about query plans in MongoDB. (select 2)

QUESTION 56
Assign typical operational tasks to the Database Administrator.

QUESTION 57
How to correctly create a date (new object of Date type) in MongoDB?

QUESTION 58
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’ ] } Which of the following queries will return only the title for the five oldest movies in this collection?

QUESTION 59
Select all true statements regarding to indexes.

QUESTION 60
You have the following replica set configuration: conf = { “_id”: “replset”, “version”: 1, “protocolVersion”: 1, “members”: [ { “_id”: 0, “host”: “192.168.120.24:27017”, “priority”: 2, “votes”: 1 }, { “_id”: 1, “host”: “192.168.120.24:27018”, “priority”: 1, “votes”: 1 }, { “_id”: 2, “host”: “192.168.120.24:27018”, “priority”: 1, “votes”: 1 } ] } Select all true statements about this configuration.