Exam Professional Cloud Architect topic 3 question 5 discussion

Actual exam question from Google's Professional Cloud Architect

Question #: 5
Topic #: 3

[All Professional Cloud Architect Questions]

For this question, refer to the Helicopter Racing League (HRL) case study. HRL is looking for a cost-effective approach for storing their race data such as telemetry. They want to keep all historical records, train models using only the previous season's data, and plan for data growth in terms of volume and information collected. You need to propose a data solution. Considering HRL business requirements and the goals expressed by CEO S. Hawke, what should you do?

A. Use Firestore for its scalable and flexible document-based database. Use collections to aggregate race data by season and event.
B. Use Cloud Spanner for its scalability and ability to version schemas with zero downtime. Split race data using season as a primary key.
C. Use BigQuery for its scalability and ability to add columns to a schema. Partition race data based on season.
D. Use Cloud SQL for its ability to automatically manage storage increases and compatibility with MySQL. Use separate database instances for each season.

Show Suggested Answer

Suggested Answer: C 🗳️

by manhmaluc at June 30, 2021, 2:09 p.m.

Comments

Submit Cancel

MamthaSJ

Highly Voted 3 years, 5 months ago

Answer is C

upvoted 17 times

Wonka

2 years, 11 months ago

These questions are sounding too simple, are these really coming in exam or these are mocked up?

upvoted 3 times

ashrafh

2 years ago

In exam actually :)

upvoted 6 times

...

victory108

Highly Voted 3 years, 4 months ago

C. Use BigQuery for its scalability and ability to add columns to a schema. Partition race data based on season.

upvoted 6 times

...

Gino17m

Most Recent 7 months, 2 weeks ago

Vote for C

upvoted 1 times

...

Prakzz

1 year, 2 months ago

How can it be C because BigQuery only support timestamp based partitions?

upvoted 1 times

parthkulkarni998

11 months, 3 weeks ago

Exactly. That means it will use timestamp of season for partition

upvoted 2 times

...

Kamngur

1 year, 3 months ago

C looks good. Remember Telemetry would be stored and used for predictions later A. would be good if it would be stored only, as documents. B. Spanner is over kill. It is too expensive and we have no need to serve this data outside D. Cloud SQL is too simple solution and use multiple db's is only complicating architecture.

upvoted 5 times

...

examch

1 year, 11 months ago

Selected Answer: C

C is the correct Answer, We can use BigQuery for making Predictions with live and trained data with Cloud ML Engine, and BigQuery can handle large amounts of data. Refer to the Link for more details on Game Predictions, https://cloud.google.com/blog/products/gcp/architecting-live-ncaa-predictions-from-archives-to-insights

upvoted 6 times

...