Test advanced understanding of scalability and consistency trade-offs in distributed data systems, covering the CAP theorem and its practical implications, PACELC comparisons, CRDT design and use-cases, and conflict-resolution strategies (optimistic vs. pessimistic, LWW, merge functions). Assess ability to analyze architecture choices under failure and latency, evaluate consistency/availability/partition tolerance trade-offs, and recommend appropriate conflict-resolution approaches for given scenarios.