2 / 6 SQL vs NoSQL & Data Models

One Query Or A Scan

A single DynamoDB table stores several entity types in one item collection per organization:

PK SK attributes
ORG#42 META name, plan, seats
ORG#42 USER#7 email, role
ORG#42 USER#9 email, role
ORG#42 PROJ#a1 title, status
ORG#42 PROJ#b2 title, status
ORG#88 META name, plan, seats

Which access pattern cannot be served by a Query against this table, and forces either a full table Scan or a new global secondary index?

A

Fetch the organization record for org 88 on its own.

B

Given only the address dana@acme.io, find which organization that account belongs to.

C

Load the organization record plus every user and every project for org 42 in a single request.

D

List only the users of org 42, in sort key order.