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?
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.
Answer: C
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund