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