Discuss Google Professional Cloud Database Engineer Exam Topic 5 Question 72

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.

Suggested Answer: C

Get Premium Professional Cloud Database Engineer Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

19 comments · newest first

Jess 23 days ago

Each option has its merits, but B stands out.

Gearldine 28 days ago

I still prefer C for its streaming capabilities.

Lisandra 1 month ago

Exactly! Plus, scheduled workflows are a plus.

Jess 1 month ago

B just feels right for low latency needs.

Gearldine 1 month ago

Yeah, A is too manual for my taste.

Lisandra 2 months ago

D could work too, but it feels like overkill for this scenario.

Jess 2 months ago

True, but it might be complex to set up.

Gearldine 2 months ago

I’m leaning towards C. Datastream seems efficient for real-time data.

Lisandra 2 months ago

Agreed! It simplifies the ETL process.

Jess 2 months ago

I think option B is the best. Cloud Data Fusion is user-friendly.

Joaquin 2 months ago

Not sure about D, sounds complicated for just replication.

Miles 3 months ago

Wait, D involves federated tables? That’s interesting!

Mari 3 months ago

A seems too manual, not ideal for low latency.

Madelyn 3 months ago

I disagree, I think C is more efficient with real-time data.

Aracelis 3 months ago

Option B sounds like the best choice for ease of use!

Zona 3 months ago

I’m leaning towards option B since it mentions scheduled workflows, which I think would help automate the process, but I’m not entirely confident.

Galen 4 months ago

I feel like I’ve seen questions about using Database Migration Service before, but I’m not clear on how federated tables work with BigQuery.

Lenna 4 months ago

I think option C with Datastream sounds familiar, but I’m a bit confused about how it integrates with Dataflow for processing.

Ciara 4 months ago

I remember practicing with Cloud Data Fusion, and it seemed like a good option for ETL processes, but I'm not sure if it's the best for low latency.

Google Professional Cloud Database Engineer Exam - Topic 5 Question 72 Discussion