DataLoader for batching in GraphQL - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the output of this DataLoader batch function?

Consider a DataLoader batch function that receives an array of user IDs and returns user objects in the same order.

Given the following batch function:

async function batchUsers(userIds) {
  const users = await db.query('SELECT * FROM users WHERE id IN (?)', [userIds]);
  return userIds.map(id => users.find(user => user.id === id));
}

What will be the output if userIds is [3, 1, 2] and the database returns users in order [{id:1, name:'Alice'}, {id:2, name:'Bob'}, {id:3, name:'Carol'}]?

GraphQL

async function batchUsers(userIds) {
  const users = await db.query('SELECT * FROM users WHERE id IN (?)', [userIds]);
  return userIds.map(id => users.find(user => user.id === id));
}

A [{id:3, name:'Carol'}, undefined, {id:2, name:'Bob'}]

B [{id:1, name:'Alice'}, {id:2, name:'Bob'}, {id:3, name:'Carol'}]

C [{id:3, name:'Carol'}, {id:1, name:'Alice'}, {id:2, name:'Bob'}]

D [undefined, undefined, undefined]

💡 Hint

Remember DataLoader expects the batch function to return results in the same order as the keys.

The batch function maps each requested ID to the corresponding user object found in the database result. Since userIds is [3,1,2], the output array matches this order with the correct user objects.

🧠 Conceptual

intermediate

Why use DataLoader in GraphQL APIs?

What is the main reason to use DataLoader in a GraphQL API?

A To validate GraphQL schema types automatically

B To batch and cache database requests to reduce redundant queries

C To generate GraphQL queries dynamically

D To encrypt data sent over the network

💡 Hint

Think about performance optimization when fetching data.

DataLoader batches multiple requests for the same resource into a single database query and caches results to avoid duplicate fetching, improving performance.

📝 Syntax

advanced

Identify the syntax error in this DataLoader batch function

Which option contains a syntax error in the batch function for DataLoader?

const batchFunction = async (keys) => {
  const results = await db.query('SELECT * FROM items WHERE id IN (?)', [keys]);
  return keys.map(key => results.find(item => item.id === key));
}

A

}
;))yek === di.meti >= meti(dnif.stluser >= yek(pam.syek nruter  
;)]syek[ ,')?( NI di EREHW smeti MORF * TCELES'(yreuq.bd tiawa = stluser tsnoc  
{ >= )syek( cnysa = noitcnuFhctab tsnoc

B

const batchFunction = async (keys) => {
  const results = await db.query('SELECT * FROM items WHERE id IN (?)', keys);
  return keys.map(key => results.find(item => item.id === key));
}

C

const batchFunction = async keys => {
  const results = await db.query('SELECT * FROM items WHERE id IN (?)', keys);
  return keys.map(key => results.find(item => item.id === key));
}

D

const batchFunction = async (keys) => {
  const results = await db.query('SELECT * FROM items WHERE id IN (?)', [keys]);
  return keys.map(key => results.find(item => item.id === key));
}

💡 Hint

Look carefully at the comparison operator inside the find callback.

Option D uses a single equals sign = instead of a comparison operator ===, causing an assignment instead of comparison, which is a syntax error in this context.

❓ optimization

advanced

How to optimize DataLoader batch function for large key arrays?

You have a DataLoader batch function that receives a large array of keys. Which approach optimizes performance best?

A Split keys into smaller chunks and query the database multiple times in parallel, then combine results

B Query the database once with all keys in a single IN clause

C Cache only the first 10 keys and ignore the rest

D Query the database separately for each key sequentially

💡 Hint

Consider database query limits and parallelism.

Splitting large key arrays into smaller chunks and querying in parallel avoids database query size limits and improves throughput compared to one huge query or many sequential queries.

🔧 Debug

expert

Why does this DataLoader batch function cause incorrect results?

Given this batch function:

async function batch(keys) {
  const rows = await db.query('SELECT * FROM products WHERE id IN (?)', [keys]);
  return rows;
}

Why might this cause incorrect results when used with DataLoader?

A Because the function returns rows in arbitrary order, not matching the order of keys

B Because the query uses IN (?) which is invalid syntax

C Because the function does not cache results

D Because the function does not handle errors

💡 Hint

Think about DataLoader's requirement for batch function output order.

DataLoader expects the batch function to return results in the same order as the keys array. Returning rows directly from the database without reordering can cause mismatched results.