What is the role of BigQuery in fine-tuning Gemini models?

To execute the fine-tuning process

To evaluate the fine-tuned model

To prepare and manage the training data

A marketing team wants to segment their customer base into distinct groups based on purchasing behavior, demographics, and engagement metrics. They have a table `customers` with columns `customer_id`, `total_spend`, `purchase_frequency`, `avg_order_value`, and `age`. They want to use BigQuery ML to create these segments and then assign new customers to the most appropriate segment. Which model type and prediction function should they use?

Logistic regression model with ML.PREDICT to classify customers into segments

ARIMA_PLUS model with ML.FORECAST to predict future segment membership

Linear regression model with ML.PREDICT to predict a segment score

K-means model with ML.PREDICT to assign new customers to clusters

Google CloudProfessional Machine Learning Engineer

Domain 1Objective 1

Developing ML Models Using BigQuery ML or AutoML on Gemini Enterprise Agent Platform PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice Questions (Page 4)

Part of the Architecting low-code AI solutions domain, which accounts for ~13% of the PROFESSIONAL-MACHINE-LEARNING-ENGINEER exam.

26questions here

6free pages

10concepts

~13%of the exam

10 Concepts in This Objective

Selecting BigQuery ML model types
Building classification models in BigQuery ML
Building regression models in BigQuery ML
Building forecasting models in BigQuery ML
Building clustering models in BigQuery ML
Performing feature engineering in BigQuery ML
Performing feature selection in BigQuery ML
Generating predictions with BigQuery ML
Training models with Agent Platform AutoML
Fine-tuning Gemini models using BigQuery

Questions 16–20

16foundation · easy
After training a BigQuery ML model named `churn_model`, which SQL function is used to generate predictions on new data stored in a table `new_customers`?
Select an answer first
17foundation · easy
A logistics company wants to use BigQuery ML to forecast package delivery times based on historical data. The target variable is the delivery duration in hours, which is a continuous numeric value. Which BigQuery ML model type should be used?
Select an answer first
18foundation · easy
What is the role of BigQuery in fine-tuning Gemini models?
Select an answer first
19application · medium
A marketing team wants to segment their customer base into distinct groups based on purchasing behavior, demographics, and engagement metrics. They have a table `customers` with columns `customer_id`, `total_spend`, `purchase_frequency`, `avg_order_value`, and `age`. They want to use BigQuery ML to create these segments and then assign new customers to the most appropriate segment. Which model type and prediction function should they use?
Select an answer first
20foundation · easy
A real estate company wants to build a BigQuery ML model to predict house prices. The target variable `price` is a continuous numeric value. Which model type should be specified in the `OPTIONS` clause?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-MACHINE-LEARNING-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-MACHINE-LEARNING-ENGINEER” is a trademark of its owner, used for identification only.

Developing ML Models Using BigQuery ML or AutoML on Gemini Enterprise Agent Platform PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice Questions (Page 4)

Questions 16–20

After training a BigQuery ML model named `churn_model`, which SQL function is used to generate predictions on new data stored in a table `new_customers`?

A logistics company wants to use BigQuery ML to forecast package delivery times based on historical data. The target variable is the delivery duration in hours, which is a continuous numeric value. Which BigQuery ML model type should be used?

What is the role of BigQuery in fine-tuning Gemini models?

A real estate company wants to build a BigQuery ML model to predict house prices. The target variable `price` is a continuous numeric value. Which model type should be specified in the `OPTIONS` clause?

Keep studying — Architecting low-code AI solutions