exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam

Exam Associate Data Practitioner topic 1 question 66 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 66
Topic #: 1
[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?

  • A. Create 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.
  • B. Use the Cloud Data Fusion web interface to build data pipelines. Create a directed acyclic graph (DAG) that facilitates pipeline orchestration.
  • C. Use the existing data pipeline tool’s BigQuery connector to reconfigure the data mapping.
  • D. Use the BigQuery Data Transfer Service to recreate the data pipeline and migrate the data into BigQuery.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
n2183712847
1 month, 4 weeks ago
Selected Answer: C
The best option is C. Use the existing data pipeline tool’s BigQuery connector. Option C is best because leveraging existing tools and their BigQuery connectors is generally the fastest migration path. Reconfiguring existing mappings is more direct than introducing new services or intermediate steps, optimizing migration speed. Option A (Temporary file system and Storage Transfer Service) is incorrect because adding Cloud Storage as an intermediary step slows down migration compared to direct transfer. Option B (Cloud Data Fusion) is incorrect because building new pipelines in Data Fusion adds complexity and time, less optimal for speed if connectors already exist. Option D (BigQuery Data Transfer Service) is incorrect because Data Transfer Service is for scheduled transfers, not necessarily the fastest for a one-time bulk migration compared to direct connector usage. Therefore, Option C, using existing connectors, is the most direct and speed-optimized approach.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago