Answer-first summary for fast verification
Answer: 1. Store the data in BigQuery. 2. Run SQL queries in BigQuery.
**Correct Answer: C** - **Option A** is not suitable because Cloud Bigtable is optimized for high-throughput, low-latency access to structured data and may not efficiently support ad hoc SQL queries. - **Option B** introduces unnecessary complexity by using HDFS storage with Dataproc on Google Cloud, which is not recommended for simple SQL queries. - **Option C** is the correct choice as BigQuery is designed for fast, scalable, and cost-effective analytics, allowing direct SQL queries on stored data. - **Option D**, similar to Option B, is not cost-effective due to the continuous running of the Dataproc cluster and the overuse of Spark for simple queries. For more information, visit [Google BigQuery Documentation](https://cloud.google.com/bigquery/docs).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your AI research team requires an environment for executing ad hoc SQL queries on a large dataset daily for about an hour, with the need for immediate access at any time. What is the most cost-effective solution for this scenario?
A
B
C
D
No comments yet.