You are migrating a MySQL database to Cloud SQL. You have exported your on-premises database to a SQL dump file. What is the recommended sequence of steps to import this data into your new Cloud SQL instance?

Answer options:

Upload the SQL dump file to a Cloud Storage bucket, then use the Cloud Console or gcloud to import the file from the bucket into Cloud SQL.

Use the 'gcloud sql import' command to upload the local file directly to the Cloud SQL instance.

Connect to the Cloud SQL instance using SSH and use the 'mysql' command line tool to import the local file.

Upload the file to Google Drive and link it to Cloud SQL.

How to approach this question

Understand the staging requirements for importing data into managed GCP database services.

Full Answer

A.Upload the SQL dump file to a Cloud Storage bucket, then use the Cloud Console or gcloud to import the file from the bucket into Cloud SQL.✓ Correct

To import data into Cloud SQL, the dump file (SQL or CSV) must first be uploaded to a Cloud Storage bucket. Once the file is in Cloud Storage, you can trigger the import process via the Cloud Console, gcloud, or the API.

Common mistakes

Assuming you can upload a local file directly via the gcloud import command.

Question 26 All questions Question 28

Practice the full GCP Associate Cloud Engineer Practice Exam 2

50 questions · hints · full answers · grading

More questions from this exam

Q01Your company is migrating to Google Cloud and needs to establish a resource hierarchy. You have t...Easy Q02You are managing access to a GCP project. You need to grant 15 developers the ability to view Com...Medium Q03You have created a new GCP project using the Cloud Console. You want to deploy a Cloud Function u...Easy Q04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...Easy Q05Your finance team wants to perform complex SQL analysis on your GCP billing data to understand co...Medium

View all 50 questions →