Practice
Learn
← Quit
0 / 0 correct
System Design
Hard
1 of 40
OLTP vs OLAP: what is the best architecture for running heavy analytics over production data?
A
Run analytics queries on the OLTP primary during peak hours
B
Replicate/ETL production data into a separate analytics store (warehouse or lake) instead of querying the OLTP primary
C
Add indexes for every analytics query on the primary
D
Disable transactions on the primary