SQL Practice Logo

SQLPractice Online

Level 10 - MasterScenario-Based Questionsm2 reliability ha dr multi region

Scenario: Read-After-Write in Multi-Region API

Users in APAC complain about stale reads right after writes due to cross-region replication lag. Propose architecture fix without globally synchronous writes for all traffic.

Schema Context

profiles(profile_id, user_id, updated_at), profile_replica(profile_id, user_id, updated_at)