You are migrating an on-premises online transactional process (OLTP) PostgreSQL database to Google Cloud. You want to reduce the administrative overhead on database maintenance activities, such as vacuum and memory tuning. You are also planning to introduce analytic use cases in this database. You need the migration to have minimal schema and application changes. What should you do?
A. Use Spanner with PGAdapter.
B. Use Cloud SQL for PostgreSQL.
C. Use AlloyDB for PostgreSQL.
D. Deploy a self-managed PostgreSQL database on Compute Engine.
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?
A. Use any PostgreSQL-compatible Python client. Connect to the AlloyDB cluster by using Identity-Aware Proxy (IAP).
B. Use the AlloyDB Python connector. Use automated IAM authentication for connectivity.
C. Use the AlloyDB Python connector. Enforce SSL connectivity to AlloyDB by using the gcloud alloydb instance update command with the --ssl-mode=ENCRYPTED_ONLY option.
D. Use any PostgreSQL-compatible Python client. Use a service account name and credential as the username and password respectively during connection.
