Professional Data Engineer

By Google · Question Mode

QuestionQ33

Preparing and using data for analysis

Your company’s customer and order databases are frequently under heavy load, making it difficult to perform analytics on them without affecting operations.

The databases run in a MySQL cluster, with nightly backups created by using mysqldump. You want to run analytics with minimal operational impact. What should you do?

Explanation

Loading MySQL data into BigQuery through ETL separates analytical workloads from the transactional MySQL cluster. BigQuery is a managed analytical platform whose compute and storage architecture is designed to scale analytics independently, avoiding resource contention with operational database workloads.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!