Google Cloud Professional Cloud Architect — Question 92

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?

Answer options

• A. Cloud Spanner, because it is globally distributed
• B. Cloud SQL, because it is a fully managed relational database
• C. Cloud Firestore, because it offers real-time synchronization across devices
• D. BigQuery, because it is designed for large-scale processing of tabular data

Correct answer: D

Explanation

BigQuery is the correct choice as it is specifically designed for handling large-scale data analytics and can efficiently process vast amounts of tabular data. While Cloud Spanner is globally distributed, it is more suited for transactional workloads rather than analytical processing. Cloud SQL is a fully managed relational database but is not optimized for handling large datasets at the scale required here, and Cloud Firestore is aimed at real-time data synchronization rather than OLAP tasks.