Crucial Exams

GCP Professional Data Engineer Practice Question

Your organization uses Looker Studio and Tableau to visualize operational data stored in a BigQuery dataset. Looker Studio connects with its native BigQuery connector, while Tableau connects through the official Simba ODBC driver. Analysts complain that interactive dashboards slow down during peak business hours, but you cannot change the SQL that the tools generate or the way they connect. You must improve query latency quickly and transparently, and you want a solution that will benefit both tools without requiring any modification on the client side. What should you do?

  • Create materialized views for the slowest dashboard queries and instruct each BI team to replace existing tables with the new views.

  • Purchase and allocate BI Engine in-memory capacity for the BigQuery project; no further changes are required because both tools already issue queries through the BigQuery API.

  • Ask report authors to add the /*+ RESULT_CACHE */ query hint and enable table result caching; this will let BigQuery cache results for repeated dashboard loads.

  • Export the data to a Cloud SQL replica and re-point Tableau and Looker Studio to the replica so that queries run outside BigQuery at lower load.

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