Skip to content
PCA Practice
Q99

A team needs frequent analytics on operational data without overloading the OLTP database. What is best?

  1. AReplicate/stream data to an analytics store such as BigQuery
  2. BRun all BI on primary OLTP
  3. CDisable indexes
  4. DUse bigger passwords
Show answer

Answer: A

Separating OLTP and analytics improves performance and can lower operational risk.

← Q98Practice this topicQ100 →