Question 1A retail forecasting team has historical sales in BigQuery and needs an interpretable weekly demand baseline without building a custom training service. Which proposed approach best resolves the described model engineering problem? Use a suitable Document AI processor and validate extracted entities and confidence for the document type. Use an appropriate BigQuery ML prediction function such as ML.PREDICT on the authorized and schema-compatible input table. Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. Implement documented BigQuery SQL feature transformations and ensure the same transformations are used for inference. ExplanationCorrect Answer C:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. To validate the correction: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:Document AI processors combine document-aware parsing and extraction rather than requiring custom tabular classification pipelines. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. B:SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. D:Feature engineering can improve predictiveness but fitting transformations with holdout or future data introduces leakage. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported.
Question 2A retail forecasting team has historical sales in BigQuery and needs an interpretable weekly demand baseline without building a custom training service. Which property of the selected ML workflow accounts for this requirement? Supervised regression models estimate continuous outcomes and differ from classification models that predict labels. A managed translation API provides language translation without the cost of building a custom sequence model. SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. ExplanationCorrect Answer D:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. This supports the specific implementation: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. A suitable independent check is: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:Supervised regression models estimate continuous outcomes and differ from classification models that predict labels. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. B:A managed translation API provides language translation without the cost of building a custom sequence model. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. C:SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs.
Question 3A retail forecasting team has historical sales in BigQuery and needs an interpretable weekly demand baseline without building a custom training service. Which measurement or test should the team perform after implementation? Use a blind held-out task set and compare accuracy, safety refusals, p95 latency and per-request cost across candidates. Inspect confusion matrix, class precision and recall, calibration, and holdout leakage for ML.EVALUATE results. Compare residual patterns, MAE and error by subgroup using held-out target values unavailable during fitting. Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. ExplanationCorrect Answer D:Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. This tests the underlying failure: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. Other Answers A:Model Garden exposes supported model options, but quality, hosting terms, capabilities and cost differ by model and configuration. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. B:Logistic regression estimates classification probability from supervised tabular features and can be trained using SQL in BigQuery ML. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. C:Supervised regression models estimate continuous outcomes and differ from classification models that predict labels. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline.
Question 4A retail forecasting team has historical sales in BigQuery and needs an interpretable weekly demand baseline without building a custom training service. Which repeatable process control should the ML engineering team adopt? Maintain feature eligibility and label-definition tests and compare classification metrics against a stable baseline. Govern labels, privacy and held-out validation splits before every managed AutoML training run. Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. Maintain API-version and image-quality regression tests and review consent and retention for processed media. ExplanationCorrect Answer C:Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. This protects the selected approach because BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. The immediate solution is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. Other Answers A:Logistic regression estimates classification probability from supervised tabular features and can be trained using SQL in BigQuery ML. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. B:Managed AutoML automates aspects of model selection and training but still depends on representative correctly labeled data. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. D:A prebuilt image API can return predefined vision annotations without supervised custom-training maintenance. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining.
Question 5A parts distributor needs store-level demand predictions from existing SQL tables with a small data-science team. Which implementation response is most appropriate for this ML engineering situation? Choose Gemini Enterprise Agent Platform AutoML for a supported labeled task and prepare its required training dataset. Train a BigQuery ML clustering model, such as k-means, and evaluate segment stability and meaningful cluster features. Use a suitable Document AI processor and validate extracted entities and confidence for the document type. Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. ExplanationCorrect Answer D:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. To validate the correction: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:Managed AutoML automates aspects of model selection and training but still depends on representative correctly labeled data. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. B:Unsupervised clustering organizes examples by similarity without requiring labeled supervised target values. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. C:Document AI processors combine document-aware parsing and extraction rather than requiring custom tabular classification pipelines. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported.
Question 6A parts distributor needs store-level demand predictions from existing SQL tables with a small data-science team. Which technical mechanism is most relevant to this outcome? Supervised regression models estimate continuous outcomes and differ from classification models that predict labels. BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. Managed AutoML automates aspects of model selection and training but still depends on representative correctly labeled data. A prebuilt image API can return predefined vision annotations without supervised custom-training maintenance. ExplanationCorrect Answer B:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. This supports the specific implementation: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. A suitable independent check is: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:Supervised regression models estimate continuous outcomes and differ from classification models that predict labels. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. C:Managed AutoML automates aspects of model selection and training but still depends on representative correctly labeled data. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. D:A prebuilt image API can return predefined vision annotations without supervised custom-training maintenance. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs.
Question 7A parts distributor needs store-level demand predictions from existing SQL tables with a small data-science team. What is the most relevant acceptance check for the proposed ML change? Run bilingual spot checks for entity preservation, specialized terminology and detected language before adoption. Inspect example transformed rows and compare training-serving feature schemas and holdout model quality after the change. Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Check held-out per-class metrics, representative error examples and label coverage after training completes. ExplanationCorrect Answer C:Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. This tests the underlying failure: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. Other Answers A:A managed translation API provides language translation without the cost of building a custom sequence model. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. B:Feature engineering can improve predictiveness but fitting transformations with holdout or future data introduces leakage. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. D:Managed AutoML automates aspects of model selection and training but still depends on representative correctly labeled data. That does not establish the required outcome; verify it by checking: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline.
Question 8A parts distributor needs store-level demand predictions from existing SQL tables with a small data-science team. What governance or operational safeguard should accompany the implementation? Add versioned model references and schema checks to scheduled inference SQL so model changes do not silently break jobs. Version feature SQL, enforce timestamp cutoffs and add automated feature-schema contract tests. Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. Keep a model-selection decision log and re-evaluate providers or model versions after capability or policy changes. ExplanationCorrect Answer C:Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. This protects the selected approach because BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. The immediate solution is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. Other Answers A:SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. B:Feature engineering can improve predictiveness but fitting transformations with holdout or future data introduces leakage. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining. D:Model Garden exposes supported model options, but quality, hosting terms, capabilities and cost differ by model and configuration. The continuing safeguard required here is: Version SQL training queries and dataset snapshots and monitor forecast error by season before automatic retraining.
Question 9A municipal team needs a reproducible supervised forecast using existing warehouse data and scheduled SQL jobs. Which proposed approach best resolves the described model engineering problem? Evaluate supported Gemini fine-tuning through the current BigQuery and Agent Platform workflow with a held-out evaluation set. Create and evaluate a BigQuery ML logistic-regression classifier using labeled historical rows and an appropriate temporal split. Evaluate candidate models from Gemini Enterprise Agent Platform Model Garden against task, cost, latency and governance criteria. Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. ExplanationCorrect Answer D:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. To validate the correction: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:Fine-tuning adapts model behavior to examples, whereas prompt changes alone do not update underlying model parameters. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. B:Logistic regression estimates classification probability from supervised tabular features and can be trained using SQL in BigQuery ML. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. C:Model Garden exposes supported model options, but quality, hosting terms, capabilities and cost differ by model and configuration. It does not resolve the specific failure; the targeted correction is: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported.
Question 10A municipal team needs a reproducible supervised forecast using existing warehouse data and scheduled SQL jobs. Which underlying ML principle makes the proposed approach effective? SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. Logistic regression estimates classification probability from supervised tabular features and can be trained using SQL in BigQuery ML. Model Garden exposes supported model options, but quality, hosting terms, capabilities and cost differ by model and configuration. BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. ExplanationCorrect Answer D:BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. This supports the specific implementation: Train a suitable BigQuery ML forecasting model from the governed SQL dataset and generate predictions with ML.FORECAST where supported. A suitable independent check is: Compare rolling-origin holdout forecast errors and inspect the BigQuery ML evaluation and prediction output against a seasonal baseline. Other Answers A:SQL-based prediction runs a stored compatible warehouse model against supplied features and writes structured prediction columns. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. B:Logistic regression estimates classification probability from supervised tabular features and can be trained using SQL in BigQuery ML. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs. C:Model Garden exposes supported model options, but quality, hosting terms, capabilities and cost differ by model and configuration. The cause in the stated scenario is different: BigQuery ML executes supported model training and prediction within the warehouse, reducing separate data export and custom infrastructure needs.