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

How to approach this question

Understand the mechanics of Cloud SQL imports. Where does the file live, and who needs permission to read it?

Full Answer

The dump file must be located in a Cloud Storage bucket, The Cloud SQL instance's service account must have the roles/storage.objectViewer role on the bucket

To import data into Cloud SQL, the dump file must first be uploaded to a Google Cloud Storage bucket. Because the import process is executed by the Cloud SQL service itself (not your personal user account), the specific service account associated with the Cloud SQL instance must be granted read access (`roles/storage.objectViewer`) to that Cloud Storage bucket.

Common mistakes

Assuming your own user permissions are enough, forgetting that the Cloud SQL service account needs the permissions.

You need to initialize a new Cloud SQL for PostgreSQL instance by importing a `.sql` dump file.

Which TWO requirements must be met to successfully perform this import? (Select TWO)

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Associate Cloud Engineer Practice Exam 5

More questions from this exam

You need to initialize a new Cloud SQL for PostgreSQL instance by importing a .sql dump file. Which TWO requirements must be met to successfully perform this import? (Select TWO)

How to approach this question

Full Answer

Common mistakes

Practice the full GCP Associate Cloud Engineer Practice Exam 5

More questions from this exam

You need to initialize a new Cloud SQL for PostgreSQL instance by importing a `.sql` dump file.

Which TWO requirements must be met to successfully perform this import? (Select TWO)