Exam Professional Cloud Architect topic 9 question 3 discussion

Bigquery partitioning, A. Federated makes no sense...

A is the correct answer because the question was asking for a reliable way of improving the data warehouse. The reliable way is to have a table partitioned and that can be well managed. https://cloud.google.com/solutions/bigquery-data-warehouse BigQuery supports partitioning tables by date. You enable partitioning during the table-creation process. BigQuery creates new date-based partitions automatically, with no need for additional maintenance. In addition, you can specify an expiration time for data in the partitions. https://cloud.google.com/solutions/bigquery-data-warehouse#partitioning_tables Federated is an option but not a reliable option. You can run queries on data that exists outside of BigQuery by using federated data sources, but this approach has performance implications. Use federated data sources only if the data must be maintained externally. You can also use query federation to perform ETL from an external source to BigQuery. This approach allows you to define ETL using familiar SQL syntax. https://cloud.google.com/solutions/bigquery-data-warehouse#external_sources

A is the only correct answer

ok for A

A is fine

Bigquery partitioning, A. Federated makes no sense...

Bigquery partitioning, A. Federated makes no sense...

C! Expand beyond a single datacenter to decrease latency to the

A is right.

Bigquery partitioning, A. Federated makes no sense...

A is the correct answer

vote A

A – BigQuery in time-partitioned mode. C – federated data source won’t be effective. It assumes that time-series data is stored in BigTable and BigQuery federates this table for analytics. But, that’s expensive. - BigTable charges for egress 0.08 $ GB/read (that adds charges in analytics mode) - BigTable (HDD) – 0.026 $ GB/mo vs BigQuery 0.010 $ GB/mo (and first 10 GB are free monthly). So, no point for BigTable at all. Stream everything to BiqQuery for storage and analytics. Also, BiqQuery can setup partitions expiration period.

Answer A o Existing Datawarehouse was hosted on single PostgreSQL server on with below configuration, replacing it with serverless Bigquery using table partition is best recommended soltuion  RedHat Linux  64 CPUs  128 GB of RAM  4x 6TB HDD in RAID 0

A. Replace the existing data warehouse with BigQuery. Use table partitioning.

Answer is A

Answer is A