Answer-first summary for fast verification
Answer: Use an ETL tool to load the data from MySQL into Google BigQuery.
The correct answer is B: Use an ETL tool to load the data from MySQL into Google BigQuery. BigQuery is a serverless, highly scalable data warehouse that can handle large-scale analytics workloads without impacting your MySQL cluster's performance. By using an ETL tool to transfer data from MySQL to BigQuery, you can maintain a separate analytics environment, ensuring that your operational database remains unaffected, which is essential given that the databases are often under heavy load.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company experiences heavy load on its MySQL cluster databases that store customer and order information. This high load complicates performing analytics directly on the live databases, as it could disrupt normal operations. Currently, you take nightly backups of these databases using mysqldump. You need to find a way to conduct analytics without adversely affecting the operational performance of your databases. What approach should you take?
A
Add a node to the MySQL cluster and build an OLAP cube there.
B
Use an ETL tool to load the data from MySQL into Google BigQuery.
C
Connect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
D
Mount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.
No comments yet.