Topic 1 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?
Use Identity and Access Management (IAM) authentication.
Use Managed Active Directory authentication.
Use Cloud SQL federated queries.
Use PostgreSQL database's built-in authentication.
γ³γ‘γ³γ(2)
A. Google wants you to use IAM regardless. PostgreSQL built-in authentication requires a username and a password. That rules out D. Federated queries are queries originating from BigQuery to Cloud SQL. Eliminate C. AD is strongly tied to SQL Server. Eliminate B. That leaves A.
π 2dynamic_dba2023/03/27A. IAM Authentication is password less.
π 1shaiz982023/04/14
γ·γ£γγγ«γ’γΌγ