Google Exam Professional Cloud Database Engineer Topic 14 Question 24 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam

Question #: 24
Topic #: 14

[All Professional Cloud Database Engineer Questions]

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?

A. Create extracts from your on-premises databases periodically, and push these extracts to Cloud Storage. Upload the changes into BigQuery, and merge them with existing tables.

BUse 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.

CUse Datastream to connect to your on-premises database and create a stream. Have Datastream write to Cloud Storage. Then use Dataflow to process the data into BigQuery.

DUse Database Migration Service to replicate data to a Cloud SQL for MySQL instance. Create federated tables in BigQuery on top of the replicated instances to transform and load the data into your BigQuery database.

Show Suggested Answer

Suggested Answer: C

by Kayleigh at Dec 21, 2023, 09:05 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Valentine

9 months ago

Haha, Norah, you and your streams! But in all seriousness, I think you two are onto something. Datastream does seem like the way to go here. The fact that it handles the transfer and processing is a big plus. Plus, I like the idea of not having to worry about setting up a bunch of separate components.

upvoted 0 times

...

9 months ago

upvoted 0 times

...

Gladis

9 months ago

I agree, Kimberlie. Option A seems a bit too manual and prone to latency issues. And option D, while interesting, feels like overkill for this use case. I'm leaning towards Datastream (option C) since that seems to handle the data transfer and processing all in one managed solution.

upvoted 0 times

...

Kimberlie

9 months ago

Hmm, this question seems to be testing our knowledge of different data transfer solutions for BigQuery. I'm a bit torn between options B and C. Both seem like they could work, but I'm not sure which one would be the most 'low latency and easy to set up' as the question asks for.

upvoted 0 times

...