nerdexam
Google

PROFESSIONAL-MACHINE-LEARNING-ENGINEER · Question #263

You work for a company that sells corporate electronic products to thousands of businesses worldwide. Your company stores historical customer data in BigQuery. You need to build a model that…

The correct answer is B. Run the CREATE MODEL statement from the BigQuery console to create an AutoML model. To predict customer lifetime value from BigQuery data using the simplest approach with access to visualization tools, BigQuery ML's CREATE MODEL statement with AutoML is the most suitable.

Submitted by helene.fr· Apr 18, 2026ML model development

Question

You work for a company that sells corporate electronic products to thousands of businesses worldwide. Your company stores historical customer data in BigQuery. You need to build a model that predicts customer lifetime value over the next three years. You want to use the simplest approach to build the model and you want to have access to visualization tools. What should you do?

Options

  • ACreate a Vertex AI Workbench notebook to perform exploratory data analysis. Use IPython
  • BRun the CREATE MODEL statement from the BigQuery console to create an AutoML model.
  • CCreate a Vertex AI Workbench notebook to perform exploratory data analysis and create input
  • DCreate a Vertex AI Workbench notebook to perform exploratory data analysis. Use IPython

How the community answered

(35 responses)
  • A
    3% (1)
  • B
    80% (28)
  • C
    11% (4)
  • D
    6% (2)

Why each option

To predict customer lifetime value from BigQuery data using the simplest approach with access to visualization tools, BigQuery ML's `CREATE MODEL` statement with AutoML is the most suitable.

ACreate a Vertex AI Workbench notebook to perform exploratory data analysis. Use IPython

Creating a Vertex AI Workbench notebook, even for EDA, involves more manual setup and coding effort than a single SQL statement in BigQuery ML, thus not being the simplest approach.

BRun the CREATE MODEL statement from the BigQuery console to create an AutoML model.Correct

Using the `CREATE MODEL` statement in BigQuery ML with AutoML is the simplest method for building a model directly from BigQuery data, as it requires minimal code and automatically handles model selection. BigQuery ML integrates with the BigQuery console for visualizations and easily connects to other BI tools.

CCreate a Vertex AI Workbench notebook to perform exploratory data analysis and create input

Similar to A, using a Vertex AI Workbench notebook for EDA and creating input datasets is a more manual process, which deviates from the 'simplest approach' requirement.

DCreate a Vertex AI Workbench notebook to perform exploratory data analysis. Use IPython

This option is identical to A and represents a more code-intensive and less simple method for initial model building compared to BigQuery ML.

Concept tested: BigQuery ML for simplified model creation

Source: https://cloud.google.com/bigquery-ml/docs/introduction

Topics

#BigQuery ML#AutoML#Customer Lifetime Value#Model development

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PROFESSIONAL-MACHINE-LEARNING-ENGINEER Practice