🔥 40% Off Crucial Exams Memberships — Deal ends today!

2 hours, 29 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

Your enterprise analytics team runs Tableau Server in an on-premises data center protected by a strict outbound firewall that only allows HTTPS (TCP 443). To avoid the daily export of Google BigQuery tables to CSV and keep dashboards closer to real time, you need to let Tableau query BigQuery directly with minimal re-engineering of existing workbooks. Which approach best satisfies these requirements?

  • Set up Cloud VPN to peer with Google Cloud, mirror each BigQuery table into a Cloud SQL for PostgreSQL instance using federation, and point Tableau to the replica with a PostgreSQL driver.

  • Stream BigQuery data into Cloud Bigtable via Dataflow and connect Tableau through a custom JDBC driver that issues HBase API calls.

  • Install the Simba BigQuery JDBC or ODBC driver on Tableau Server and configure a service-account-based connection that queries BigQuery over HTTPS (port 443).

  • Continue exporting BigQuery data to Cloud Storage, but schedule exports every hour and use Tableau's flat-file connector to read the parquet files.

GCP Professional Data Engineer
Preparing and using data for analysis
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot