Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 132

Question

You are building a data warehouse on BigQuery. Sources of data include several MySQL databases located on-premises. You need to transfer data from these databases into BigQuery for analytics. You want to use a managed solution that has low latency and is easy to set up. What should you do?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Use Cloud Data Fusion and scheduled workflows to extract data from MySQL. Transform this data into the appropriate schema, and load this data into your BigQuery database. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage. Cloud Data Fusion builds ETL/ELT pipelines visually with little code. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 132