For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeGCP Associate Cloud Engineer (ACE)GCP Associate Cloud Engineer Practice Exam 6Question 28
    Medium1 markMultiple Choice
    Domain 3.4: Deploying and implementing data solutionsCloud SQLData MigrationCloud StorageImport

    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)

    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

    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.
    Question 27All questionsQuestion 29

    Practice the full GCP Associate Cloud Engineer Practice Exam 6

    50 questions · hints · full answers · grading

    Sign up freeTake the exam

    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
    View all 50 questions →