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

Show Suggested Answer Hide 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
Loreta
5 days ago
Option C with Datastream and Dataflow seems interesting, but it might be overkill for this use case. I'd want to make sure the setup isn't too complex. Option B with Cloud Data Fusion sounds like a good balance of features.
upvoted 0 times
...
Dan
14 days ago
I'm a bit confused by the `Out` struct and how it's being used with `for_each()`. I'll need to review my understanding of function objects and how they work with the standard library algorithms.
upvoted 0 times
...
Ashanti
15 days ago
This question seems straightforward, I think I can handle it.
upvoted 0 times
...
Kallie
16 days ago
I think the "Guide Me" and "Active IQ" widgets would be the most helpful for identifying and solving issues with the newly deployed array. The "Guide Me" tool can provide step-by-step guidance, while "Active IQ" can give insights and recommendations.
upvoted 0 times
...
Valentine
2 years 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
...
Norah
2 years ago
Ooh, Datastream, huh? That does sound pretty slick. I was also considering Cloud Data Fusion (option B), but you make a good point about the latency and ease of setup. And let's be real, who doesn't love a good 'stream' these days? *winks*
upvoted 0 times
Claribel
1 years ago
Great choice! Datastream should work well for your data warehouse needs.
upvoted 0 times
...
Jacob
1 years ago
Thank you, I'll check out Datastream for my data transfer solution!
upvoted 0 times
...
Stephane
1 years ago
For sure, Datastream can handle the stream well for you.
upvoted 0 times
...
Thomasena
1 years ago
Definitely! Plus, it's always nice to have a 'stream' flowing smoothly.
upvoted 0 times
...
Maybelle
1 years ago
Oh yeah, Datastream can definitely help with low latency and easy setup.
upvoted 0 times
...
Sophia
1 years ago
Datastream sounds like a solid option for your data transfer needs.
upvoted 0 times
...
Frank
1 years ago
C
upvoted 0 times
...
...
Gladis
2 years 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
2 years 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
...

Save Cancel