Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

Exam Professional Cloud Architect topic 9 question 3 discussion

Actual exam question from Google's Professional Cloud Architect

Question #: 3
Topic #: 9

[All Professional Cloud Architect Questions]

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?

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by jcmoranp at Oct. 26, 2019, 1:25 p.m.

Comments

Submit Cancel

jcmoranp

Highly Voted 4 years, 1 month ago

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

upvoted 41 times

tartar

3 years, 4 months ago

A is ok

upvoted 9 times

...

nitinz

2 years, 9 months ago

A is correct

upvoted 2 times

...

Ziegler

Highly Voted 3 years, 6 months ago

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

upvoted 24 times

...

szagarella

Most Recent 9 months, 3 weeks ago

Selected Answer: A

A is the only correct answer

upvoted 1 times

...

megumin

1 year, 1 month ago

Selected Answer: A

ok for A

upvoted 1 times

...

AzureDP900

1 year, 2 months ago

A is fine

upvoted 2 times

...

Nirca

1 year, 3 months ago

Selected Answer: A

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

upvoted 1 times

...

DrishaS4

1 year, 4 months ago

Selected Answer: A

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

upvoted 1 times

...

Nirca

1 year, 4 months ago

Selected Answer: C

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

upvoted 1 times

...

AzureDP900

1 year, 5 months ago

A is right.

upvoted 1 times

...

H_S

1 year, 6 months ago

Selected Answer: A

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

upvoted 1 times

...

vincy2202

2 years ago

Selected Answer: A

A is the correct answer

upvoted 1 times

...

joe2211

2 years ago

Selected Answer: A

vote A

upvoted 1 times

...

MaxNRG

2 years, 1 month ago

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.

upvoted 3 times

...

VishalB

2 years, 5 months ago

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

upvoted 2 times

...