In the context of optimizing a production demand forecasting pipeline, Z-score normalization is applied to data stored in BigQuery during preprocessing. With new training data added weekly, the pipeline must efficiently handle this incremental data without significant manual intervention or excessive computation time. Considering the need for scalability, cost-effectiveness, and minimal latency in preprocessing, which of the following approaches is the BEST to adopt? Choose the most appropriate option.