
Ultimate access to all questions.
For the Helicopter Racing League (HRL) case study, considering the need for a cost-effective solution to store all historical race data like telemetry, train models exclusively on the previous season's data, and plan for future growth in data volume and complexity, what data solution should you propose?
A
Use Firestore for its scalable and flexible document-based database. Use collections to aggregate race data by season and event.
B
Use Cloud Spanner for its scalability and ability to version schemas with zero downtime. Split race data using season as a primary key.
C
Use BigQuery for its scalability and ability to add columns to a schema. Partition race data based on season.
D
Use Cloud SQL for its ability to automatically manage storage increases and compatibility with MySQL. Use separate database instances for each season.