Skip to content
PCA Practice
SQ69

A BI team needs sub-second query responses on a frequently accessed BigQuery dashboard dataset of 200 GB. Which feature helps most?

  1. ABigQuery BI Engine
  2. BAdd more partitions
  3. CExport to Memorystore
  4. DUse Cloud SQL instead
Show answer

Answer: A

BI Engine provides in-memory analysis for sub-second interactive query responses on dashboards. It's designed exactly for accelerating BI workloads on smaller hot datasets.

← SQ68Practice this topicSQ70 →