For this question, refer to the TerramEarth case study. You need to implement a reliable, scalable GCP solution for the data warehouse for your company, TerramEarth. Considering the TerramEarth business and technical requirements, what should you do?
Replace the existing data warehouse with BigQuery. Use table partitioning.
Replace the existing data warehouse with a Compute Engine instance with 96 CPUs.
Replace the existing data warehouse with BigQuery. Use federated data sources.
Replace the existing data warehouse with a Compute Engine instance with 96 CPUs. Add an additional Compute Engine pre-emptible instance with 32 CPUs.