Interview question asked to Data Scientists interviewing at Chewy, Salesforce, Virta and other companies. Original question asked: What are the specific ACID compliance trade-offs when designing a modern OLAP columnar database compared to a traditional OLTP row store?.