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 wit

Question

Options

• A
  1. Use Cloud Composer to manage the connection to the Cloud SQL database from your Python
• B
  1. Use the Cloud SQL API to connect to the Cloud SQL database from your Python application.
• C
  1. Use the Cloud SQL connector library for Python to connect to the Cloud SQL database through
• D
  1. Use the Cloud SQL emulator to connect to the Cloud SQL database from Cloud Shell

• A
  4% (2)
• B
  10% (5)
• C
  85% (44)
• D
  2% (1)

Explanation

The Cloud SQL Connector library for Python provides secure, production-ready connections to Cloud SQL with minimal effort. It handles IAM-based authentication, automatic certificate management for encrypted connections, and integrates with popular Python ORMs (like SQLAlchemy). This satisfies the 'secure and reliable with minimal effort' requirement. Option A (Cloud Composer) is a workflow orchestration service built on Apache Airflow - it is not a database connection library for CRUD operations. Option B (Cloud SQL API) is a REST management API for administering Cloud SQL instances (creating, deleting, configuring), not for executing SQL queries from an application. Option D (Cloud SQL emulator) is a local development/testing tool and is not appropriate for production database connections.

No community discussion yet for this question.