Quiz
{
_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?
Quiz
Quiz
{
name: 'Wize',
relationships: [
{
is_past: false,
title: 'Head of Product',
person: {
first_name: 'Ethan',
last_name: 'Smith',
permalink: 'ethan-smith'
}
},
{
is_past: true,
title: 'Director, Business Development',
person: {
first_name: 'Stephanie',
last_name: 'Quay',
permalink: 'stephanie-quay'
}
},
{
is_past: true,
title: 'Sr. Engineer',
person: {
first_name: 'Stefan',
last_name: 'Antonowicz',
permalink: 'stefan-antonowicz'
}
}
]
}
Which of the following queries should you use to extract all companies that have "Co-Founder" title in
relationships field (Array)?
Quiz
{
_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' ]
}
In some documents, where there is no rating information for movie, the value is set to '' (empty string).
With that in mind, which of the following queries will return the title and rating (see below) of top 3 rated
movies in this collection?
{ 'imdb.rating': { $ne: '' } },
{ _id: 0, title: 1, 'imdb.rating': 1 }
).sort( { 'imdb.rating': -1 } ).limit(3)
{ 'imdb.rating': { $ne: '' } },
{ _id: 0, title: 1, 'imdb.rating': 1 }
).sort( { 'imdb.rating': 1 } ).limit(3)
{},
{ _id: 0, title: 1, 'imdb.rating': 1 }
).sort( { 'imdb.rating': 1 } ).limit(3)
{ 'imdb.rating': { $eq: '' } },
{ _id: 0, title: 1, 'imdb.rating': 1 }
).sort( { 'imdb.rating': -1 } ).limit(3)
Quiz
specified.
Quiz
this collection:
{
_id: ObjectId("52cdef7c4bab8bd675297da4"),
name: 'Powerset',
category_code: 'search',
founded_year: 2006
}, www.dumpsplanet.com
{
_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
}
How many documents will be deleted when executing the following query?
Quiz
Quiz
{
_id: 1,
lname: 'Smith',
tech_stack: [ 'sql', 'git', 'python', 'django' ],
fname: 'Bob'
},
{
_id: 2,
fname: 'Michael',
lname: 'Doe',
tech_stack: [ 'git', 'python', 'sqlite', 'linux', 'flask' ]
}
Using Aggregation Framework you run the following stage:
{
$unwind: {
path: '$tech_stack'
}
}
How many documents will you have in the pipeline after the $unwind stage?
Quiz
Quiz
[
{ _id: 1, user: 'Tom', scores: [ 23, 56, 3, 52, 62 ], bonus: 5 },
{ _id: 2, user: 'Jane', scores: [ 42, 50, 10 ], bonus: 3 }
]
You want to add additional fields to each document:
-> total_score (sum of the scores Array)
-> avg_score (average score in scores Array)
-> total_score_with_bonus (total_score + bonus)
Expected output:
[
{
_id: 1,
user: 'Tom',
scores: [ 23, 56, 3, 52, 62 ],
bonus: 5,
total_score: 196,
avg_score: 39.2,
total_score_with_bonus: 201
},
{
_id: 2,
user: 'Jane',
scores: [ 42, 50, 10 ],
bonus: 3,
total_score: 102,
avg_score: 34,
total_score_with_bonus: 105
}
]
Which query do you need to use?
$addFields: {
total_score: {
$sum: '$scores'
},
avg_score: {
$avg: '$scores'
}
}
}, {
$addFields: {
total_score_with_bonus: {
$add: ['$total_score', '$bonus']
}
}
}])
$addFields: {
total_score: {
$sum: '$scores'
},
avg_score: {
$avg: '$scores'
},
total_score_with_bonus: {
$add: ['$total_score', '$bonus']
}
}
}])
MongoDB Certified Developer Associate Practice test unlocks all online simulator questions
Thank you for choosing the free version of the MongoDB Certified Developer Associate practice test! Further deepen your knowledge on MongoDB Simulator; by unlocking the full version of our MongoDB Certified Developer Associate Simulator you will be able to take tests with over 34 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 34 questions.
BUY NOWWhat to expect from our MongoDB Certified Developer Associate practice tests and how to prepare for any exam?
The MongoDB Certified Developer Associate Simulator Practice Tests are part of the MongoDB Database and are the best way to prepare for any MongoDB Certified Developer Associate exam. The MongoDB Certified Developer Associate practice tests consist of 34 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The MongoDB Certified Developer Associate database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with MongoDB Certified Developer Associate Simulator will also give you an idea of the time it will take to complete each section of the MongoDB Certified Developer Associate practice test . It is important to note that the MongoDB Certified Developer Associate Simulator does not replace the classic MongoDB Certified Developer Associate study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the MongoDB Certified Developer Associate exam.
BUY NOWMongoDB Certified Developer Associate Practice test therefore represents an excellent tool to prepare for the actual exam together with our MongoDB practice test . Our MongoDB Certified Developer Associate Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our MongoDB Certified Developer Associate Simulator and how our unique MongoDB Certified Developer Associate Database made up of real questions:
Info quiz:
- Quiz name:MongoDB Certified Developer Associate
- Total number of questions:34
- Number of questions for the test:50
- Pass score:80%
You can prepare for the MongoDB Certified Developer Associate exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our MongoDB Certified Developer Associate Simulator.
Use our Mobile App, available for both Android and iOS devices, with our MongoDB Certified Developer Associate Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.
Our Mobile App contains all MongoDB Certified Developer Associate practice tests which consist of 34 questions and also provide study material to pass the final MongoDB Certified Developer Associate exam with guaranteed success. Our MongoDB Certified Developer Associate database contain hundreds of questions and MongoDB Tests related to MongoDB Certified Developer Associate Exam. This way you can practice anywhere you want, even offline without the internet.
BUY NOW