Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Professional Cloud Architect practice bank has 2,335 more like it. Try 10 free: instant score, no account.
An e-commerce enterprise stores petabytes of structured transaction history and customer support text transcripts in BigQuery. The organization wants to improve its existing business logic by adding predictive customer churn models and automated sentiment analysis on support logs.
The engineering team has established SQL expertise but limited experience managing custom machine learning infrastructure or Python-based deployment frameworks. They need a managed solution that avoids extensive data movement and allows them to build tabular predictive models and leverage advanced foundation models for natural language tasks directly.
Which architecture should you recommend?
Cloud SQL ML integration allows relational transactional databases (such as Cloud SQL for MySQL or PostgreSQL) to invoke Vertex AI models directly using SQL functions within transactional queries.
The application needed low-latency, transactional online predictions during active database writes in an existing transactional OLTP workload.
Dataproc is a managed Apache Spark and Apache Hadoop service that enables large-scale distributed data processing and machine learning through Spark MLlib, accessing data via the BigQuery Storage API.
The enterprise had existing legacy Apache Spark ML pipelines that they intended to lift and shift onto Google Cloud without re-architecting to SQL.
This approach involves extracting raw data from BigQuery into Cloud Storage and orchestrating distributed training jobs using custom Docker containers across a Google Kubernetes Engine (GKE) cluster.
The team required proprietary, low-level deep learning frameworks with complex distributed GPU topologies not supported by managed Google Cloud AI services.
BigQuery ML is a managed capability within BigQuery that allows data analysts and engineers to build, train, evaluate, and operationalize machine learning models using standard GoogleSQL syntax. By integrating remote models with Vertex AI, BigQuery ML extends SQL workflows to invoke managed foundation models (such as Gemini) directly on data stored in BigQuery tables.
ML.GENERATE_TEXT using familiar SQL syntax without learning specialized Python ML frameworks.This approach provides the lowest operational complexity and fastest time-to-value. It directly empowers SQL-focused teams to enrich business logic with predictive intelligence while maintaining complete data governance inside BigQuery.
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