Professional Cloud ArchitectDemo

By Google · Question Mode

QuestionQ269

Managing implementation

Refer to the TerramEarth case study for this question. You must implement a reliable, scalable GCP data-warehouse solution for your company, TerramEarth.

Considering the TerramEarth business and technical requirements, what should you do?

  • A Replace the existing data warehouse with BigQuery. Use table partitioning.
  • B Replace the existing data warehouse with a Compute Engine instance with 96 CPUs.
  • C Replace the existing data warehouse with BigQuery. Use federated data sources.
  • D Replace the existing data warehouse with a Compute Engine instance with 96 CPUs. Add an additional Compute Engine preemptible instance with 32 CPUs.
Explanation

BigQuery is a managed, serverless data warehouse designed for scalable analytics. Partitioned BigQuery tables divide large datasets into partitions; queries that filter on the partitioning column can prune irrelevant partitions, which improves performance and reduces the amount of data processed and associated query cost.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!