
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.