ExpertMedium1 markMultiple Choice
GCP ACE · Question 28 · Domain 3.4: Deploying and implementing data solutions
You are migrating an on-premises MySQL database to Cloud SQL. You have exported the on-premises database to a SQL dump file.
Which TWO steps are required to import this data into your new Cloud SQL instance? (Select TWO)
You are migrating an on-premises MySQL database to Cloud SQL. You have exported the on-premises database to a SQL dump file.
Which TWO steps are required to import this data into your new Cloud SQL instance? (Select TWO)
Answer options:
A.
Upload the SQL dump file directly to the Cloud SQL instance using SFTP.
B.
Upload the SQL dump file to a Cloud Storage bucket.
C.
Use the Cloud Console or gcloud to trigger an import operation, pointing Cloud SQL to the file in the Cloud Storage bucket.
D.
Convert the SQL dump file to a CSV format before importing.
E.
Temporarily assign the roles/storage.admin role to your personal user account.
How to approach this question
Understand the data ingestion path for Cloud SQL. It cannot accept direct file uploads; files must be staged in Cloud Storage first.
Full Answer
Upload the SQL dump file to a Cloud Storage bucket, and use the Cloud Console or gcloud to import the file from the bucket into Cloud SQL.
To import data into a Cloud SQL instance from a SQL dump file, you must follow a two-step process. Because Cloud SQL is a fully managed service, you cannot SSH or SFTP into the underlying server to upload files. First, you must upload the SQL dump file to a Cloud Storage bucket. Second, you use the Cloud Console, gcloud, or the API to instruct the Cloud SQL instance to import the data from that specific Cloud Storage URI.
Common mistakes
Assuming you can upload the file directly to the database server via SFTP or a direct web upload button.
Practice the full GCP Associate Cloud Engineer Practice Exam 6
50 questions · hints · full answers · grading
More questions from this exam
Q01What is the primary purpose of a Google Cloud project?EasyQ02Your development team needs to manage Compute Engine instances in a specific project. They need t...MediumQ03You are automating the setup of a new Google Cloud project using a bash script. You need to enabl...EasyQ04Your startup has a strict monthly cloud budget of $500. You want to be notified immediately if yo...MediumQ05Your finance team wants to perform granular analysis of your Google Cloud spending using SQL. The...Hard