
Ultimate access to all questions.
You are developing a machine learning model using BigQuery ML and plan to host the model with Vertex AI to handle continuous streaming data from various vendors, which may include invalid values. What is the best approach to manage potentially invalid values in the data stream?
A
Establish a new BigQuery dataset for streaming inserts from multiple vendors and configure your BigQuery ML model to utilize the 'ingestion' dataset as the framing data.
B
Directly use BigQuery streaming inserts to land data from multiple vendors into the dataset where your BigQuery ML model is deployed.
C
Set up a Pub/Sub topic for all vendor data and link a Cloud Function to the topic to process and store the data in BigQuery.
D
Create a Pub/Sub topic for all vendor data, employ Dataflow to process and sanitize the Pub/Sub data, and then stream it to BigQuery.