Google Professional Data Engineer Question 181
Select 3Google Cloud PlatformYou are a Data Engineer tasked with setting up a data pipeline on Google Cloud. Your team wants to use BigQuery for analytics but prefers using a third-party BI tool for visualization, such as Tableau. What steps should you take to ensure a seamless connection between BigQuery and Tableau?
- A
Enable the BigQuery API in your Google Cloud project.
- B
Set up a Cloud VPN to establish a secure connection between BigQuery and Tableau.
- C
Install the required ODBC or JDBC drivers for Tableau to connect to BigQuery.
- D
Generate and provide service account credentials for Tableau to authenticate with BigQuery.
- E
Configure a Pub/Sub topic to stream data directly from BigQuery to Tableau.
Show answer and explanation
Correct answers: A, C, D
Explanation
To connect Tableau with BigQuery, you need to enable the BigQuery API to allow external access, install the appropriate ODBC or JDBC drivers for Tableau, and use service account credentials to authenticate securely. A VPN or Pub/Sub is not required for this integration as Tableau can communicate directly with BigQuery over HTTPS using the drivers and credentials.
- A. Correct.
Correct - Enabling the BigQuery API is necessary to allow external tools, such as Tableau, to interact with BigQuery.
- B. Incorrect.
Incorrect - A Cloud VPN is unnecessary for connecting Tableau to BigQuery as they can communicate securely over HTTPS without a VPN.
- C. Correct.
Correct - Tableau requires ODBC or JDBC drivers to establish a connection with BigQuery effectively.
- D. Correct.
Correct - Service account credentials are necessary for Tableau to authenticate with BigQuery securely.
- E. Incorrect.
Incorrect - Pub/Sub is designed for event-driven architectures and streaming data, not for direct BI tool integrations.