Google Cloud Professional Data Engineer — Question 27

Your company's customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations.
The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What should you do?

Answer options

• 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.

Correct answer: B

Explanation

Using an ETL tool to load the data from MySQL into Google BigQuery allows for analytics to be performed without impacting the live operational databases. The other options either do not effectively separate the analytics workload from operational load or require additional overhead that may not minimize impact on operations.