As a data engineer, you are currently utilizing a SQL-based tool for visualizing data stored in Google BigQuery. The data visualizations necessitate the use of outer joins and analytic functions, and it is crucial that these visualizations are based on data that is no older than 4 hours. However, business users have reported that the visualizations take too long to generate. Your objective is to enhance the performance of these visualization queries while also minimizing the maintenance overhead associated with the data preparation pipeline. What steps should you take to achieve this? | Google Professional Data Engineer Quiz