Question from the Infrastructure Architecture test

Your application is an address directory saved in a single database table/document. Each entry contains:

A name, an address (street number and name), and a postal code
The name of the entry's creator (unique).

All users of your application can access all addresses in the database.
Users can only request entries with a specific postal code.
You are asked to partition this table.

This means:

Replicating the table across multiple slave servers to distribute the requests
Splitting the table into multiple sub-tables, with each entry appearing in only one table.

Which partitioning keys would ensure that each query reaches only one table: