Scenario: You use a SQL-based tool to visualize gcp video
data-engineer-pro video for scenario: You use a SQL-based tool to visualize data stored in BigQuery. The visualizations require the use of outer joins and
Answer
Full Certification Question
Scenario: You use a SQL-based tool to visualize data stored in BigQuery. The visualizations require the use of outer joins and analytic functions. Visualizations must be based on data that is no less than 4 hours old. Business users have reported that the visualizations are too slow to generate. You want to improve the performance of the queries while minimizing the maintenance overhead of the data preparation pipeline. Question: How should you improve the performance of the visualization queries and reduce the maintenance overhead of the data preparation pipeline?