Google Cloud Professional Cloud Database Engineer — Question 125

You are a DBA of Cloud SQL for PostgreSQL. You want the applications to have password-less authentication for read and write access to the database. Which authentication mechanism should you use?

Answer options

• 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.

Correct answer: A

Explanation

The correct answer is A, as IAM authentication allows for password-less access through Google Cloud's identity management. The other options do not support password-less connections to Cloud SQL; Managed Active Directory authentication requires credentials, Cloud SQL federated queries are used for querying data from other sources, and PostgreSQL's built-in authentication relies on passwords.