Skip to content

Tools
Solutions
Resources
Contact us
Store
Download
My 3T

Explore our courses
Get certified

Building a Basic Aggregation: Test your skills

MongoDB 301: Aggregation Building a Basic Aggregation Exercise 4: Adding processing options to the aggregation Building a Basic Aggregation: Test your skills

Use the following questions to help you review the material in this tutorial.

Time limit: 0

Quiz Summary

0 of 5 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 5 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Next Lesson

1
2
3
4
5

Current
Review
Answered
Correct
Incorrect

Question 1 of 5

1. Question
You are building an aggregate statement in IntelliShell. You want to include the collation option in the statement. Where do you add the option within the statement?
- Add a stage to the end of the pipeline that defines the option settings.
- Add a stage to the beginning of the pipeline that defines the option settings.
- Add a comma after the pipeline’s closing bracket and then add the option after the comma, enclosed in curly braces.
- Add a comma after the aggregate method’s closing parenthesis and then add the option after the comma, enclosed in square brackets.
Correct

Incorrect
Question 2 of 5

2. Question
You are building an aggregate statement in IntelliShell. The statement will aggregate data in the customers collection. You want to filter out all customers except those who live in Georgia. Which aggregate method do you use when defining your first stage?
- $match
- $merge
- $replaceRoot
- $replaceWith
Correct

Incorrect
Question 3 of 5

3. Question
You are building an aggregate statement in IntelliShell. The statement will aggregate data in the customers collection. You want to group the data by the package field and find the average number of transactions per package. Which $group expression should you use?
- { "_id": "sum", "package": { "$total": "$add" } }
- { "_id": "avg", "package": { "$total": "$add" } }
- { "_id": "$package", "total": { "$sum": "$transactions" } }
- { "_id": "$package", "total": { "$avg": "$transactions" } }
Correct

Incorrect
Question 4 of 5

4. Question
You are building an aggregate statement in IntelliShell. The last stage in the pipeline uses the $sort operator to sort the pipeline documents in descending order, based on the total column. Which argument should you use to specify the sort order?
- 1
- -1
- asc
- desc
Correct

Incorrect
Question 5 of 5

5. Question
You are building an aggregate statement in IntelliShell. You want to be able to write data to temporary files on disk when running the statement. Which option should you include in your statement?
- The allowDiskUse option set to true.
- The allowDiskUse option set to false.
- The bypassDocumentValidation option set to true.
- The bypassDocumentValidation option set to false.
Correct

Incorrect

Course Home Expand All

Building a Basic Aggregation

4 Topics | 1 Quiz

Exercise 1: Filtering the documents in the aggregation pipeline

Exercise 2: Grouping the documents in the aggregation pipeline

Exercise 3: Sorting the documents in the aggregation pipeline

Exercise 4: Adding processing options to the aggregation

Building a Basic Aggregation: Test your skills

Introducing the Aggregation Editor

4 Topics | 1 Quiz

Exercise 1: Importing an aggregate statement into the Aggregation Editor

Exercise 2: Replace a field in the aggregation pipeline

Exercise 3: Reorder the fields in the aggregation pipeline

Exercise 4: Changing the sort order in the aggregation pipeline

Introducing the Aggregation Editor: Test your skills

Working with Arrays in the Aggregation Pipeline

5 Topics | 1 Quiz

Exercise 1: Using expression operators to filter input documents

Exercise 2: Unwinding an array to create individual documents

Exercise 3: Grouping array values and generating a document count for each group

Exercise 4: Writing pipeline results to a new collection

Working with Arrays in the Aggregation Pipeline: Test your skills

MongoDB 301 Mid-Course Feedback

Adding Lookup Data to the Aggregation Pipeline

4 Topics | 1 Quiz

Exercise 1: Adding lookup data to the aggregation pipeline

Exercise 2: Converting string values in one of the lookup fields to integers

Exercise 3: Adding a computed ratio field based on the converted lookup field

Exercise 4: Limiting the number of returned documents

Adding Lookup Data to the Aggregation Pipeline: Test your skills

Working with Reschema for MongoDB

4 Topics | 1 Quiz

Exercise 1: Setting up a reschema unit that includes lookup data

Exercise 2: Defining a target collection in the reschema unit

Exercise 3: Adding and scheduling a task to create the target collection

Exercise 4: Running an aggregate statement against the target collection

Working with Reschema for MongoDB: Test your skills

Reporting with Studio 3T Aggregations

3 Topics | 1 Quiz

Exercise 1: Creating a view based on an aggregation query

Exercise 2: Exporting a collection as a .csv file for use by a third-party tool

Exercise 3: Visualizing collection data in MongoDB Charts

Reporting with Studio 3T Aggregations: Test your skills

Return to MongoDB 301: Aggregation

Studio 3T

Since 2014, 3T has been helping thousands of MongoDB developers and administrators with their everyday jobs by providing the finest MongoDB tools on the market. We guarantee the best compatibility with current and legacy releases of MongoDB, continue to deliver new features with every new software release, and provide high quality support.

Education

Free MongoDB Tutorials
Connect to MongoDB
Connect to MongoDB Atlas
Import Data to MongoDB
Export MongoDB Data
Build Aggregation Queries
Query MongoDB with SQL
Migrate from SQL to MongoDB

Resources

Feedback and Support
Sales Support
Knowledge Base
FAQ
Reports
White Papers
Testimonials
Discounts

Company

About Us
Blog
Careers
Legal
Press
Privacy Policy
EULA

© 2023 3T Software Labs Ltd. All rights reserved.

Privacy Policy
Cookie settings
Impressum

We value your privacy

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data.

By clicking “Accept all”, you consent to the storage of cookies and the processing of personal data for these purposes, including any transfers to third countries. By clicking on “Decline all”, you do not give your consent and we will only store cookies that are necessary for our website. You can customize the cookies we store on your device or change your selection at any time - thus also revoking your consent with effect for the future - under “Manage Cookies”, or “Cookie Settings” at the bottom of the page. You can find further information in our Privacy Policy.

Accept all

Decline all

✕

Privacy Preference Center

With your consent, we and third-party providers use cookies and similar technologies on our website to analyse your use of our site for market research or advertising purposes ("analytics and marketing") and to provide you with additional functions (“functional”). This may result in the creation of pseudonymous usage profiles and the transfer of personal data to third countries, including the USA, which may have no adequate level of protection for the processing of personal data. Please choose for which purposes you wish to give us your consent and store your preferences by clicking on “Accept selected”. You can find further information in our Privacy Policy.

Accept all cookies

Manage consent preferences

Essential cookies (Always active)

Essential cookies are strictly necessary to provide an online service such as our website or a service on our website which you have requested. The website or service will not work without them.

Analytics and marketing cookies

Performance cookies allow us to collect information such as number of visits and sources of traffic. This information is used in aggregate form to help us understand how our websites are being used, allowing us to improve both our website’s performance and your experience.

Google Analytics

Functional cookies

Functional cookies collect information about your preferences and choices and make using the website a lot easier and more relevant. Without these cookies, some of the site functionality may not work as intended.

Social Media cookies

Social media cookies are cookies used to share user behaviour information with a third-party social media platform. They may consequently effect how social media sites present you with information in the future.

Accept selected

Search for: