ExpertMedium1 markMultiple Choice
GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions
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)
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)
Answer options:
A.
The dump file must be located in a Cloud Storage bucket
B.
The Cloud SQL instance's service account must have the roles/storage.objectViewer role on the bucket
C.
The Cloud Storage bucket must be made publicly accessible
D.
You must use the gcloud sql export command
E.
The Cloud SQL database instance must be stopped during the import
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
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.
Practice the full GCP Associate Cloud Engineer Practice Exam 5
50 questions · hints · full answers · grading
More questions from this exam
Q01You are starting a new initiative and need to create a new Google Cloud project using the command...EasyQ02A developer on your team needs to manage App Engine applications, including deploying new version...MediumQ03You have created a new Google Cloud project. You need to allow a specific group of developers to ...MediumQ04Which statement best describes the relationship between Google Cloud projects and billing accounts?EasyQ05Your company wants to be notified immediately in their Slack channel whenever their monthly Googl...Medium