1. Home
  2. Discussions
  3. Google
  4. Google Cloud Platform
  5. Associate-Data-Practitioner Discussions
  6. Associate-Data-Practitioner Exam Topic 1 Question 9 Discussion

Google Cloud Associate Data Practitioner (ADP Exam) Associate-Data-Practitioner Question # 9 Topic 1 Discussion

 Google Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Google Cloud Associate Data Practitioner (ADP Exam) Associate-Data-Practitioner Question # 9 Topic 1 Discussion

Associate-Data-Practitioner Exam Topic 1 Question 9 Discussion:
Question #: 9
Topic #: 1

Your organization's website uses an on-premises MySQL as a backend database. You need to migrate the on-premises MySQL database to Google Cloud while maintaining MySQL features. You want to minimize administrative overhead and downtime. What should you do?
A.

Install MySQL on a Compute Engine virtual machine. Export the database files using the mysqldump command. Upload the files to Cloud Storage, and import them into the MySQL instance on Compute Engine.

B.

Use Database Migration Service to transfer the data to Cloud SQL for MySQL, and configure the on premises MySQL database as the source.

C.

Use a Google-provided Dataflow template to replicate the MySQL database in BigQuery.

D.

Export the database tables to CSV files, and upload the files to Cloud Storage. Convert the MySQL schema to a Spanner schema, create a JSON manifest file, and run a Google-provided Dataflow template to load the data into Spanner.

Get Premium Associate-Data-Practitioner Questions
Actual exam question for Google Associate-Data-Practitioner exam by Ember8027 at Aug 2, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next