An analytics team needs to read data out of Cloud SQL for SQL Server and...

Vendor: Google
Product: Professional-Cloud-Database-Engineer
Update on: Jul 31, 2025
Questions: 141

Google Professional-Cloud-Database-Engineer Question Answer

An analytics team needs to read data out of Cloud SQL for SQL Server and update a table in Cloud Spanner. You need to create a service account and grant least privilege access using predefined roles. What roles should you assign to the service account?

roles/cloudsql.viewer and roles/spanner.databaseUser

roles/cloudsql.editor and roles/spanner.admin

roles/cloudsql.client and roles/spanner.databaseReader

roles/cloudsql.instanceUser and roles/spanner.databaseUser