
Ultimate access to all questions.
You are tasked with finding a cost-effective solution to retrieve large datasets of medical information from a database exceeding 10 TBs. The solution should allow for storing this data in new tables for further querying, feature a low-maintenance architecture, and be accessible via SQL. Which option would you choose?
A
Deploy a MySQL cluster on a Compute Engine managed instance group to ensure scalability.
B
Opt for Cloud Spanner to replicate data across regions and organize it into normalized tables.
C
Utilize Cloud SQL, structure your data into tables, and employ JOIN operations in your queries for data retrieval.
D
Choose BigQuery as your data warehouse solution, configuring output destinations for caching extensive queries.