Skip to content
PCA Practice
SQ42

An analytics team runs complex SQL joins over 50 TB of historical data, primarily for dashboards refreshed hourly. Which storage/query engine is most appropriate?

  1. ABigtable
  2. BFirestore
  3. CMemorystore
  4. DBigQuery
Show answer

Answer: D

BigQuery is the serverless analytics warehouse built for complex SQL over massive datasets. Bigtable doesn't support SQL joins. Memorystore is for caching. Firestore is a document database.

← SQ41Practice this topicSQ43 →