PMLE Architecting Low-Code ML Solutions — 10 Questions

Question 1

A retail company wants to predict customer churn using historical purchase data stored in BigQuery. The data includes customer demographics, transaction history, and support interactions. The team is comfortable writing SQL and wants to avoid moving data to a separate environment. Which approach should they take?

Accepted Answer

Use BigQuery ML to create a logistic regression model (LOGISTIC_REG) on the data directly in BigQuery.. Option C is correct because BigQuery ML allows the team to build and train a logistic regression model directly on data stored in BigQuery using SQL syntax, without moving data to a separate environment. The LOGISTIC_REG model type is specifically designed for binary classification tasks like churn prediction, and it runs entirely within BigQuery's serverless infrastructure, satisfying the team's requirement to avoid data movement.

Answer

Use the Cloud Natural Language API to analyze customer support interactions and combine results with purchase data in BigQuery.

Answer

Export the data to a CSV file and use Vertex AI AutoML Tables to train a classification model.

Answer

Create a Dataflow pipeline to stream data to Cloud SQL and use Cloud SQL's built-in ML functions.

Question 2

A data scientist needs to train a time-series forecasting model on historical sales data stored in BigQuery to predict future demand. The data has strong seasonal patterns. Which BigQuery ML model type should they use?

Accepted Answer

ARIMA_PLUS. ARIMA_PLUS is the correct choice because it is specifically designed for time-series forecasting in BigQuery ML, handling seasonal patterns, trend decomposition, and automatic hyperparameter tuning. It models autoregressive (AR) and moving average (MA) components with seasonal differencing, making it ideal for historical sales data with strong seasonal cycles.

Answer

MATRIX_FACTORIZATION

Answer

BOOSTED_TREE_REGRESSOR

Answer

K_MEANS

Question 3

A healthcare provider needs to extract structured information from incoming PDF forms (e.g., patient intake forms). They want to automate data extraction without writing custom models. Which Google Cloud service should they use?

Accepted Answer

Document AI with a form parser processor. Document AI with a form parser processor is the correct choice because it is purpose-built for extracting structured data from PDF forms, including key-value pairs and tables, without requiring custom model development. It uses pre-trained models specifically for form understanding, making it ideal for automating intake form processing.

Answer

Natural Language API for entity extraction

Answer

Vision API

Answer

AutoML Vision for object detection

Question 4

A company wants to build a product recommendation engine for their e-commerce website. They have historical purchase data and user interaction logs. They want a managed service that can quickly generate personalized recommendations without building custom models. Which service should they use?

Accepted Answer

Recommendations AI. Recommendations AI is a managed service specifically for retail recommendation use cases. It offers pre-built models like 'recommended-for-you' and 'frequently-bought-together'. BigQuery ML would require custom model building, and AutoML Tables is for general tabular data, not specifically for recommendations.

Answer

Dataflow with TensorFlow

Answer

BigQuery ML with MATRIX_FACTORIZATION

Answer

AutoML Tables

Question 5

A media company wants to automatically moderate user-uploaded videos by detecting explicit content (e.g., violence, adult material). They need a solution that integrates with their video processing pipeline and scales to millions of videos. Which approach should they take?

Accepted Answer

Use Video Intelligence API with explicit content detection. Video Intelligence API provides explicit content detection as a pre-built feature. It can analyze video content and flag inappropriate material. AutoML Video would require custom training, which is unnecessary. Vision API is for images. Natural Language API is for text.

Answer

Use AutoML Video to train a custom explicit content detection model

Answer

Use Natural Language API on video transcripts

Answer

Use Vision API to analyze each video frame

Question 6

A company wants to transcribe customer service calls in real-time to detect sentiment and identify urgent issues. They need a solution with low latency. Which combination of pre-built APIs should they use?

Accepted Answer

Speech-to-Text and Natural Language API. Speech-to-Text can transcribe audio in real-time, and Natural Language API can analyze sentiment from the transcribed text. Text-to-Speech is for generating speech. Video Intelligence is for video content.

Answer

Text-to-Speech and Natural Language API

Answer

Speech-to-Text and Translation API

Answer

Video Intelligence API

Question 7

A data analyst wants to train a binary classification model in BigQuery ML on a dataset of 10 million rows with 50 features. They need to evaluate the model's performance on a held-out test set. Which sequence of SQL statements should they run?

Accepted Answer

CREATE MODEL then ML.EVALUATE. First, create the model using CREATE MODEL. Then, evaluate it using ML.EVALUATE, which uses the test split defined in the model options. ML.PREDICT is for predictions, not evaluation. ML.TRAIN is not a valid function; model training is done via CREATE MODEL.

Answer

CREATE MODEL then ML.FEATURE_IMPORTANCE

Answer

ML.TRAIN then ML.EVALUATE

Answer

CREATE MODEL then ML.PREDICT

Question 8

A financial services company uses Document AI to process loan applications. They want to ensure that any documents the model cannot process with high confidence are reviewed by a human before finalizing the decision. Which Document AI feature should they enable?

Accepted Answer

Human-in-the-Loop (HITL). Human-in-the-Loop (HITL) allows documents with low confidence scores to be routed to human reviewers. This is a built-in feature of Document AI. AutoML Tables is not directly related. Cloud DLP is for data loss prevention.

Answer

AutoML Tables model retraining

Answer

Cloud DLP for data inspection

Answer

Increase the number of processors

Question 9

A company has a large dataset of labeled images (e.g., different species of plants). They want to train a custom image classification model with minimal effort and no prior ML experience. Which Google Cloud service should they use?

Accepted Answer

AutoML Vision. AutoML Vision is the correct choice because it allows users with no prior ML experience to train a custom image classification model using a simple graphical interface, requiring only labeled images as input. It automates model architecture search, hyperparameter tuning, and deployment, minimizing manual effort while delivering a production-ready model.

Answer

Cloud TPU

Answer

Vertex AI Workbench with a custom TensorFlow model

Answer

Vision API

Question 10

A developer wants to add text translation to a mobile app. They need to translate user-generated content into multiple languages, and latency is critical. Which pre-built API should they use?

Accepted Answer

Translation API. Translation API provides fast, real-time translation for text. Natural Language API is for analysis. Text-to-Speech is for audio. Vision API is for images.

Answer

Vision API

Answer

Text-to-Speech API

Answer

Natural Language API