Bird
Raised Fist0
MongoDBquery~20 mins

Joins vs embedding decision in MongoDB - Practice Questions

Choose your learning style10 modes available

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Challenge - 5 Problems
🎖️
MongoDB Joins vs Embedding Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
🧠 Conceptual
intermediate
2:00remaining
When to prefer embedding over referencing in MongoDB?

Which scenario best suggests using embedding documents instead of referencing (joins) in MongoDB?

AWhen data needs to be normalized to avoid duplication.
BWhen related data is very large and updated independently.
CWhen related data is frequently accessed together and changes rarely.
DWhen you want to enforce strict foreign key constraints.
Attempts:
2 left
💡 Hint

Think about data locality and update frequency.

query_result
intermediate
2:00remaining
Output of a $lookup join in MongoDB aggregation

Given two collections, orders and customers, what will be the output of this aggregation?

{
  $lookup: {
    from: "customers",
    localField: "customerId",
    foreignField: "_id",
    as: "customerInfo"
  }
}
MongoDB
db.orders.aggregate([
  {
    $lookup: {
      from: "customers",
      localField: "customerId",
      foreignField: "_id",
      as: "customerInfo"
    }
  }
])
AEach order document will include an array field 'customerInfo' with matching customer documents.
BThe query will return only customer documents matching orders.
CThe query will fail because $lookup requires a pipeline.
DEach customer document will include an array of orders.
Attempts:
2 left
💡 Hint

Recall what $lookup does in aggregation pipelines.

📝 Syntax
advanced
2:00remaining
Identify the syntax error in this embedding example

Which option contains a syntax error in embedding a subdocument inside a MongoDB insert?

MongoDB
db.products.insertOne({
  name: "Laptop",
  specs: {
    cpu: "Intel i7",
    ram: "16GB",
    storage: "512GB SSD"
  }
})
Adb.products.insertOne({ name: "Laptop", specs: { cpu: "Intel i7", ram: "16GB", storage: "512GB SSD" } })
Bdb.products.insertOne({ name: "Laptop", specs: [ cpu: "Intel i7", ram: "16GB", storage: "512GB SSD" ] })
C)} } "DSS BG215" :egarots ,"BG61" :mar ,"7i letnI" :upc { :sceps ,"potpaL" :eman {(enOtresni.stcudorp.bd
Db.products.insertOne({ name: "Laptop", specs: { cpu: "Intel i7", ram: "16GB", storage: "512GB SSD" } })
Attempts:
2 left
💡 Hint

Check the use of brackets for subdocuments.

optimization
advanced
2:00remaining
Optimizing read performance with embedding vs referencing

You have a blog application where each post has many comments. Which data modeling choice optimizes read performance when displaying posts with comments?

ADuplicate comments in both posts and comments collections.
BStore comments in a separate collection and reference post IDs.
CUse a relational database instead of MongoDB.
DEmbed all comments inside each post document.
Attempts:
2 left
💡 Hint

Consider how many queries are needed to read posts with comments.

🔧 Debug
expert
3:00remaining
Why does this referencing query return empty arrays?

Given collections users and orders, this aggregation returns empty arrays in the orders field. Why?

db.users.aggregate([
  {
    $lookup: {
      from: "orders",
      localField: "_id",
      foreignField: "userId",
      as: "orders"
    }
  }
])
AThe <code>userId</code> field in orders is stored as a string, but <code>_id</code> in users is an ObjectId.
BThe <code>from</code> collection name is misspelled.
CMongoDB does not support $lookup on these collections.
DThe <code>as</code> field must be a string, not an array.
Attempts:
2 left
💡 Hint

Check data types of join fields.

Practice

(1/5)
1. Which scenario is best suited for embedding related data in MongoDB?
easy
A. When related data is large and changes frequently
B. When related data is frequently accessed together and rarely changes
C. When data needs to be shared across many documents
D. When you want to enforce strict relational constraints

Solution

  1. Step 1: Understand embedding use case

    Embedding stores related data inside one document for fast access and atomic updates.
  2. Step 2: Match scenario to embedding benefits

    If data is accessed together and rarely changes, embedding avoids extra lookups and is efficient.
  3. Final Answer:

    When related data is frequently accessed together and rarely changes -> Option B
  4. Quick Check:

    Embedding = fast access, rare changes [OK]
Hint: Embed when data is read together and changes rarely [OK]
Common Mistakes:
  • Embedding large, frequently changing data
  • Embedding data shared across many documents
  • Confusing embedding with referencing
2. Which of the following is the correct way to reference another document in MongoDB?
easy
A. { user: { $ref: 'users', $id: ObjectId('abc123') } }
B. { embedded_user: { name: 'Alice' } } inside the document
C. { user_id: ObjectId('abc123') } inside the document
D. { user: 'Alice' } as a string

Solution

  1. Step 1: Identify referencing syntax

    Referencing stores the ObjectId of another document to link collections.
  2. Step 2: Match correct reference format

    Storing the ObjectId directly (e.g., user_id: ObjectId('abc123')) is the standard referencing method.
  3. Final Answer:

    { user_id: ObjectId('abc123') } inside the document -> Option C
  4. Quick Check:

    Reference = store ObjectId [OK]
Hint: Reference by storing ObjectId, not embedding full data [OK]
Common Mistakes:
  • Embedding full document instead of referencing
  • Using deprecated $ref and $id fields
  • Storing plain strings instead of ObjectId
3. Given two collections: orders with embedded items array, what is the main benefit of embedding items inside orders?
medium
A. Faster retrieval of all items for an order without extra queries
B. Ability to reuse items across multiple orders easily
C. Smaller document size for orders collection
D. Enforcing foreign key constraints automatically

Solution

  1. Step 1: Understand embedding effect on queries

    Embedding items inside orders means all item data is in one document.
  2. Step 2: Identify benefit of embedding items

    This allows fetching an order and its items in a single query, improving speed.
  3. Final Answer:

    Faster retrieval of all items for an order without extra queries -> Option A
  4. Quick Check:

    Embedding = single query fetch [OK]
Hint: Embedding avoids extra queries for related data [OK]
Common Mistakes:
  • Thinking embedding reduces document size
  • Assuming embedded data can be reused easily
  • Expecting automatic foreign key enforcement
4. You have a MongoDB schema where user profiles embed their addresses. You notice address updates are frequent and slow. What is the best fix?
medium
A. Switch to referencing addresses in a separate collection
B. Embed more fields inside the address document
C. Increase the document size limit
D. Add indexes on embedded address fields

Solution

  1. Step 1: Identify problem with embedding frequent updates

    Embedding addresses means updating user documents often, which can be slow and large.
  2. Step 2: Choose solution for frequent changing data

    Referencing addresses separately allows updating addresses independently without rewriting user documents.
  3. Final Answer:

    Switch to referencing addresses in a separate collection -> Option A
  4. Quick Check:

    Frequent updates = use referencing [OK]
Hint: Use referencing for frequently updated data [OK]
Common Mistakes:
  • Adding indexes without fixing schema design
  • Embedding more fields increases document size
  • Increasing document size limit doesn't improve update speed
5. You design a blogging platform where posts have comments. Comments can be many and users want to edit them independently. Which design is best?
hard
A. Embed all comments inside each post document
B. Store comments as plain text fields inside post
C. Embed only the latest comment inside post, others referenced
D. Store comments in a separate collection and reference post ID

Solution

  1. Step 1: Analyze comment characteristics

    Comments can be many and need independent editing, so they change often and grow large.
  2. Step 2: Choose schema design for many, editable comments

    Referencing comments in a separate collection allows independent updates and avoids large post documents.
  3. Final Answer:

    Store comments in a separate collection and reference post ID -> Option D
  4. Quick Check:

    Many editable items = referencing best [OK]
Hint: Many changing items = use referencing, not embedding [OK]
Common Mistakes:
  • Embedding many comments causes large documents
  • Embedding only latest comment complicates queries
  • Storing comments as plain text fields loses structure