
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