Google Associate Data Practitioner Exam - Topic 3 Question 16 Discussion

Actual exam question for Google's Associate Data Practitioner exam

Question #: 16
Topic #: 3

[All Associate Data Practitioner Questions]

Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?

ACreate a temporary file system to facilitate data transfer from the existing environment to Cloud Storage. Use Storage Transfer Service to migrate the data into BigQuery.

BUse the Cloud Data Fusion web interface to build data pipelines. Create a directed acyclic graph (DAG) that facilitates pipeline orchestration.

CUse the existing data pipeline tool's BigQuery connector to reconfigure the data mapping.

DUse the BigQuery Data Transfer Service to recreate the data pipeline and migrate the data into BigQuery.

Show Suggested Answer

Suggested Answer: C

Since your existing data pipeline tools already support connectors to BigQuery, the most efficient approach is to use the existing data pipeline tool's BigQuery connector to reconfigure the data mapping. This leverages your current tools, reducing migration complexity and setup time, while optimizing migration speed. By reconfiguring the data mapping within the existing pipeline, you can seamlessly direct the data into BigQuery without needing additional services or intermediary steps.

by Dean at Aug 17, 2025, 07:37 PM

Limited Time Offer

25%

Off

Get Premium Associate Data Practitioner Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tonja

2 months ago

Wait, can we really just reconfigure the existing connector? Sounds too easy!

upvoted 0 times

...

Felicia

2 months ago

D seems like a solid choice for a clean transfer.

upvoted 0 times

...

Carey

2 months ago

Not so sure about C, what if the mapping is complex?

upvoted 0 times

...

Tawna

3 months ago

Definitely agree with C, makes the most sense!

upvoted 0 times

...

Casie

3 months ago

I think option C is the fastest since it uses existing tools.

upvoted 0 times

...

Irving

3 months ago

I vaguely recall that using Cloud Data Fusion could help with orchestration, but I wonder if it really speeds up the migration process as much as the others.

upvoted 0 times

...

Jose

4 months ago

I practiced a similar question where we had to choose between using Cloud Storage and direct connectors. I feel like option A might be too slow.

upvoted 0 times

...

Billy

4 months ago

I think the BigQuery Data Transfer Service might be the best choice for optimizing speed, but I need to double-check how it compares to other methods.

upvoted 0 times

...

Joanna

4 months ago

I remember that using the existing data pipeline tool's BigQuery connector could be efficient, but I'm not sure if it's the fastest option.

upvoted 0 times

...

Lacresha

4 months ago

I'm not entirely sure which option is the best here. They all seem to have their pros and cons. I might need to do some more research on the different tools and services mentioned to determine the most efficient approach for our specific use case.

upvoted 0 times

...

Julie

4 months ago

I feel pretty confident about this one. The key is to optimize for migration speed, so I think option A with the Storage Transfer Service is the way to go. Creating a temporary file system and using that to migrate the data should be the fastest approach.

upvoted 0 times

...

Una

4 months ago

Hmm, I'm a bit confused by the different options here. I'm not sure if using a temporary file system or the Cloud Data Fusion tool would be the most efficient approach. Maybe I should look into the BigQuery Data Transfer Service option more closely.

upvoted 0 times

...

Lamonica

5 months ago

This seems like a straightforward data migration question. I think I'll go with option C and use the existing data pipeline tool's BigQuery connector to reconfigure the data mapping. That should be the fastest approach.

upvoted 0 times

...

Jamal

5 months ago

I'm leaning towards Option D. The BigQuery Data Transfer Service sounds like the most straightforward approach to migrate the data. Less hassle, more speed.

upvoted 0 times

...