You’re using a SQL-based visualization tool gcp video
data-engineer-pro video for you’re using a SQL-based visualization tool connected to BigQuery. The visualizations rely on complex queries involving outer joins
Answer
Full Certification Question
You’re using a SQL-based visualization tool connected to BigQuery. The visualizations rely on complex queries involving outer joins and analytic functions, and users require the data to be at least 4 hours old. However, users are experiencing slow query performance. You want to speed up the visualizations while keeping data pipeline maintenance to a minimum. What should you do?