Explanation:
Correct Option: C. BigQuery
BigQuery is the optimal choice for this scenario due to its serverless architecture, which allows for interactive SQL queries across vast datasets without the need for infrastructure management. It is specifically designed for large-scale data analysis, offering:
Why other options are less suitable:
Ultimate access to all questions.
No comments yet.
You are a data scientist working on a project that involves exploratory data analysis (EDA) on a dataset that is expected to grow beyond 100 TB. The project requires interactive querying capabilities to quickly iterate on hypotheses and visualize data insights. The solution must be cost-effective, scalable, and support standard SQL for ease of use. Which Google Cloud service is the BEST choice for this scenario? Choose one correct option.
A
Cloud Spanner - A fully managed relational database service that offers horizontal scalability and strong consistency, but is not optimized for interactive analysis of large datasets.
B
Cloud Storage - A highly durable and available object storage service that lacks built-in querying capabilities for interactive data analysis.
C
BigQuery - A fully managed, serverless data warehouse that enables scalable analysis over petabytes of data with SQL queries and integrates with visualization tools.
D
Cloud Functions - A serverless execution environment for building and connecting cloud services, not designed for large-scale data analysis tasks.