Practice Test 4 | Google Cloud Certified Professional Data Engineer | Dumps | Mock Test
You are a data engineer for your company. The company has chosen to use a serverless data warehouse service on Google Cloud. You are asked to analyze credit-card transactions in a Big query that currently sits in the Google Cloud SQL service. Select the best possible option provided by GCP to get your Cloud SQL data into Google Big Query.
A. In Cloud SQL, select Big Query as target and write all the data
B. Use the BigQuery connector in Cloud SQL, to export from Cloud SQL to Big Query.
C. In Big Query, use an external data source – Cloud SQL and establish the connection to get the data.
D. None of the above
Correct Answer: C
- Option C is CORRECT because to get data from Cloud SQL, the best way to use the external data source option and select Cloud SQL and provide all the details regarding the database.
- Option A is incorrect because we don’t have any such option in cloud SQL.
- Option B is incorrect because we don’t have a big query connector to transfer data from Cloud SQL to Big Query.
For more information on the Big Query, please visit the below URL:
Comments are closed, but trackbacks and pingbacks are open.