You need a relational OLAP solution for analytics over hundreds of terabytes of tabular data. Which Google Cloud product is recommended?
Choose an answer
Tap an option to check your answer.
Correct answer: BigQuery, because it is designed for large-scale processing of tabular data.
Why this is the answer
BigQuery is the recommended solution because it is a fully managed, serverless data warehouse designed for large-scale analytical processing (OLAP) of tabular data, handling petabytes of information efficiently. Its architecture is optimized for complex queries over massive datasets, making it ideal for hundreds of terabytes. Cloud Spanner is a globally distributed, strongly consistent relational database, but it's primarily an OLTP (Online Transaction Processing) system, not optimized for large-scale analytical queries over hundreds of terabytes. Cloud SQL is a fully managed relational database for MySQL, PostgreSQL, and SQL Server, suitable for OLTP workloads and smaller analytical datasets, but not for hundreds of terabytes. Cloud Firestore is a NoSQL document database designed for mobile, web, and server development with real-time synchronization, not for large-scale relational OLAP.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed