Answer-first summary for fast verification
Answer: BigQuery, because it is designed for large-scale processing of tabular data
The correct answer is D: BigQuery. BigQuery is a fully managed data warehouse that is optimized for large-scale data processing, making it ideal for handling hundreds of terabytes of data. It supports SQL queries and is designed specifically for analytical processing (OLAP) and reporting. While Cloud Spanner, Cloud SQL, and Cloud Firestore have their own use cases, they are not as well-suited for the requirements of handling large-scale OLAP tasks as BigQuery.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with building an online analytical processing (OLAP) marketing analytics and reporting tool for a large-scale enterprise. The tool needs to efficiently handle, process, and analyze hundreds of terabytes of data while ensuring performance and scalability. Given these requirements, which Google Cloud Platform service would be most suitable for this application?
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
No comments yet.