Interview question asked to Data Scientists interviewing at Hopper, Ancestry, Zoox and other companies. Original question asked: What are the core architectural differences between OLTP and OLAP databases?.