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 7Question 28
    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

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

    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 →