Dec 28, 2023 C100DEV Exam Crack Test Engine Dumps Training With 253 Questions [Q36-Q54]

NEW QUESTION 36
You have the following index in a products collection: { product_category: 1, product_name: 1, origin_country: -1 } Which of the following queries can use this index? Check all that apply.

db.products.find({ origin_country: ‘Bangladesh’, product_name: ‘AIR MAX 90’, product_category: ‘shoes’ })

db.products.find({ product_name: ‘AIR MAX 90’, product_category: ‘shoes’, origin_country: ‘Bangladesh’ })

db.products.find({ product_category: ‘shoes’, product_name: ‘AIR MAX 90’, origin_country: ‘Bangladesh’ })

db.products.find({ product_name: ‘AIR MAX 90’, origin_country: ‘Bangladesh’ })

NEW QUESTION 37
Select true statements about data modeling in MongoDB.

To avoid having to join data in the application layer from different collections you can denormalize your data.

If one of your application’s main queries is to retrieve related information from different collections, it is usually better to group that information into a single document.

It’s good data modeling practice to directly map each table from the relational model (normalized data) to the collection.

NEW QUESTION 38
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 the movies that have more votes than the year in which they were released?

db.movies.find({ $expr: { $gt: [“imdb.votes”, “year”] } } )

db.movies.find({ $expr: { $lt: [“$imdb.votes”, “$year”] } } )

db.movies.find({ $expr: { $gt: [“$imdb.votes”, “$year”] } } )

NEW QUESTION 39
There is a gamers collection in your database with the following document structure:
{ _id: 1, level: 15, is_active: true }, { _id: 2, level: 14, is_active: true }, { _id: 3, level: 7, is_active: false }
How do you update the value of the level field to 20 for a player with an id = 2?
Expected result:
{ _id: 1, level: 15, is_active: true }, { _id: 2, level: 20, is_active: true }, { _id: 3, level: 7, is_active: false }

db.gamers.update( { _id: 2 }, { level: 20 } )

db.gamers.update( { _id: 2 }, { $inc: { level: 20 } } )

db.gamers.update( { _id: 2 }, { $set: { level: 20 } } )

NEW QUESTION 40
Select properly used $out operator.

db.collection.aggregate([ { stage1 }, { stage2 }, …, { stageN }, { $out: “new_collection” } ])

db.collection.aggregate([ { stage1 }, { $out: “new_collection” }, { stage2 }, …, { stageN } ])

db.collection.aggregate([ { $out: “new_collection” }, { stage1 }, { stage2 }, …, { $stageN } ])

NEW QUESTION 41
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”: { “$lt”: “M” } } ).sort( { “imdb.votes”: -1 } )

Yes

No

NEW QUESTION 42
Given the following MongoDB URI: mongodb+srv://datascientist34:[email protected]/admin Which of the following statements are true? (select 2)

There are 178 nodes in the xtr replica set.

The password used for authentication is xtr-178

The password used for authentication is ta33w9rd

The user datascientist34 is trying to authenticate on database admin.

NEW QUESTION 43
Select all true statements regarding to pipelines and the Aggregation Framework.

An aggregation pipeline consists of one or more stages that process documents.

The Aggregation Framework provides us many stages to filter and transform data.

The aggregation pipeline cannot operate on a sharded collection.

An aggregation pipeline is an array of stages.

Aggregation Framework does not have the group stage for grouping data.

NEW QUESTION 44
Select all true statements regarding to scaling.

When scaling vertically our scaling cost increases linearly.

Scaling horizontally is generally cheaper than scaling vertically.

When scaling horizontally our scaling cost increases linearly.

NEW QUESTION 45
Assign typical operational tasks to the Data Scientist.

read data

write data

write data, read data

create user, create index

NEW QUESTION 46
Which of the following commands will add a collection that is stored in JSON file to a MongoDB cluster?

mongodump

mongoimport

mongostore

mongoexport

NEW QUESTION 47
There is a gamers collection in your database with the following document structure: { _id: 1, level: 15, is_active: true }, { _id: 2, level: 14, is_active: true }, { _id: 3, level: 7, is_active: false } How do you increase the value of the level field by 20 for a player with id = 3?
Expected result:
{ _id: 1, level: 15, is_active: true }, { _id: 2, level: 14, is_active: true }, { _id: 3, level: 27, is_active: false }

db.gamers.update( { _id: 3 }, { $inc: { level: 20 } } )

db.gamers.update( { _id: 3 }, { $set: { level: 20 } } )

db.gamers.update( { _id: 3 }, { $unset: { level: 20 } } )

NEW QUESTION 48
Select scenarios that are best suited for applying the Schema Versioning Pattern.

Your team was assigned to update the current schema with additional fields without shutting down the system for this upgrade. However, all documents need to be quickly updated.

There is a requirement to keep multiple versions of a document, and those versions can have different fields for each version in your application.

NEW QUESTION 49
Which of the following stages do you need to use to randomly select 10 documents from a specific collection?

{ $rand: { size: 10 } }

{ $sample: { size: 10 } }

{ $sampleRate: { size: 10 } }

{ $sample: { get: 10 } }

NEW QUESTION 50
A collection called players contains documents with the following structure: { _id: 1, user: ‘Tom’, scores: [ 23, 56, 3, 52, 62 ], bonus: 5 } { _id: 2, user: ‘Jane’, scores: [ 42, 50, 10 ], bonus: 3 } You have the following query: db.players.aggregate([{ $addFields: { total_score: { $sum: ‘$scores’ }, avg_score: { $avg: ‘$scores’ } } }, { $addFields: { total_score_with_bonus: { $add: [‘$total_score’, ‘$bonus’] } } }, { $match: { bonus: { $gt: 4 } } }]) How can you optimize this query?

Moving the $match stage to the beginning of the pipeline. [{ $match: { bonus: { $gt: 4 } } }, { $addFields: { total_score: { $sum: ‘$scores’ }, avg_score: { $avg: ‘$scores’ } } }, { $addFields: { total_score_with_bonus: { $add: [‘$total_score’, ‘$bonus’] } } }]

Moving the $match stage to the second stage of this pipeline. [{ $addFields: { total_score: { $sum: ‘$scores’ }, avg_score: { $avg: ‘$scores’ } } }, { $match: { bonus: { $gt: 4 } } }, { $addFields: { total_score_with_bonus: { $add: [‘$total_score’, ‘$bonus’] } } }]

This query cannot be optimized.

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

db.restaurants.dropCollection()

db.restaurants.delete()

db.restaurants.remove()

db.restaurants.drop()

NEW QUESTION 52
Select all true statements about the update operation. (select 2)

updateOne() method with the $set operator updates the first document that matches the query.

If the field doesn’t exist, updateOne() method with the $set operator will not add a new field with the specified value.

updateOne() method with the $set operator updates an existing document field with the given value.

NEW QUESTION 53
$group stage can be used multiple times within an aggregation pipeline.

False

True

NEW QUESTION 54
Select all true statements about MongoDB documents.

MongoDB documents must have the same fields in the collection.

MongoDB documents are stored as BSON documents.

MongoDB documents have a flexible schema.

MongoDB documents are stored as JSON documents.

Free Exam Dumps Torrent

Dec 28, 2023 C100DEV Exam Crack Test Engine Dumps Training With 253 Questions [Q36-Q54]

Leave a Reply Cancel reply

Related Posts

(2023) C100DBA Dumps and Practice Test (123 Questions) [Q28-Q50]

Leave a Reply Cancel reply