Prepare and test your skills

Prepare and test your skills

Free sample question with answers and detailed explanation below. The Associate Cloud Engineer practice bank has an additional 2,014 practice questions.Try 10 free realistic questions: instant score, no credit card, and no account required.
Your team needs to import a large dataset from a CSV file stored in a Cloud Storage bucket into an existing MySQL database hosted on Cloud SQL. When initiating the import job from the Google Cloud console, the operation fails with an access permission error.
Which configuration should you perform to enable the Cloud SQL instance to access and load the file from the Cloud Storage bucket?
The BigQuery Admin (roles/bigquery.admin) role provides administrative access to all BigQuery datasets, tables, jobs, and reservations within a Google Cloud project.
storage.objects.get).You were configuring an automated service account to manage BigQuery datasets, table schemas, and query execution pipelines within an enterprise data warehouse environment.
The Cloud SQL Client (roles/cloudsql.client) role provides permissions to connect to a Cloud SQL database instance (such as via the Cloud SQL Auth Proxy or authorized serverless environments like App Engine and Cloud Run).
storage.objects.get) to the bucket holding the CSV file.storage.objects.*).You were configuring an external compute workload (such as an application running on Compute Engine or Cloud Run) that needed permission to establish an authorized database connection to Cloud SQL.
The Storage Object Creator (roles/storage.objectCreator) role is a Cloud Storage IAM role that allows principals to write new objects into a bucket. It does not allow reading existing objects, nor does it apply to Cloud SQL resources.
storage.objects.get), not object creation permissions (storage.objects.create).cloudsql.instances.import to start the job, the actual retrieval of the file is performed under the identity of the Cloud SQL instance's service account.A user needed write-only access to upload raw CSV files into an ingestion bucket in Cloud Storage without being able to view or overwrite existing files.
When Cloud SQL performs data import or export operations directly against Google Cloud Storage, it acts as an autonomous service using its own managed service account. Each Cloud SQL instance has a unique service account email address generated by Google Cloud upon instance creation.
To successfully read the CSV file stored in the Cloud Storage bucket:
gcloud sql instances describe INSTANCE_NAME locates the serviceAccountEmailAddress attribute.roles/storage.objectAdmin) role or a custom role containing the storage.objects.get permission on the specific Cloud Storage bucket gives the database instance the authority to fetch and read the CSV object.
.csv and gzip-compressed (.gz) files efficiently.Granting the required Cloud Storage permissions directly to the Cloud SQL service account directly addresses the root cause of the permission denial without exposing the bucket to unnecessary broad access or requiring complex intermediary networking configurations.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated