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

2 hours, 30 minutes remaining!
Crucial Exams

GCP Professional Data Engineer Practice Question

Your analytics team relies on a third-party business-intelligence application that connects to BigQuery through the official JDBC driver. As dashboard adoption grows, report refresh times have risen from sub-second to 20-30 seconds. You need to accelerate query performance without altering existing SQL, changing the BI tool's connection method, or moving data outside BigQuery; dashboards must still reflect near-real-time updates in the underlying tables. Which approach best meets these requirements?

  • Enable the BigQuery query cache and add the USE_CACHE=TRUE hint to every dashboard query generated by the BI tool.

  • Schedule daily exports of the fact tables to Cloud Storage and have the BI tool read the resulting CSV files directly to avoid live querying BigQuery.

  • Replicate the dataset into Cloud Bigtable and reconfigure the BI tool to connect through a Bigtable driver for faster point-lookups.

  • Purchase a BigQuery BI Engine reservation for the project and enable BI Engine acceleration on the dataset used by the dashboards.

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