nerdexam
Google

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.

Identifying appropriate Google Cloud data analytics and warehousing solutions

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)
  • A
    3% (1)
  • B
    10% (3)
  • C
    84% (26)
  • D
    3% (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.

ACloud Spanner

Cloud Spanner is a globally distributed, strongly consistent relational database designed for transactional OLTP workloads, not analytical data warehousing or smart analytics.

BCompute Engine

Compute Engine provides raw virtual machine instances and requires the organization to manage all infrastructure, software, and scaling - the opposite of a serverless solution.

CBigQueryCorrect

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.

DDataflow

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

#BigQuery#Data Warehousing#Serverless#Smart Analytics

Community Discussion

No community discussion yet for this question.

Full CLOUD-DIGITAL-LEADER Practice