Q99
A team needs frequent analytics on operational data without overloading the OLTP database. What is best?
- AReplicate/stream data to an analytics store such as BigQuery
- BRun all BI on primary OLTP
- CDisable indexes
- DUse bigger passwords
Show answerHide answer
Answer: A
Separating OLTP and analytics improves performance and can lower operational risk.