Quick Answer
The answer is BigQuery ML with the CREATE MODEL statement using SQL. This is the correct choice because BigQuery ML enables binary classification directly within BigQuery’s serverless environment using familiar SQL syntax, allowing a data scientist to train a model without writing any code or moving data—ideal for users with limited ML experience. On the Google Professional Machine Learning Engineer exam, this scenario tests your understanding of low-code ML solutions within the BigQuery ecosystem, often appearing as a trap where candidates might overthink and suggest Vertex AI AutoML or custom training jobs. The key distinction is that BigQuery ML’s CREATE MODEL statement handles the entire training pipeline in-database, making it the fastest path for tabular data already in BigQuery. Memory tip: think “SQL-first, no code move”—if the data lives in BigQuery and the user knows SQL, BigQuery ML is the default answer for quick binary classification.
This PMLE practice question tests your understanding of architecting low-code ml solutions. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A data scientist wants to quickly train a binary classification model on a tabular dataset stored in BigQuery without writing any code. They have limited ML experience. Which Google Cloud service should they use?
Vertex AI Workbench with a built-in scikit-learn notebook.
Why wrong: Requires Python coding and environment setup.
Dataflow with a TensorFlow pipeline.
Why wrong: Dataflow is for data processing, not training.
BigQuery ML with CREATE MODEL statement using SQL.
BigQuery ML enables model creation with SQL, no coding required.
AutoML Tables with a direct BigQuery connection.
Why wrong: AutoML Tables is not SQL-based; it requires a UI or API.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
BigQuery ML with CREATE MODEL statement using SQL.
Option C is correct because BigQuery ML allows a data scientist to train a binary classification model directly in BigQuery using a `CREATE MODEL` SQL statement, without writing any code or moving data. This is the fastest low-code approach for users with limited ML experience, as it leverages familiar SQL syntax and runs entirely within BigQuery's serverless infrastructure.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Vertex AI Workbench with a built-in scikit-learn notebook.
Why it's wrong here
Requires Python coding and environment setup.
Dataflow with a TensorFlow pipeline.
Why it's wrong here
Dataflow is for data processing, not training.
BigQuery ML with CREATE MODEL statement using SQL.
Why this is correct
BigQuery ML enables model creation with SQL, no coding required.
Related concept
Read the scenario before looking for a memorised answer.
AutoML Tables with a direct BigQuery connection.
Why it's wrong here
AutoML Tables is not SQL-based; it requires a UI or API.
Common exam traps
Google Cloud often tests the distinction between 'low-code' (BigQuery ML) and 'no-code' (AutoML) services, but the trap here is that AutoML Tables requires more setup and data movement, while BigQuery ML is the fastest no-code option for users already working in BigQuery.
Detailed technical explanation
BigQuery ML uses the `CREATE MODEL` statement with the `OPTIONS(model_type='LOGISTIC_REG')` clause to train a logistic regression model for binary classification, automatically handling feature engineering, scaling, and evaluation. Under the hood, it leverages BigQuery's distributed processing to train on large datasets without data export, and the model is stored as a BigQuery object that can be used for prediction via `ML.PREDICT`. A subtle behavior is that BigQuery ML automatically one-hot encodes categorical features and handles missing values, which can surprise users expecting manual preprocessing.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Architecting low-code ML solutions — study guide chapter
Learn the concepts, then practise the questions
Architecting low-code ML solutions practice questions
Targeted practice on this topic area only
All PMLE questions
506 questions across all exam domains
Google Professional Machine Learning Engineer study guide
Full concept coverage aligned to exam objectives
PMLE practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise PMLE questions linked to Scaling prototypes into ML models.
Practise PMLE questions linked to Automating and orchestrating ML pipelines.
Practise PMLE questions linked to Collaborating within and across teams to manage data and models.
Practise PMLE questions linked to Architecting low-code ML solutions.
Practise PMLE questions linked to Collaborating to manage data and models.
Practise PMLE questions linked to Serving and scaling models.
Practise PMLE questions linked to Monitoring ML solutions.
Practise PMLE questions linked to Solving business challenges with ML.
Practise PMLE questions linked to PMLE fundamentals.
Practise PMLE questions linked to PMLE scenario.
Practise PMLE questions linked to PMLE troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Architecting low-code ML solutions — This question tests Architecting low-code ML solutions — Read the scenario before looking for a memorised answer..
The correct answer is: BigQuery ML with CREATE MODEL statement using SQL. — Option C is correct because BigQuery ML allows a data scientist to train a binary classification model directly in BigQuery using a `CREATE MODEL` SQL statement, without writing any code or moving data. This is the fastest low-code approach for users with limited ML experience, as it leverages familiar SQL syntax and runs entirely within BigQuery's serverless infrastructure.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Keep practising
Last reviewed: Jun 30, 2026
This PMLE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PMLE exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.