fr

Daily Challenge 🗓️

Your daily dose of technical intelligence to shine in (developer) society.

Discover a software development quiz per day with its detailed correction.

Frontend, Backend, Mobile, Data, Web, AI, Infra... Everything that can be coded!

Monday 5 January 2026

-

Infrastructure Architecture

Infrastructure Architecture #14/18

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:

Author: W3D TeamStatus: Published(Update)Question passed 32 times
0
Reviews from developers
developer avatar
Auteur anonyme
08/11/2024
Indeed

About Daily Challenge 🗓️

From Monday to Friday, discover each day a quiz question with its detailed answer to enrich your tech knowledge. The questions are proposed by the WeLoveDevs.com community: experienced developers, trainers and freelancers.WeLoveDevs.com helps developers to find their dream job. We also provide over 50 free technical tests in different technologies for those of you who would like to test your knowledge.

History

    ⚠️
    Your browser is badly|not supported!
    We recommend you to use a more modern browser such as Edge, Chrome or Firefox
    Know More