All Questions
Data Modeling hard

In DynamoDB, 'Single Table Design' packs multiple entity types (User, Order, Item) into one table explicitly. What is the primary technical gain?

  1. A It provides a more human-readable view of the schema by consolidating multiple disparately related entities into a single, flat table for easier administrator auditing.
  2. B It enables 'Pre-joined' data retrieval, allowing multiple entity types (e.g., a User and their recent Orders) to be fetched in a single, high-speed physical disk read.
  3. C It bypasses the database's internal hard limits on individual item size by automatically spanning a single record across multiple physically distributed storage blocks.
  4. D It allows the DynamoDB engine to natively support complex, ad-hoc SQL queries and multi-table joins that are typically only available in relational databases.

One system design question a day, with spaced repetition so the ones you miss come back.

Get the app

Related questions