Google Associate Cloud Engineer Question 243
Select 3Google Cloud PlatformAs a Google Cloud Associate Cloud Engineer, you need to retrieve data from a Cloud SQL instance using a SQL query. Which of the following steps must you ensure are completed to successfully execute the query?
- A
Enable the Cloud SQL Admin API for your project.
- B
Ensure the Cloud SQL instance is in the same region as your Google Cloud project.
- C
Set up a network connection, such as a private IP or Cloud SQL Proxy, to access the Cloud SQL instance.
- D
Assign the appropriate IAM role to the user or service account executing the query.
- E
Ensure the Cloud SQL instance is using the MySQL database engine.
Show answer and explanation
Correct answers: A, C, D
Explanation
To execute queries on a Cloud SQL instance, you need to ensure that the API is enabled, appropriate network connectivity is established, and the necessary IAM permissions are assigned. These steps ensure that the necessary infrastructure and permissions are in place to access and query the Cloud SQL instance securely.
- A. Correct.
Enabling the Cloud SQL Admin API is necessary to manage and interact with Cloud SQL instances programmatically.
- B. Incorrect.
While it's generally beneficial to have resources in the same region for performance reasons, it's not a strict requirement for executing queries.
- C. Correct.
A network connection, such as private IP or Cloud SQL Proxy, is required to access the Cloud SQL instance securely and execute queries.
- D. Correct.
Appropriate IAM permissions are required to perform operations on Cloud SQL instances, including executing queries.
- E. Incorrect.
Cloud SQL supports multiple database engines such as MySQL, PostgreSQL, and SQL Server. The choice of engine does not affect the ability to execute queries.