45Last night's failover left both database nodes accepting writes for four minutes. Finance wants to know which orders are real.▼hard★ EssentialNewJPMorgan ChasePhonePeOracle◆ premiumSplit-brain writes are a fencing failure first and a data problem second. Freeze writes, read the divergence boundary from replication positions, and let the payment ledger arbitrate reality.Open full answer →
47Yesterday's security group cleanup looked routine, and today the DR site runs hours behind on replication. Connect the dots.▼mediumNewAmazon & AWSMicrosoftWalmart Global Tech◆ premiumStateful firewalls keep established flows alive after their rule vanishes, so cleanup day passes every check and lag appears days later. Flow logs name the hour; inventories prevent the repeat.Open full answer →
01Design a disaster recovery plan for a 5PB data platform with a four-hour recovery objective.▼hard★ EssentialNewGoogleAmazonSnowflake2 repliesunlockedThe classic napkin-math question. The number in the prompt is the question, and candidates who draw the architecture before doing the arithmetic design something the physics forbids.Open full answer →
02Design multi-region active-active for a tier-1 API. What breaks, and what does it cost?▼hard★ EssentialNewNetflixStripeUber2 repliesunlockedThe design round where the honest answer is mostly about data. Stateless traffic across regions is straightforward; the database is where active-active is either solved or pretended.Open full answer →
05Make a Postgres database highly available. What are you actually promising, and what breaks?▼hard★ EssentialNewAmazonRazorpaySnowflake2 repliesunlockedEvery candidate says replication and failover. The scoring answer names the replication mode, states the resulting data loss window, and explains how the cluster avoids two primaries.Open full answer →
22Design the session store for fifty million daily users. Sticky sessions or stateless tokens, and who expires expired sessions?▼mediumNewAmazon & AWSFlipkartPhonePe◆ premiumSize stored sessions from expiry and creation rates, then decide how quickly logout must take effect and what failover may forget.Open full answer →