In your role as a Machine Learning Engineer at a retail company, you are responsible for a demand forecasting pipeline that preprocesses raw data using Dataflow before model training and prediction. The preprocessing includes Z-score normalization on data stored in BigQuery, which is then written back to BigQuery. With new training data being added weekly, you are tasked with enhancing the process to reduce computation time and minimize manual intervention. Considering the need for scalability, cost-efficiency, and compliance with data governance policies, which of the following solutions would BEST meet these requirements? Choose the two most effective options.