Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An enterprise analytics team needs to enrich several terabytes of unstructured customer feedback records already stored in BigQuery standard tables. The team wants to leverage a Gemini foundation model hosted on Vertex AI to perform sentiment summarization and structured entity extraction.
The solution must satisfy the following criteria:
Which architecture should the data engineering team implement?
BigQuery ML remote models enable BigQuery to orchestrate machine learning inference using models deployed to or hosted in Vertex AI, including foundation models like Gemini. By establishing a secure Cloud resource connection, BigQuery delegates the model execution to Vertex AI while managing query execution and output ingestion automatically.
ML.GENERATE_TEXT function directly against standard BigQuery tables, passing table columns as prompts or structured inputs.Executing inference directly inside the data warehouse via BigQuery ML remote models provides the lowest operational complexity and the highest developer productivity for analytical batch workloads. Compared to extracting data or deploying inline pipeline predictors, it avoids unnecessary data duplication and infrastructure overhead.
Inline pipeline inference involves processing data through a stream processing engine like Dataflow, which makes real-time Remote Procedure Calls (RPCs) or REST API requests to an active Vertex AI online prediction endpoint before persisting records into storage.
The workload required real-time event stream enrichment with sub-second latency requirements prior to data ingestion into the warehouse.
Online prediction endpoints are best suited for interactive application serving, whereas data warehouse enrichment benefits from asynchronous, batched execution.
BigQuery ML allows users to train tabular and time-series models using SQL and register specific models into the Vertex AI Model Registry to unify governance and model lifecycle management across Google Cloud.
The objective was to build and evaluate a lightweight gradient-boosted classification model on structured tabular features entirely within BigQuery.
Remote models in BigQuery ML cannot be registered in the Vertex AI Model Registry, but they natively bridge analytical queries directly to Vertex AI foundation endpoints.
Vertex AI Batch Prediction is an asynchronous processing service that reads input files from Cloud Storage or BigQuery tables, distributes the inference workload across dedicated compute nodes, and outputs predictions to Cloud Storage or a new BigQuery table.
The organization were executing custom deep learning model artifacts stored in container registries requiring specialized GPU topologies not supported directly by BigQuery remote model functions.
BigQuery ML remote models provide direct integration with Vertex AI under the hood, making manual batch export and import loops obsolete for standard foundation model enrichment.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated