Answer-first summary for fast verification
Answer: 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.
The question asks for two steps in Mountkirk Games' migration plan for analytics and statistics reporting to Google Cloud Platform. Option A (Evaluate migrating batch ETL to Cloud Dataflow) is optimal because Cloud Dataflow is a fully managed service for stream and batch processing, aligning with modern analytics needs. Option B (Write a schema migration plan to denormalize data for BigQuery) is correct as denormalization improves query performance in BigQuery by reducing joins, which is a best practice for large-scale analytics. The community discussion strongly supports A and B, with high upvotes (e.g., 34 upvotes for AB) and reasoning that emphasizes Cloud Dataflow for ETL and BigQuery for analytics. Option C is less suitable as it focuses on database clustering, which is not directly related to analytics reporting. Option D is incorrect because loading 10 TB into Cloud SQL is inefficient and costly for analytics; BigQuery is preferred. Option E is irrelevant, as SQL injection defenses are not a core part of analytics migration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Mountkirk Games is migrating its analytics and statistics reporting model to Google Cloud Platform. Which two steps 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.