ExpertMinds LogoExpertMinds
Medium1 markMultiple Choice
Domain 3.4: Deploying and implementing data solutionsCloud SQLCloud StorageData ImportIAM

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

You need to import a large SQL dump file into a Cloud SQL for MySQL instance. The dump file is currently stored in a Cloud Storage bucket.

Which TWO prerequisites must be met before you can successfully perform the import? (Select TWO)

Answer options:

A.

The Cloud SQL instance's service account must have the 'Storage Object Viewer' role on the bucket.

B.

The database you are importing into must already exist on the Cloud SQL instance.

C.

You must assign a public IP address to the Cloud SQL instance.

D.

The Cloud Storage bucket must be in a different region than the Cloud SQL instance.

E.

You must stop the Cloud SQL instance before starting the import.

How to approach this question

Think about IAM permissions and database logic when importing data.

Full Answer

The Cloud SQL instance's service account must have the 'Storage Object Viewer' role on the bucket., The database you are importing into must already exist on the Cloud SQL instance.
When you trigger an import from Cloud Storage to Cloud SQL, the Cloud SQL instance itself (using its automatically provisioned service account) reaches out to the bucket to read the file. Therefore, that service account must have the `roles/storage.objectViewer` permission. Additionally, the import process executes the SQL statements against an existing database, so the target database must be created prior to the import.

Common mistakes

Assuming your personal user account's permissions are used for the import. The import is performed by the Cloud SQL service account.
27All questions29

Practice the full GCP Associate Cloud Engineer Practice Exam 7

50 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01You are starting a new initiative and need to create a new Google Cloud project using the Cloud S...EasyQ02Your company is migrating to Google Cloud and wants to manage user identities centrally. They cur...MediumQ03You have just created a new Google Cloud project and want to deploy a containerized application u...MediumQ04Your finance team wants to perform complex SQL queries on your Google Cloud billing data to analy...MediumQ05You are managing a development project in Google Cloud. You want to ensure that you are notified ...Easy
View all 50 questions →