GCP (Google Cloud Platform) fundamentals sample question with answer 36

Question:
You want to analyze sales trends. To help achieve this, you want to combine data from your on-premises Oracle database with Google Analytics data and your web server logs. Where might you store the data so it is both easy to query and cost-effective?

1. Firestore
2. Spanner
3. Cloud SQL
4. BigQuery

Answer:
D - this answer is correct. BigQuery is a data warehouse used for data analytics, and so is built for this type of use case. It provides the infrastructure to ingest data from many different sources, which is a requirement too. The cost model of paying for storage and then only for queries run is attractive too