ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam
Go to 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 Hide Answer
Suggested Answer: A 🗳️
by jcmoranp at Oct. 26, 2019, 1:25 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jcmoranp
Highly Voted 4 years, 3 months ago
Bigquery partitioning, A. Federated makes no sense...
upvoted 41 times
tartar
3 years, 5 months ago
A is ok
upvoted 9 times
...
nitinz
2 years, 11 months ago
A is correct
upvoted 2 times
...
...
Ziegler
Highly Voted 3 years, 8 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 11 months, 2 weeks ago
Selected Answer: A
A is the only correct answer
upvoted 1 times
...
megumin
1 year, 3 months ago
Selected Answer: A
ok for A
upvoted 1 times
...
AzureDP900
1 year, 3 months ago
A is fine
upvoted 2 times
...
Nirca
1 year, 4 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
DrishaS4
1 year, 6 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
Nirca
1 year, 6 months ago
Selected Answer: C
C! Expand beyond a single datacenter to decrease latency to the
upvoted 1 times
...
AzureDP900
1 year, 7 months ago
A is right.
upvoted 1 times
...
H_S
1 year, 7 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
vincy2202
2 years, 1 month ago
Selected Answer: A
A is the correct answer
upvoted 1 times
...
joe2211
2 years, 2 months ago
Selected Answer: A
vote A
upvoted 1 times
...
MaxNRG
2 years, 3 months 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, 6 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
...
victory108
2 years, 6 months ago
A. Replace the existing data warehouse with BigQuery. Use table partitioning.
upvoted 2 times
...
MamthaSJ
2 years, 7 months ago
Answer is A
upvoted 4 times
...
Ausias18
2 years, 10 months ago
Answer is A
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel