CCNA Pmle Low Code Ml Questions

Document AI extracts invoice fields via prebuilt or custom models, returning per-field confidence scores. Human-in-the-Loop routes only low-confidence extractions to reviewers, satisfying the stem's accuracy requirement while keeping the service fully managed. This pairing directly matches the stated need for human review of uncertain results.

AutoML Video lets you train a custom model on labelled video to detect and track objects specific to your domain, then serve predictions on new footage. This satisfies the movement-tracking requirement when pre-trained labels are insufficient.

DNN_CLASSIFIER fits because churn prediction is binary classification, and the stem specifies a deep neural network. BigQuery ML's DNN_CLASSIFIER trains a feed-forward neural network with a logistic output layer, satisfying both the label-column requirement and the requested architecture, unlike DNN_REGRESSOR, which predicts continuous values.

Logistic regression is a linear model for binary classification that provides interpretable coefficients, making it suitable for explainable predictions. It trains quickly on structured data and handles both numerical and categorical features after preprocessing. For predicting patient readmission (a binary outcome), logistic regression is a strong choice in BigQuery ML, especially when explainability is required. It also supports regularization to prevent overfitting.

LOGISTIC_REG performs binary logistic regression inside BigQuery, outputting probabilities for two-class labels such as churn or no churn. It satisfies the stem's requirement for a binary classification model built directly through SQL, with no data export or external tooling needed.

The Natural Language API provides pre-trained sentiment analysis, returning positive, negative and neutral scores without any custom training. It integrates directly with BigQuery data, satisfying the requirement for a pre-trained model applied to stored review text.

The Natural Language API performs sentiment analysis on text, satisfying the requirement to analyse the transcribed call content. Speech-to-Text handles the audio transcription; Natural Language API then classifies each transcript's sentiment. Together they cover both stages of the pipeline, making this one of the two required services.

ML.CONFUSION_MATRIX generates a confusion matrix showing true positives, true negatives, false positives, and false negatives. This is useful for understanding the types of errors the model makes, which is critical when the cost of false positives and false negatives differs, as in churn prediction.

AutoML text classification is a managed, low-code service that trains on a labeled CSV in a Vertex AI dataset and exposes a prediction endpoint for app integration. It handles model selection and tuning, matching the team's lack of ML engineers and need for a callable API.

Recommended-for-you is a genuine Recommendations AI type that personalises suggestions per user from their browsing history and past behaviour. This directly matches the stem's requirement to generate personalised recommendations based on browsing and purchase activity.

AutoML Natural Language allows training custom text classification models with as few as 50 labeled documents per category. It provides a low-code UI and API, and can deploy models for online predictions. It is designed for exactly this scenario: small labeled datasets and quick training.

Human-in-the-Loop routes low-confidence or high-risk clause extractions to human reviewers before finalising results, satisfying the stem's requirement for mandatory human review of high-risk clauses. Document AI's confidence thresholds trigger this escalation automatically, so contracts proceed without manual intervention except where risk demands it.

A Cloud Storage bucket receiving uploads can publish object notifications to Pub/Sub, which then triggers the video analysis step. This serverless eventing is the standard low-code way to automate ingestion so each new video is processed and its metadata stored without manual intervention.

CREATE MODEL with model_type='tensorflow' imports an existing SavedModel directly from Cloud Storage, so BigQuery ML serves predictions without retraining. This satisfies the stem's constraint: the locally trained TensorFlow artefact is deployed as-is, with no data or training step required in BigQuery.

BigQuery ML trains the model with CREATE MODEL, which handles the 10-million-row, 50-feature dataset natively in SQL. ML.EVALUATE then scores that trained model against the held-out test set, returning precision, recall, AUC and related metrics, satisfying the evaluation requirement without exporting data.

BigQuery ML's AUTOML_CLASSIFIER model type trains directly on BigQuery data using SQL while running AutoML architecture search and hyperparameter tuning behind the scenes. This satisfies both the SQL-in-BigQuery requirement and the demand for automated model selection on structured EHR data.

The Video Intelligence API provides explicit content detection purpose-built for video, analysing frames and audio for violence and adult material. It integrates into automated pipelines and scales elastically, satisfying the stem's requirement to moderate millions of videos without building custom models.

Vertex AI accepts SavedModel artefacts directly, so uploading the existing model and deploying it to an endpoint avoids retraining or conversion. This is the most efficient route to online predictions for a TensorFlow model trained outside Google Cloud.

AutoML Vision trains a custom image classification model from labelled images through a graphical interface, requiring minimal code. It fits the three document categories and the labelled training images, unlike pre-built Vision API which cannot learn bespoke classes.

Document AI's form parser processor extracts key-value pairs and tables from scanned PDFs via OCR and layout-aware parsing, satisfying the structured-data requirement. Enabling Human-in-the-Loop routes high-risk applications to human reviewers, directly meeting the mandated review step for those cases.

Regular retraining with human-verified data directly addresses the accuracy constraint by feeding corrected edge-case extractions back into the processor, letting it learn the specific invoice variations it previously misread. This closes the loop on uncertain predictions, since human review resolves ambiguity that the model alone cannot, progressively raising extraction confidence across the pipeline.

ML.EVALUATE computes standard classification metrics such as precision, recall, accuracy, F1 score, log loss and ROC AUC against a labelled dataset. It is the BigQuery ML function designed for assessing an already-trained model's performance, unlike ML.PREDICT, which only returns predictions.

AutoML Natural Language allows training custom text classification models with minimal coding, using labeled data. It handles preprocessing, training, and deployment automatically. With 5,000 labeled emails, it can achieve high accuracy and is ideal for teams with limited ML expertise. It integrates with other Google Cloud services and provides a user-friendly interface, making it the best fit for this low-code scenario.

ML.EVALUATE is a function that computes evaluation metrics for a trained model, such as RMSE for regression. It is essential to assess model performance and ensure it meets business needs. You run it against a dataset not used in training. This step is necessary for model validation and is performed via SQL, maintaining the low-code approach.

ARIMA_PLUS is designed for univariate time series forecasting and can handle multiple time series by specifying a time series ID column. It automatically handles seasonality, holidays, and trends, and can incorporate additional regressors like promotions. This requires only SQL, matching the team's low-code requirement and the need to forecast per store.

AutoML Natural Language performs text classification on labelled data, training a model that assigns support emails to categories such as billing, technical or account, matching the labelled email text and multi-class requirement in the stem.

AutoML image classification accepts labeled images referenced from Cloud Storage, trains a managed classifier, and deploys an endpoint callable by the viewing software. It requires no model code, fitting a radiology team without data scientists who need a fast, managed path to a pneumonia flagger.

Vertex AI AutoML provides a fully managed, no-code environment where users can upload data and automatically train models with feature engineering and hyperparameter tuning handled by the service. It supports tabular data for regression tasks like predicting CLV. The marketing team can use the UI without writing code, making it the ideal low-code solution.

ARIMA_PLUS handles time-series forecasting natively in BigQuery ML, modelling trend, seasonality and holidays directly from historical data. It satisfies the requirement to forecast the next 30 days of daily sales without exporting data, and supports the forecast horizon through its horizon parameter.

AUTOML_CLASSIFIER satisfies the automatic tuning constraint: BigQuery ML performs hyperparameter tuning and architecture search internally, so no manual configuration is needed. It handles binary classification directly, matching the churn prediction task, unlike boosted tree or logistic regression models, which require the engineer to specify tuning themselves.

BigQuery ML trains models inside BigQuery using SQL, so data never leaves the warehouse. LOGISTIC_REG builds binary classification directly on the table, and CREATE MODEL keeps the workflow within SQL, matching the limited ML expertise and no-data-movement constraints.

Human-in-the-Loop routes low-confidence extractions to human reviewers before decisions finalise, directly satisfying the requirement that uncertain documents receive manual review. Document AI assigns confidence scores per field, and HITL triggers review when those scores fall below your configured threshold, ensuring no unreliable output reaches the loan decision.

BOOSTED_TREE_CLASSIFIER is an ensemble model that often achieves higher accuracy on tabular data with non-linear relationships, such as loan default prediction. It is fully supported in BigQuery ML, requires only SQL to train, and automatically handles feature engineering like categorical encoding. With 30,000 examples, it has sufficient data to train effectively without overfitting, making it ideal for this low-code, high-performance scenario.

ARIMA_PLUS handles time-series forecasting natively in BigQuery ML, requiring only a single CREATE MODEL statement on the historical sales column. It automatically detects seasonality, trends and holidays, satisfying the 12-month horizon and minimal-coding constraint without exporting data or writing Python.

The Translation API is a pre-built, low-latency service supporting many language pairs, so it meets the requirement to translate user-generated content into multiple languages without training custom models. Custom translation would add latency and development overhead.

This statement correctly creates a logistic regression model in BigQuery ML. It specifies the model type as logistic_reg and identifies the label column as 'clicked' using the input_label_cols option. The SELECT statement provides the training data, which includes both features and the label. BigQuery ML will automatically use all other columns as features, making it suitable for users with limited ML expertise.

Vertex AI AutoML Tables automatically performs feature engineering, including one-hot encoding, normalization, and feature selection, and selects the best model architecture. It supports online prediction with low latency when deployed to an endpoint. This aligns perfectly with the need for a low-code solution that handles feature engineering and provides real-time fraud detection. It is the most suitable choice for this scenario.

Document AI is a fully managed service that uses pre-trained and customizable models to parse documents, extract text, and identify structured fields. It supports form parsing and can be used with minimal ML expertise via the console or API. It is ideal for processing loan applications with varying layouts.

AutoML Vision trains custom image classifiers through a point-and-click interface, using transfer learning on Google's pretrained models. This satisfies the stem's constraints: labelled plant images, minimal effort, and no ML expertise. Vertex AI Vision now supersedes it, but AutoML Vision remains the purpose-built answer for codeless custom classification.

Speech-to-Text streams audio into text with low latency, and the Natural Language API then performs sentiment analysis and entity detection on that text. Together they deliver real-time transcription plus sentiment and urgency identification without training custom models.

Gemini in BigQuery translates natural-language prompts into SQL against the firm's tables and schemas, letting managers ask churn-style questions without writing queries. It keeps data in BigQuery and requires no bespoke codebase, matching the low-maintenance, in-warehouse requirement.

Recommendations AI is a managed Google Cloud service that trains on historical purchase and interaction data to serve personalised product recommendations, satisfying the requirement to avoid building custom models. It handles model training, tuning and serving, so the team gains personalisation without ML engineering effort.

ML.FEATURE_IMPORTANCE returns a per-feature score showing how strongly each input influenced the trained boosted tree model's predictions. It is the BigQuery ML function designed for interpreting model behaviour, satisfying the requirement to identify the most influential features.

The frequently-bought-together model type is purpose-built to surface item pairs or sets commonly purchased in the same transaction, matching the retail 'frequently bought together' requirement. Other model types target different goals such as personalised ranking or similar-item recommendations.

ML.EXPLAIN_PREDICT returns predictions alongside feature attributions for the supplied rows, using explainable AI methods such as Shapley values or integrated gradients, which is exactly the per-row explanation the engineer needs from the boosted tree classifier.

LINEAR_REG is BigQuery ML's built-in linear regression model type, trained directly with CREATE MODEL on a numeric label such as house price. It satisfies the constraint of using only SQL, requiring no exported data or external framework.

The telephony model is trained on 8 kHz narrowband audio, matching the bandwidth of phone calls, and is optimised to suppress background noise. This directly satisfies the stem's call centre constraint: English telephone speech with noise, where the default model's wideband training would degrade accuracy.

AutoML Vision handles multi-class image classification directly, supporting up to 50 categories without custom architecture work. It ingests the 100,000 labelled images and trains a managed model, satisfying the stem's classification requirement. Vertex AI's image data type is the appropriate task-specific service here, unlike tabular or video alternatives.

ARIMA_PLUS handles seasonality natively through automatic seasonal decomposition and multiple seasonal period detection, satisfying the strong seasonal patterns constraint in the historical sales data. It also supports forecasting horizons directly in BigQuery ML, letting the data scientist train and predict demand without exporting data.

Vertex AI AutoML Tabular automates model training and tuning for tabular data, minimizing coding. Once trained, the model can be deployed to a Vertex AI endpoint, which provides a REST API for real-time predictions. This end-to-end integration requires minimal effort and meets the requirement for a custom model with low-code and REST API access.

BigQuery ML's matrix factorization model is specifically designed for recommendation tasks. It can be trained directly on user-item interaction data using SQL, which is low-code. The ML.RECOMMEND function then generates top-N recommendations for all users efficiently. This approach meets the requirement for a low-code solution that scales to all users, making it the ideal choice for this scenario.

Contact Center AI Insights is designed to analyze customer interactions, providing transcription, sentiment analysis, and topic detection out of the box. It is a low-code solution that integrates with various contact center platforms. It can automatically process calls and surface insights without custom model development. This directly meets the requirement for both transcription and sentiment analysis in a low-code manner.

BigQuery ML trains LOGISTIC_REG models using SQL directly against BigQuery-resident data, so no extraction or separate environment is needed. This satisfies the team's SQL comfort and the constraint of avoiding data movement for churn prediction.

BigQuery ML's ARIMA_PLUS model is specifically designed for time series forecasting. It automatically handles seasonality, trends, and holiday effects, and can generate forecasts for multiple time steps. It requires only SQL to train and predict, making it a low-code solution. Given the clean daily sales data, ARIMA_PLUS is well-suited to produce accurate 30-day forecasts without manual feature engineering.

Document AI's form parser processor is a pretrained model that extracts key-value pairs and tables from PDFs, requiring no custom model training. This directly satisfies the constraint of automating structured extraction from intake forms without writing custom models.

ARIMA_PLUS is a built-in BigQuery ML model for time series forecasting that automatically handles seasonality, trends, and holidays. It is designed for forecasting multiple time series, such as sales per store, and can process large datasets. It provides explainable forecasts and requires only the time series identifier, timestamp, and value columns. This makes it ideal for the retail company's monthly sales forecasting across many stores.

Recommendations AI is a managed Google Cloud service that ingests historical transaction data and produces personalised product recommendations such as 'frequently bought together', satisfying the managed-service and recommendation-quality constraints. It removes the need to build and train custom recommendation models.

BigQuery ML supports logistic regression for binary classification directly via SQL. The CREATE MODEL statement with model_type='LOGISTIC_REG' trains the model without Python, and ML.PREDICT generates predictions in SQL. Logistic regression is inherently explainable because coefficients indicate feature importance and direction, satisfying the explainability requirement.

Invoice Parser combines OCR with pre-trained extraction of invoice-specific fields such as invoice number and total amount, satisfying the requirement to parse key fields from scanned invoices. Unlike generic OCR, which returns raw text only, it maps recognised content directly to structured invoice schema, removing custom model training.

This statement correctly creates a matrix factorization model in BigQuery ML. It specifies the model type as matrix_factorization and identifies the user column, item column, and rating column. The SELECT statement provides the training data with user-item interactions and ratings. This is the standard syntax for building a recommendation model using collaborative filtering in BigQuery ML.

The latest_long model suits extended support-call audio, delivering accurate English transcription without any model training. It satisfies the stem's demand for a quick, pre-trained solution, unlike custom models requiring data and tuning. Speech-to-Text handles clear speech directly, so no ML expertise or training pipeline is needed.

Enabling data splitting in CREATE MODEL reserves a portion of the input rows as a held-out test set, and BigQuery ML automatically computes evaluation metrics on it after training, satisfying the requirement to assess model quality without a separate manual step.

Speech-to-Text API converts audio to text accurately, and the Healthcare Natural Language API is specifically designed to extract medical entities like diagnoses and medications from text. This combination uses fully managed pre-trained models, requiring no ML expertise, and directly addresses both transcription and medical term identification in a single pipeline.

BigQuery ML's ARIMA_PLUS is designed for univariate time series forecasting and automatically handles seasonality, holiday effects, and outliers. It requires only SQL, making it ideal for teams with limited ML expertise. It also supports large-scale training across many time series, such as product SKUs, and can incorporate covariates like promotions. This directly meets the company's need for minimal coding and automatic seasonality handling.

The Natural Language API provides pre-trained sentiment analysis, satisfying the minimal-customisation constraint without labelled data or model training. It handles large text volumes through a managed endpoint, unlike custom model approaches that demand dataset preparation and tuning. This makes it the most efficient fit for the stated scenario.