Google Associate Cloud Engineer Question 244
Select 3Google Cloud PlatformYou are working as a Google Cloud Engineer and need to retrieve data from a Cloud SQL instance that contains customer transaction records. Which of the following tools or services can you use to execute a SQL query against this Cloud SQL instance?
- A
Google Cloud Console
- B
Cloud Shell
- C
BigQuery
- D
Dataflow
- E
Cloud SQL Proxy
Show answer and explanation
Correct answers: A, B, E
Explanation
To execute queries against a Cloud SQL instance, you can use the Google Cloud Console's SQL editor for direct query execution, or you can leverage Cloud Shell with command-line tools given the right configurations. Cloud SQL Proxy facilitates secure connections, allowing query execution using traditional database client tools. BigQuery and Dataflow serve different purposes and are not used for executing direct SQL queries on Cloud SQL instances.
- A. Correct.
Google Cloud Console provides a built-in SQL editor that allows you to execute queries directly against your Cloud SQL instances.
- B. Correct.
Cloud Shell can be used to connect to your Cloud SQL instance and execute queries using command-line tools like
mysqlorpsql. - C. Incorrect.
BigQuery is a separate service designed for data warehousing and analytics, not for executing SQL queries against Cloud SQL instances.
- D. Incorrect.
Dataflow is used for stream and batch processing, and it doesn't directly execute SQL queries against Cloud SQL instances.
- E. Correct.
Cloud SQL Proxy allows secure connections to your Cloud SQL instances and can be used with tools like
mysqlorpsqlto execute SQL queries.