Practice
Learn
← Quit
0 / 0 correct
System Design
Hard
1 of 880
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
Disable transactions on the primary
C
Replicate/ETL production data into a separate analytics store (warehouse or lake) instead of querying the OLTP primary
D
Add indexes for every analytics query on the primary