CLOUD-DIGITAL-LEADER · Question #330
An international bank is looking for a serverless warehouse solution that lets them perform smart analytics. Which Google Cloud product or service should the bank use?
The correct answer is C. BigQuery. BigQuery is Google Cloud's fully serverless, managed data warehouse that supports SQL-based analytics and built-in machine learning, making it the appropriate choice for smart analytics without infrastructure management overhead.
Question
An international bank is looking for a serverless warehouse solution that lets them perform smart analytics. Which Google Cloud product or service should the bank use?
Options
- ACloud Spanner
- BCompute Engine
- CBigQuery
- DDataflow
How the community answered
(31 responses)- A3% (1)
- B10% (3)
- C84% (26)
- D3% (1)
Why each option
BigQuery is Google Cloud's fully serverless, managed data warehouse that supports SQL-based analytics and built-in machine learning, making it the appropriate choice for smart analytics without infrastructure management overhead.
Cloud Spanner is a globally distributed, strongly consistent relational database designed for transactional OLTP workloads, not analytical data warehousing or smart analytics.
Compute Engine provides raw virtual machine instances and requires the organization to manage all infrastructure, software, and scaling - the opposite of a serverless solution.
BigQuery is a serverless data warehouse where Google manages all underlying infrastructure, so the bank never provisions or scales servers. It supports ANSI SQL for large-scale analytics and integrates BigQuery ML, which allows data scientists to build and run ML models directly on the warehouse data - enabling the 'smart analytics' requirement.
Dataflow is a managed service for building data ingestion and transformation pipelines; it processes and moves data but is not itself a warehouse or analytics query engine.
Concept tested: BigQuery serverless data warehouse and analytics
Source: https://cloud.google.com/bigquery/docs/introduction
Topics
Community Discussion
No community discussion yet for this question.