LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Google Professional Cloud Database Engineer

Google Professional Cloud Database Engineer

Get started today

Ultimate access to all questions.


In a highly regulated industry where separation of concerns (SoC) and the principle of least privilege (PoLP) are essential, how should you assign Cloud Spanner roles to the following team members:

  • Person A (database administrator)
  • Person B (analyst generating metric reports)
  • Application C (responsible for automatic backups)?

Exam-Like



Explanation:

The question emphasizes the importance of Separation of Concerns (SoC) and the Principle of Least Privilege (PoLP). For Person A, who is a database administrator, the appropriate role is 'roles/spanner.databaseAdmin' as it grants full control over databases. Person B, an analyst generating metric reports, only needs read access, hence 'roles/spanner.databaseReader' is suitable. Application C, responsible for automatic backups, requires the ability to create and manage backups but not necessarily full database administration rights, making 'roles/spanner.backupWriter' the correct choice. Option A correctly assigns these roles, adhering to SoC and PoLP by providing each entity only the permissions necessary for their role.

Powered ByGPT-5