CLOUD-DIGITAL-LEADER · Question #413
An organization has collected petabytes of historical data. They need an advanced analysis solution that is fast, scalable, and fully managed. Which Google product or service should the organization u
The correct answer is A. BigQuery. BigQuery is Google Cloud's fully managed, serverless data warehouse designed for fast and scalable advanced analytics over petabyte-scale datasets.
Question
An organization has collected petabytes of historical data. They need an advanced analysis solution that is fast, scalable, and fully managed. Which Google product or service should the organization use?
Options
- ABigQuery
- BCloud SQL
- CFirestore
- DCloud Storage
How the community answered
(46 responses)- A76% (35)
- B2% (1)
- C15% (7)
- D7% (3)
Why each option
BigQuery is Google Cloud's fully managed, serverless data warehouse designed for fast and scalable advanced analytics over petabyte-scale datasets.
BigQuery is a serverless, highly scalable data warehouse that can analyze petabytes of data using SQL without requiring infrastructure management. It uses a columnar storage format and a massively parallel query engine that delivers fast query results even over enormous datasets. Its fully managed nature means no servers to provision or maintain, directly satisfying all stated requirements.
Cloud SQL is a managed relational database optimized for transactional (OLTP) workloads and does not scale to petabyte-level analytical queries.
Firestore is a serverless NoSQL document database designed for application data storage and retrieval, not for advanced analytics over petabytes of historical data.
Cloud Storage is an object store for data at rest and does not provide built-in analytical query capabilities.
Concept tested: BigQuery for petabyte-scale data warehousing and analytics
Source: https://cloud.google.com/bigquery/docs/introduction
Topics
Community Discussion
No community discussion yet for this question.