What is the primary purpose of Google BigQuery?
- Manage databases
- Run virtual machines
- Analyze large datasets using SQL queries for data analytics and business intelligence ✓
- Store large files
Correct answer: Analyze large datasets using SQL queries for data analytics and business intelligence
Option C is correct because Google BigQuery is a fully managed, serverless data warehouse designed specifically for analyzing large datasets using SQL queries, making it the backbone of data analytics and business intelligence workloads on Google Cloud. Option A is wrong because managing relational databases is the purpose of services like Cloud SQL or Cloud Spanner, not BigQuery. Option B is wrong because running virtual machines is the function of Google Compute Engine, an entirely different service category. Option D is wrong because storing large files is handled by Google Cloud Storage, which is an object storage service rather than an analytical query engine.
Topic: · bigquery, data analytics, sql, data warehouse