SQ69
A BI team needs sub-second query responses on a frequently accessed BigQuery dashboard dataset of 200 GB. Which feature helps most?
- ABigQuery BI Engine
- BAdd more partitions
- CExport to Memorystore
- DUse Cloud SQL instead
Show answerHide 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.