Domain 3.4: Deploying and implementing data solutions — GCP ACE Practice Question 27

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

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.

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.

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?

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Associate Cloud Engineer Practice Exam 2

More questions from this exam