Question 30 of 307
Single answerYour 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?
AAdd a node to the MySQL cluster and build an OLAP cube there.
✓BUse an ETL tool to load the data from MySQL into Google BigQuery.
CConnect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
DMount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.
✓
Correct Answer: B
Use an ETL tool to load the data from MySQL into Google BigQuery.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.