Google Cloud Professional Cloud Developer PCD — Topic 1 Question 327

Question

You are using the latest stable version of Python 3 to develop an API that stores data in a Cloud SQL database. You need to perform CRUD operations on the production database securely and reliably with minimal effort. What should you do?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: 1. Use the Cloud SQL connector library for Python to connect to the Cloud SQL database through a Cloud SQL Auth Proxy.2. Grant an IAM role to the service account that includes the cloudsql.instances.connect permission. Cloud SQL is a managed relational database (MySQL/PostgreSQL/SQL Server) that handles patching, backups, and failover. A service account provides an identity for workloads to access Google Cloud APIs securely. Cloud IAM grants fine-grained, least-privilege access to Google Cloud resources.

Google Cloud Professional Cloud Developer PCD — Question 327