Google Cloud Professional Cloud Database Engineer PCDBE — Topic 1 Question 53

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: roles/cloudsql.instanceUser and roles/spanner.databaseUser Cloud Spanner is a horizontally scalable, strongly consistent relational database with global reach.

Google Cloud Professional Cloud Database Engineer PCDBE — Question 53