GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions
You are migrating an on-premises MySQL database to Cloud SQL. You have exported the on-premises database to a SQL dump file.
Which TWO steps are required to import this data into your new Cloud SQL instance? (Select TWO)
Answer options:
Upload the SQL dump file directly to the Cloud SQL instance using SFTP.
Upload the SQL dump file to a Cloud Storage bucket.
Use the Cloud Console or gcloud to trigger an import operation, pointing Cloud SQL to the file in the Cloud Storage bucket.
Convert the SQL dump file to a CSV format before importing.
Temporarily assign the roles/storage.admin role to your personal user account.
50 questions · hints · full answers · grading