Professional Cloud ArchitectDemo

By Google · Question Mode

QuestionQ360

Managing implementation

Refer to the Mountkirk Games case study. Mountkirk Games wants to move from its current analytics and statistics reporting model to one that satisfies its technical requirements on Google Cloud Platform.

Which two actions should be included in 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.
Explanation

Cloud Dataflow supports batch processing pipelines, so the effect of moving existing batch ETL code to Dataflow should be evaluated. BigQuery performance can benefit from denormalized schemas, particularly through nested and repeated fields that reduce expensive joins in analytics workloads.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!