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?
- ABigtable
- BFirestore
- CMemorystore
- DBigQuery
Show answerHide 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.