ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Associate Data Practitioner All Questions

View all questions & answers for the Associate Data Practitioner exam
Go to Exam

Exam Associate Data Practitioner topic 1 question 71 discussion

Actual exam question from Google's Associate Data Practitioner
Question #: 71
Topic #: 1
[All Associate Data Practitioner Questions]

You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional data. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?

  • A. Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.
  • B. Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.
  • C. Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.
  • D. Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by n2183712847 at March 6, 2025, 5:35 a.m.

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
Submit Cancel
n2183712847
1 month, 4 weeks ago
Selected Answer: C
The best option is C. Use Database Migration Service (DMS). Option C is best because DMS is built for MySQL migration to Cloud SQL, ensuring integrity and minimizing downtime. Option A (Composer, Python, Compute Engine) is incorrect because Composer adds complexity, Python is manual, and Compute Engine is less managed. Option B (CSV, Storage Transfer, Cloud SQL) is incorrect because CSV export is slow, risks integrity, and has downtime. Option D (Data Fusion to Compute Engine) is incorrect because Data Fusion is overkill for simple migration, and Compute Engine is less managed than Cloud SQL. Therefore, Option C, DMS, is the most direct and efficient migration solution.
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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago