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 security team is reviewing access controls across production Google Cloud projects. The Database Operations group (dba-team@example.com) currently holds the predefined roles/cloudsql.admin role. An IAM evaluation and recommender analysis reveal that this group only requires read-only visibility into database configurations via the Google Cloud console, along with the ability to view Cloud SQL security insights and recommendations.
To adhere to the principle of least privilege while ensuring the Google Cloud console functions properly, which action should the security engineer take?
This option assigns the predefined roles/cloudsql.viewer role along with roles/recommender.iamAdmin directly to individual user identities rather than binding permissions to a Google Group.
roles/recommender.iamAdmin role grants broad administrative authority over IAM policy recommendations rather than read-only visibility into database security insights and recommendations.roles/recommender.iamAdmin allows team members to update and dismiss IAM policy recommendations across the project, exceeding the required operational scope.The requirement specifically mandated individual user assignments and full administrative control over IAM recommender policy states rather than database security recommendations.
This option builds a custom IAM role containing only cloudsql.instances.list and recommender.iamPolicyRecommendations.list and binds it to the group.
cloudsql.instances.list or cloudsql.instances.get is included, both must be included. Omitting cloudsql.instances.get prevents users from selecting and viewing instance details in the console UI.recommender.iamPolicyRecommendations.list permission inspects general IAM policy recommendations rather than Cloud SQL-specific security insights and recommendations (recommender.cloudsqlInstanceSecurity*).cloudsql.instances.get, operators cannot retrieve instance configurations, database flags, or replica properties.The team only interacted via automated CLI batch scripts that list instance IDs and audit general IAM policy recommendations without using the Google Cloud console.
Custom IAM roles allow organizations to group user-defined collections of granular permissions that tailor access precisely to operational requirements when predefined roles grant excess privileges.
roles/cloudsql.admin grants, providing only read and security-recommender permissions.cloudsql.instances.list and cloudsql.instances.get must be included in custom roles; otherwise, navigation fails.recommender.cloudsqlInstanceSecurityInsights.get, recommender.cloudsqlInstanceSecurityInsights.list, recommender.cloudsqlInstanceSecurityRecommendations.get, and recommender.cloudsqlInstanceSecurityRecommendations.list enables the group to assess security vulnerabilities without unnecessary management permissions.dba-team@example.com enforces consistent authorization across all database team members through identity federation or Cloud Identity.Creating a tailored custom role containing the necessary instance read and recommender permissions—while adhering to the list and get pairing requirement—strictly fulfills least privilege without disrupting day-to-day administrative visibility.
This option assigns the primitive/basic roles/viewer role at the organization root node, propagating read access down through every folder, project, and resource in the hierarchy.
roles/viewer) provide read access across all Google Cloud services (Cloud Storage, BigQuery, Compute Engine, Secret Manager, etc.) throughout the entire organization, far exceeding Cloud SQL requirements.The group consisted of enterprise-wide compliance auditors who required unrestricted read-only visibility across every Google Cloud product across all organizational resources.
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