Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Professional Cloud Security Engineer practice bank has 1,343 more like it. Try 10 free: instant score, no account.
An enterprise manages multiple database workloads across several projects located inside a single folder named Application-Services. The security team needs to grant members of the database administration team permissions to inspect and configure Cloud SQL instances across all current and future projects in this folder.
The access control architecture must satisfy the following constraints:
What should the security engineer do to enforce the principle of least privilege?
roles/cloudsql.admin role to the database administration group at the Application-Services folder level.The roles/cloudsql.admin role is a service-specific predefined role that grants full administrative control over all Cloud SQL resources within the resource boundary where it is bound.
roles/cloudsql.admin contains full cloudsql.* permissions, which include permissions to delete instances (cloudsql.instances.delete), drop databases, and purge backups, directly violating the stated security restriction.The database team required total control over the lifecycle of Cloud SQL instances, including creating instances, restoring backups, managing user credentials, and terminating database instances.
cloudsql.instances.get and cloudsql.instances.list—and bind this role to the database administration group on the Application-Services folder.IAM Custom Roles allow security administrators to bundle granular, discrete permissions tailored specifically to workload responsibilities when predefined or basic roles do not meet the principle of least privilege. Defining custom roles at the folder level ensures that the role definition is inherited and available across all underlying descendant projects within that branch of the resource hierarchy.
cloudsql.instances.delete.cloudsql.instances.get and cloudsql.instances.list satisfies the prerequisite console dependency, allowing users to view and select instances in the Google Cloud console UI without error.Application-Services folder enforces policy consistency across all existing and newly created descendant projects automatically.setIamPolicy).Creating a targeted custom role at the folder hierarchy level directly achieves the balance between administrative functionality and strict least-privilege governance.
roles/editor role to the database administration group on each individual project under the Application-Services folder.Basic roles (roles/viewer, roles/editor, and roles/owner) are legacy, coarse-grained access control roles that predate fine-grained Identity and Access Management. The Editor role grants broad read, create, update, and delete access across virtually all Google Cloud services in a project.
roles/editor provides full read and write control over all non-database services in the project (e.g., Compute Engine instances, Cloud Storage buckets, and VPC networks), completely violating the requirement to restrict access to database workloads.A trusted project administrator needed full create, update, and delete rights across all infrastructure services in a standalone proof-of-concept environment.
cloudsql.instances.get, and bind it to the database administration group on the Application-Services folder.This option attempts to create a custom IAM role containing only the cloudsql.instances.get permission and excludes cloudsql.instances.list to restrict operators from listing all database instances simultaneously.
cloudsql.instances.get and cloudsql.instances.list together. If a custom role includes get without list, the console cannot populate the instance list or display instance details properly, breaking console UI navigation.list to discover resources and get to inspect their specific configuration).Interactions were handled strictly via programmatic scripts targeting known instance IDs through the API, and console functionality was not a requirement.
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 Validated