Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to s

The correct answer is B. BigQuery. BigQuery is Google Cloud's fully managed, serverless data warehouse designed specifically for analytics and reporting at petabyte scale. It supports standard SQL, handles hundreds of terabytes with ease, and is optimized for OLAP (Online Analytical Processing) workloads typical o

Designing Data Warehousing and Analytics Solutions

Question

Your organization has a ticketing system that needs an online marketing analytics and reporting application. You need to select a relational database that can manage hundreds of terabytes of data to support this new application. Which database should you use?

Options

ACloud SQL
BBigQuery
CCloud Spanner
DBigtable

How the community answered

(53 responses)

A
2% (1)
B
81% (43)
C
6% (3)
D
11% (6)

Explanation

BigQuery is Google Cloud's fully managed, serverless data warehouse designed specifically for analytics and reporting at petabyte scale. It supports standard SQL, handles hundreds of terabytes with ease, and is optimized for OLAP (Online Analytical Processing) workloads typical of marketing analytics. Cloud SQL (A) is a managed OLTP relational database that tops out at a few tens of TB and is not designed for large-scale analytical queries. Cloud Spanner (C) is a globally distributed relational database built for OLTP with strong consistency - not optimized for complex analytical reporting at this scale. Bigtable (D) is a NoSQL wide-column store, not a relational database, and not suited for SQL-based analytics.

Topics

#Data Warehousing#BigQuery#Analytics Databases#Scalable Databases

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice