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 6 question 1 discussion

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

For this question, refer to the Mountkirk Games case study. Mountkirk Games wants to migrate from their current analytics and statistics reporting model to one that meets their technical requirements on Google Cloud Platform.
Which two steps should be part of their migration plan? (Choose two.)

  • A. Evaluate the impact of migrating their current batch ETL code to Cloud Dataflow.
  • B. Write a schema migration plan to denormalize data for better performance in BigQuery.
  • C. Draw an architecture diagram that shows how to move from a single MySQL database to a MySQL cluster.
  • D. Load 10 TB of analytics data from a previous game into a Cloud SQL instance, and run test queries against the full dataset to confirm that they complete successfully.
  • E. Integrate Cloud Armor to defend against possible SQL injection attacks in analytics files uploaded to Cloud Storage.
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️
by AWS56 at Jan. 13, 2020, 1:36 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
sri007
Highly Voted 4 years, 9 months ago
Correct Answer A, B Evaluate the impact of migrating their current batch ETL code to Cloud Dataflow Write a schema migration plan to denormalize data for better performance in BigQuery. Stream processing (ETL) Dataflow and Reference https://cloud.google.com/bigquery/docs/loading-data#loading_denormalized_nested_and_repeated_data
upvoted 33 times
...
AWS56
Highly Voted 4 years, 9 months ago
agree AB
upvoted 12 times
nitinz
3 years, 7 months ago
it is AB
upvoted 1 times
...
tartar
4 years, 2 months ago
AB is ok
upvoted 8 times
...
...
bigzero
Most Recent 5 months, 2 weeks ago
A,C B is wrong, bigquery support relational structure, so doesn't need schema denormalization, it's bigtable requirements C is right, New MySQL cluster need new architecture for read replica and sharding...
upvoted 1 times
...
megumin
1 year, 11 months ago
ok for AB
upvoted 1 times
...
AzureDP900
2 years ago
A , B right choice
upvoted 1 times
...
alexandercamachop
2 years, 1 month ago
Selected Answer: AB
First remove non sense answers: D / E Now A is a must, the ETL is definitely what Cloud Dataflow does. Now between B / C. Its talking about a lot of data. we know that Cloud SQL is not the best for huge volume of data, plus not real time data. Big Query is the best option
upvoted 5 times
...
AMohanty
2 years, 2 months ago
DeNormalization is an essential part of BigData - Agreed. However we don't know how the Data is. I would be inclined for A and C
upvoted 1 times
RVivek
1 year, 8 months ago
CloudSQL is not recommendad for DB size greater than 1 TB
upvoted 1 times
...
...
joe2211
2 years, 11 months ago
Selected Answer: AB
vote AB
upvoted 2 times
...
BrijMohan08
3 years ago
A and B
upvoted 1 times
...
hongha
3 years, 3 months ago
Refer to updated Mountkik Games (post 01.05.2021) full analysis to prepare for your exams. https://www.youtube.com/watch?v=1w1olPjlPZY&t=6s
upvoted 3 times
...
MamthaSJ
3 years, 3 months ago
Answer is A, B
upvoted 3 times
...
victory108
3 years, 5 months ago
A. Evaluate the impact of migrating their current batch ETL code to Cloud Dataflow. B. Write a schema migration plan to denormalize data for better performance in BigQuery.
upvoted 3 times
...
Ausias18
3 years, 6 months ago
Answers are A, B
upvoted 1 times
...
lynx256
3 years, 7 months ago
AB is ok
upvoted 1 times
...
bnlcnd
3 years, 9 months ago
A ETL --> Dataflow B https://cloud.google.com/solutions/bigquery-data-warehouse#managing_data
upvoted 2 times
...
noussy
3 years, 9 months ago
why B ?
upvoted 3 times
...
AdityaGupta
4 years ago
Correct answer is AB Cloud Dataflow -- Stream data (mobile devices) BigQuery --------- Intensive Analytics + historic data Both are FULLY MANAGED services.
upvoted 5 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago