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

Exam Professional Cloud Architect All Questions

View all questions & answers for the Professional Cloud Architect exam

Exam Professional Cloud Architect topic 6 question 5 discussion

Actual exam question from Google's Professional Cloud Architect
Question #: 5
Topic #: 6
[All Professional Cloud Architect Questions]

For this question, refer to the Mountkirk Games case study. You need to analyze and define the technical architecture for the database workloads for your company, Mountkirk Games. Considering the business and technical requirements, what should you do?

  • A. Use Cloud SQL for time series data, and use Cloud Bigtable for historical data queries.
  • B. Use Cloud SQL to replace MySQL, and use Cloud Spanner for historical data queries.
  • C. Use Cloud Bigtable to replace MySQL, and use BigQuery for historical data queries.
  • D. Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
misho
Highly Voted 4 years, 5 months ago
For the people who say it's C in Linux Academy, did you see the Technical requirements there? The old Technical Requirements have the line "Connect to a managed NoSQL database service" but in the Technical Requirements in Google official site and in this question the line is replaced if the following 2 lines "Connect to a transactional database service to manage user profiles and game state Store game activity in a timeseries database service for future analysis". And for them definitely D is the answer!
upvoted 66 times
...
sri007
Highly Voted 4 years, 10 months ago
Correct Answer D Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries. Storing time-series data in Cloud Bigtable is a natural fit, Cloud Spanner scales horizontally and serves data with low latency while maintaining transactional consistency and industry-leading 99.999% (five 9s) availability - 10x less downtime than four nines (<5 minutes per year). Cloud Spanner helps future-proof your database backend. After you load your data into BigQuery, you can query the data in your tables. BigQuery supports two types of queries: Interactive queries, Batch queries
upvoted 40 times
AdityaGupta
4 years, 1 month ago
I agree with above explanation and choice
upvoted 8 times
...
...
ms.umes21
Most Recent 5 months, 2 weeks ago
Selected Answer: D
DDDDDDDDDD
upvoted 1 times
...
MahAli
11 months, 3 weeks ago
Selected Answer: D
Thought it's C then I reviewed the requirements there is transactional database for user profiles
upvoted 1 times
...
devinss
1 year, 2 months ago
Selected Answer: C
I think it should be C. I can't justify using Spanner for transactional data. BigTable supports single-row transactions and can easily handle transactional and time series data at lower cost.
upvoted 2 times
...
omermahgoub
1 year, 11 months ago
D. Use Cloud Bigtable for time series data, use Cloud Spanner for transactional data, and use BigQuery for historical data queries. Based on the technical requirements provided, the best approach for analyzing and defining the technical architecture for the database workloads for Mountkirk Games would be to use Cloud Bigtable for time series data, Cloud Spanner for transactional data, and BigQuery for historical data queries.
upvoted 1 times
...
megumin
2 years ago
Selected Answer: D
ok for D
upvoted 1 times
...
AzureDP900
2 years, 1 month ago
D is right
upvoted 2 times
...
Nirca
2 years, 2 months ago
Selected Answer: D
D - GCP's classics best practice for tests
upvoted 1 times
...
Nirca
2 years, 4 months ago
Selected Answer: D
DDDDD it is
upvoted 1 times
...
OrangeTiger
2 years, 10 months ago
C is worong.Bigtable is NOSQL.Bigtable cant be alternative for MySQL. I think D is correct. Biquery most fit historical data queries.
upvoted 1 times
...
zxcv1234
2 years, 11 months ago
Selected Answer: D
C cannot be the answer
upvoted 1 times
...
ABO_Doma
2 years, 11 months ago
Selected Answer: D
D Correct Answer D
upvoted 1 times
...
ABO_Doma
2 years, 11 months ago
Selected Answer: D
D is the Answer
upvoted 1 times
...
vincy2202
2 years, 11 months ago
Selected Answer: D
D is the correct answer
upvoted 1 times
...
pakilodi
2 years, 11 months ago
Selected Answer: D
Vote D
upvoted 1 times
...
joe2211
3 years ago
Selected Answer: D
vote D
upvoted 2 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 ...