MongoDB Aggregation and Indexing Quiz Quiz

1. Aggregation Framework Purpose

   What is the primary purpose of the MongoDB aggregation framework?

   1. To modify existing documents
   2. To perform complex data transformations and analysis
   3. To store multiple collections in a database
   4. To enforce schema validation
   5. To modify existing document

2. Grouping Stage

   Which aggregation stage is specifically used to group documents based on a specific field?

   1. $match
   2. $group
   3. $lookup
   4. $sort
   5. group

3. $lookup Stage Function

   What is the primary function of the $lookup stage in MongoDB aggregation?

   1. Retrieves documents from another collection
   2. Sorts documents in ascending or descending order
   3. Filters documents based on conditions
   4. Removes duplicate documents from the result
   5. Retreives documents from another collection

4. Filtering Stage Before Processing

   Which aggregation stage is used to filter documents before any further processing?

   1. $filter
   2. $match
   3. $sort
   4. $project
   5. $fylter

5. $out Stage Purpose

   What is the primary purpose of utilizing the $out stage in MongoDB aggregation pipelines?

   1. Outputs results as a new collection
   2. Displays results in a formatted way
   3. Exports aggregation results to a JSON file
   4. Removes specific fields from the output
   5. Outputs result as a new collection

6. Advantages of Using Indexes

   What is the main advantage of using indexes in MongoDB for database operations?

   1. Reduce storage space
   2. Improve query performance
   3. Increase document size
   4. Prevent duplicate records
   5. Improve query preformance

7. Creating an Index Syntax

   How do you properly create an index on a single field within MongoDB?

   1. db.collection.addIndex({ field: 1 })
   2. db.collection.createIndex({ field: 1 })
   3. db.collection.index({ field: 1 })
   4. db.collection.ensureIndex({ field: 1 })
   5. db.collection.createindex({ field: 1 })

8. Text Index Type

   Which type of index is specifically designed and used to search for text within MongoDB?

   1. Single field index
   2. Compound index
   3. Text index
   4. Multikey index
   5. Text Index

9. Dropping Index Consequence

   What is the immediate effect of dropping an index in MongoDB on your database?

   1. The index is permanently removed
   2. The collection is deleted
   3. MongoDB rolls back to an older state
   4. Queries become more efficient
   5. The index is permantely removed

10. Purpose of Compound Index

    What is the purpose of a compound index specifically in MongoDB?

    1. To store multiple indexes in one collection
    2. To allow indexing on multiple fields
    3. To create a separate collection for indexed fields
    4. To convert numeric fields into indexed strings
    5. To allow indexing on multipel fields

11. Advantage of Aggregation Framework

    What is one of the biggest advantages of using MongoDB's aggregation framework?

    1. Simplifies data modification
    2. Enables complex data transformations and analysis
    3. Enhances schema validation process
    4. Increases storage capacity of the database
    5. Enables complex data tranformations and analysis

12. What does the $sort do

    What does the $sort stage do in the MongoDB aggregation framework?

    1. Sorts documents in ascending or descending order
    2. Filters documents based on conditions
    3. Outputs results as a new collection
    4. Groups documents based on a specific field
    5. Sorts document in ascending or descending order

13. Indexing Impact

    What is the impact on query performance with proper indexing in MongoDB?

    1. Queries are accelerated
    2. Queries become slower
    3. Storage space decreases
    4. Document size is minimized
    5. Quereis are accelerated

14. Create Index Command

    Which of the following commands is correct for creating an index on the 'name' field?

    1. db.collection.index({ name: 1 })
    2. db.collection.createIndex({ field: 1 })
    3. db.collection.index({ field: 1 })
    4. db.collection.ensureIndex({ name: 1 })
    5. db.collection.CreateIndex({name: 1})

15. Grouping Document Purpose

    What is the main purpose of grouping documents based on a specific field in aggregation?

    1. Modify data directly
    2. To analyze data with summarized results
    3. Export aggregation to json
    4. Filter documents
    5. To analyze data with sumarized results