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 2 Question 47 Discussion

Actual exam question for Google's Professional Cloud Database Engineer exam
Question #: 47
Topic #: 2
[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 Teddy at Oct 24, 2024, 12:22 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
Eura
3 months ago
I wonder if the 'Cloud' in 'Cloud Data Fusion' means we'll be fusing our data with the weather. Gotta love these tech companies and their whimsical naming conventions.
upvoted 0 times
Layla
3 months ago
C) Use 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.
upvoted 0 times
...
Ricki
3 months ago
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.
upvoted 0 times
...
Kirk
3 months ago
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.
upvoted 0 times
...
...
Annette
4 months ago
Option D with Database Migration Service sounds interesting, but I'm not sure about the extra step of creating federated tables in BigQuery.
upvoted 0 times
...
Nobuko
4 months ago
Is it just me, or does Option C sound like a secret government surveillance program? 'Datastream'? 'Dataflow'? Sounds like they're trying to track our every move!
upvoted 0 times
Chantell
3 months ago
Haha, maybe we should stick to a more straightforward option for our data warehouse.
upvoted 0 times
...
Annette
3 months ago
I agree, it does sound a bit like a spy program.
upvoted 0 times
...
Alline
3 months ago
Option C does sound a bit suspicious with those names.
upvoted 0 times
...
...
Pansy
4 months ago
I agree with Linwood. Using Datastream and Dataflow seems like the most efficient way to transfer data from on-premises databases to BigQuery.
upvoted 0 times
...
Linwood
4 months ago
I think option C is the best choice. Datastream and Dataflow can help us transfer data with low latency.
upvoted 0 times
...
Lisbeth
5 months ago
Option B looks good, Cloud Data Fusion seems like a straightforward way to get the data into BigQuery with minimal hassle.
upvoted 0 times
Malika
3 months ago
Cloud Data Fusion seems like the best option for transferring data from on-premises MySQL databases to BigQuery.
upvoted 0 times
...
Micaela
3 months ago
I agree, using scheduled workflows to extract and transform data from MySQL into BigQuery is efficient.
upvoted 0 times
...
Fabiola
4 months ago
Option B sounds like a good choice. Cloud Data Fusion is easy to use for this task.
upvoted 0 times
...
...

Save Cancel