Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

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 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
jcmoranp
Highly Voted 4 years, 5 months ago
Bigquery partitioning, A. Federated makes no sense...
upvoted 41 times
tartar
3 years, 7 months ago
A is ok
upvoted 9 times
...
nitinz
3 years ago
A is correct
upvoted 2 times
...
...
Ziegler
Highly Voted 3 years, 10 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 22 times
...
szagarella
Most Recent 1 year, 1 month ago
Selected Answer: A
A is the only correct answer
upvoted 1 times
...
megumin
1 year, 4 months ago
Selected Answer: A
ok for A
upvoted 1 times
...
AzureDP900
1 year, 5 months ago
A is fine
upvoted 2 times
...
Nirca
1 year, 6 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
[Removed]
1 year, 7 months ago
WhatsApp : +1(956)-520-4006 to obtain PMP, CISM, CCNA, CEH, PRINCE2, CISCO, ISTTQB, PRINCE2, AWS/Azure/Sale force/ITIL Foundation/EC- COUNCIL... Get Certified with 100% pass guarantee. Pay after exam. all CISCO, ISACA & EC- COUNCIL certifications For the Below certificates we offer 100% pass guarantee: 1. AWS Certification 2. Sales force 3. Scrum Master 4. Oracle Certification: OCA, OCP 5. Cisco Certification: CCNA, CCNP, CCIE 6. ITIL Foundation & Intermediate 7. Prince 2 Foundation and Practitioner 8. VMWARE Certification 9. Check Point Certification 10. EC-COUNCIL Certification (CEH V-9, CCISO, CND) 11. Cloud Certification 12. IBM Certification 13. HP Certification 14. Citrix Certification 15. Juniper certification 16. Azure 17.Skype 70-333/34 18.PMI (PMP/CAPM/ACP/PBA) 19.ISTQB 20.SAP 21.ISACA (CISA, CISM, CRISC, CGEIT, COBIT) PAYMENT ONLY AFTER CERTIFICATION AND RESULT CONFIRMATION. WhatsApp : +1(956)-520-4006
upvoted 1 times
...
DrishaS4
1 year, 7 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
Nirca
1 year, 8 months ago
Selected Answer: C
C! Expand beyond a single datacenter to decrease latency to the
upvoted 1 times
...
AzureDP900
1 year, 8 months ago
A is right.
upvoted 1 times
...
H_S
1 year, 9 months ago
Selected Answer: A
Bigquery partitioning, A. Federated makes no sense...
upvoted 1 times
...
vincy2202
2 years, 3 months ago
Selected Answer: A
A is the correct answer
upvoted 1 times
...
joe2211
2 years, 4 months ago
Selected Answer: A
vote A
upvoted 1 times
...
MaxNRG
2 years, 5 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, 8 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, 8 months ago
A. Replace the existing data warehouse with BigQuery. Use table partitioning.
upvoted 2 times
...
MamthaSJ
2 years, 8 months ago
Answer is A
upvoted 4 times
...
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
Loading ...