Google
PROFESSIONAL-DATA-ENGINEER · Question #30
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 ni
The correct answer is B. Use an ETL tool to load the data from MySQL into Google BigQuery.. Explanation/Reference: BigQuery is a warehouse for analytical workloads, and MySQL is for transactional workloads. You take the data from MySQL to BigQuery apply the necessary transformations and make the analysis there.
Submitted by obi.ng· Mar 30, 2026Building and operationalizing data processing systems
Question
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?
Options
- 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.
How the community answered
(39 responses)- A3% (1)
- B90% (35)
- C3% (1)
- D5% (2)
Explanation
Explanation/Reference: BigQuery is a warehouse for analytical workloads, and MySQL is for transactional workloads. You take the data from MySQL to BigQuery apply the necessary transformations and make the analysis there.
Topics
#ETL#BigQuery#MySQL#OLAP
Community Discussion
No community discussion yet for this question.