Which two migration tasks should be included when moving analytics and reporting to GCP? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct 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..
Why this is the answer
Migrating analytics and reporting to GCP often involves modernizing data processing and storage. Evaluating the impact of migrating existing batch ETL code to Cloud Dataflow is crucial because Dataflow is a fully managed service ideal for large-scale data processing, offering scalability and efficiency for ETL workloads. Writing a schema migration plan to denormalize data for BigQuery is also essential. BigQuery is an analytical data warehouse optimized for denormalized data, which significantly improves query performance compared to traditional normalized schemas. Moving to a MySQL cluster is not directly related to analytics and reporting migration but rather operational database scaling. Loading 10 TB into Cloud SQL for analytics is generally inefficient; BigQuery is better suited for such large analytical datasets. Cloud Armor protects against web application attacks, not SQL injection in static analytics files in Cloud Storage.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed