Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Exam Professional-Cloud-Database-Engineer Topic 4 Question 29 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 29
Topic #: 4
[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.

Show Suggested Answer Hide Answer
Suggested Answer: C

by Kristel at Apr 10, 2024, 03:20 PM

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
Darrel
8 days ago
Option B with Cloud Data Fusion also sounds promising. The ability to transform the data as part of the loading process could be really useful. Plus, it's a managed service, so that could make it easier to set up.
upvoted 0 times
...
Aleisha
8 days ago
Hmm, I don't know. Replicating the data to Cloud SQL and then using federated tables in BigQuery sounds a bit convoluted to me. Plus, I'm not a big fan of vendor-specific solutions.
upvoted 0 times
...
Veronika
9 days ago
Hmm, I'm leaning towards option C with Datastream and Dataflow. That seems like a good way to get the data from the on-premises MySQL databases into BigQuery with low latency and minimal setup.
upvoted 0 times
...
Hassie
10 days ago
No kidding! This is like a job interview disguised as an exam question. But I'm kind of enjoying the challenge, to be honest.
upvoted 0 times
...
Malcom
10 days ago
Hey, that's a good point. Option C with Datastream and Dataflow might be a better bet. It seems a bit more flexible, and you can probably tweak the transformation process.
upvoted 0 times
...
Javier
11 days ago
Option B does seem like the easiest to set up, but I'm a little worried about the data transformation part. What if the schema isn't a perfect match?
upvoted 0 times
...
Rikki
11 days ago
Haha, you guys are really digging into this. I feel like we should be getting paid for this level of analysis!
upvoted 0 times
...
Audra
12 days ago
Haha, good luck with that! These days, everything has to be a managed solution with low latency and easy setup. I'm leaning towards option B - Cloud Data Fusion sounds pretty slick.
upvoted 0 times
...
Kate
14 days ago
Yeah, I hear you. I was hoping for something a little more straightforward, you know? Maybe we could just export the data to a CSV and upload it to BigQuery.
upvoted 0 times
...
Alana
16 days ago
Whoa, this is a tough one! I'm not sure I'm comfortable with any of these options. They all seem a bit complex for my liking.
upvoted 0 times
...

Save Cancel