nerdexam
Google

PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #192

You are developing a Python application that will connect to AlloyDB for PostgreSQL as the backend datastore. Your organization's security requirements do not allow the use of usernames and…

The correct answer is B. Use the AlloyDB Python connector. Use automated IAM authentication for connectivity. The AlloyDB Python connector natively supports IAM-based authentication, letting your application obtain short-lived OAuth tokens instead of using static database passwords. This meets the security requirement and integrates seamlessly with AlloyDB for PostgreSQL without…

Securing database solutions

Question

You are developing a Python application that will connect to AlloyDB for PostgreSQL as the backend datastore. Your organization’s security requirements do not allow the use of usernames and passwords for database authentication. How should you develop your application-

Options

  • AUse any PostgreSQL-compatible Python client. Connect to the AlloyDB cluster by using Identity-
  • BUse the AlloyDB Python connector. Use automated IAM authentication for connectivity.
  • CUse the AlloyDB Python connector. Enforce SSL connectivity to AlloyDB by using the gcloud
  • DUse any PostgreSQL-compatible Python client. Use a service account name and credential as the

How the community answered

(14 responses)
  • B
    86% (12)
  • C
    7% (1)
  • D
    7% (1)

Explanation

The AlloyDB Python connector natively supports IAM-based authentication, letting your application obtain short-lived OAuth tokens instead of using static database passwords. This meets the security requirement and integrates seamlessly with AlloyDB for PostgreSQL without additional credential management.

Topics

#AlloyDB#IAM Authentication#Python Connector#Database Connectivity

Community Discussion

No community discussion yet for this question.

Full PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice