Google Cloud Professional Data Engineer PDE — Topic 1 Question 30

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use an ETL tool to load the data from MySQL into Google BigQuery. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 30