Answer-first summary for fast verification
Answer: Use Identity and Access Management (IAM) authentication.
To enable password-less authentication for read and write access to a Cloud SQL for PostgreSQL database, the most suitable authentication mechanism is Identity and Access Management (IAM) authentication. IAM allows you to manage access control by defining who (identity) has what access (role) to which resources. It supports password-less authentication by using IAM roles to grant permissions to applications, eliminating the need for traditional database passwords. Managed Active Directory authentication (Option B) is more suited for environments integrated with Microsoft Active Directory. Cloud SQL federated queries (Option C) are used for querying data across different databases, not for authentication. PostgreSQL's built-in authentication (Option D) typically requires passwords, which does not meet the requirement for password-less authentication.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which authentication mechanism should you implement in Cloud SQL for PostgreSQL to enable password-less read and write access for applications?
A
Use Identity and Access Management (IAM) authentication.
B
Use Managed Active Directory authentication.
C
Use Cloud SQL federated queries.
D
Use PostgreSQL database's built-in authentication.
No comments yet.