You must provide low-maintenance, SQL-accessible analytics for very large result sets (>10 TB) and store query results for further analysis. Which solution is most cost-effective and scalable?
Choose an answer
Tap an option to check your answer.
Correct answer: Use BigQuery as a data warehouse. Set output destinations for caching large queries..
Why this is the answer
BigQuery is a fully managed, serverless data warehouse designed for petabyte-scale analytics, making it ideal for very large result sets (10 TB). Its columnar storage and distributed query engine provide high performance and scalability without requiring manual infrastructure management, thus offering low maintenance. Setting output destinations for caching large queries further optimizes performance and cost for repeated analyses. Cloud SQL is a relational database not optimized for petabyte-scale analytics. A MySQL cluster on Compute Engine requires significant management overhead and doesn't scale as efficiently or cost-effectively for this data volume. Cloud Spanner is a globally distributed relational database, but it's designed for transactional workloads requiring strong consistency and high availability, not primarily for cost-effective, petabyte-scale analytical queries.
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