Google
PROFESSIONAL-CLOUD-ARCHITECT · Question #129
You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool. This requires a relational database that can operate on hundreds of terabytes of data…
The correct answer is D. BigQuery, because it is designed for large-scale processing of tabular data. Because this requires a relational database https://cloud.google.com/files/BigQueryTechnicalWP.pdf BigQuery is relational database and suport OLAP Cloud Spanner OLTP
Submitted by chiamaka_o· Mar 30, 2026Designing and planning a cloud solution architecture
Question
You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool. This requires a relational database that can operate on hundreds of terabytes of data. What is the Google- recommended tool for such applications?
Options
- ACloud Spanner, because it is globally distributed
- BCloud SQL, because it is a fully managed relational database
- CCloud Firestore, because it offers real-time synchronization across devices
- DBigQuery, because it is designed for large-scale processing of tabular data
How the community answered
(33 responses)- B3% (1)
- C3% (1)
- D94% (31)
Explanation
Because this requires a relational database https://cloud.google.com/files/BigQueryTechnicalWP.pdf BigQuery is relational database and suport OLAP Cloud Spanner OLTP
Topics
#BigQuery#OLAP#petabyte-scale analytics#database selection
Community Discussion
No community discussion yet for this question.