Google Cloud Professional Cloud Database Engineer — Question 77

You are a DBA on a Cloud Spanner instance with multiple databases. You need to assign these privileges to all members of the application development team on a specific database:

Can read tables, views, and DDL -

Can write rows to the tables -

Can add columns and indexes -

Cannot drop the database -
What should you do?

Answer options

• A. Assign the Cloud Spanner Database Reader and Cloud Spanner Backup Writer roles.
• B. Assign the Cloud Spanner Database Admin role.
• C. Assign the Cloud Spanner Database User role.
• D. Assign the Cloud Spanner Admin role.

Correct answer: C

Explanation

The correct choice is C, the Cloud Spanner Database User role, as it allows users to read, write, and modify the database structure without the ability to drop the database. Option A does not provide the necessary write and modify permissions, option B gives full administrative rights, which includes dropping the database, and option D provides broader admin rights that exceed the requirements.