Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A retail company stores several terabytes of structured transaction data in BigQuery tables. The data analytics team needs to train and evaluate a binary classification model to predict customer churn.
The team wants to implement this solution using their existing standard SQL skills, without exporting or moving the data outside the data warehouse.
Which solution should the team use?
Dataform is a Google Cloud service designed to develop, test, version control, and orchestrate complex SQL workflows for data transformation and ELT (Extract, Load, Transform) data integration processes within BigQuery.
The scenario required building a version-controlled, multi-step SQL transformation pipeline with data quality assertions to prepare and clean raw transactional data before machine learning ingestion.
Dataproc is a managed service for running open-source distributed processing platforms such as Apache Spark and Hadoop. Spark MLlib is Spark's scalable machine learning library used for distributed data processing and model training.
The team had existing legacy Apache Spark MLlib codebases written in Scala or Python that needed to be migrated to Google Cloud with minimal code modifications.
BigQuery ML is a Google Cloud service that enables data analysts and practitioners to build, train, evaluate, and operationalize machine learning models directly inside BigQuery using standard SQL queries. It eliminates the necessity of exporting large volumes of data to separate machine learning environments.
CREATE MODEL statement and ML.EVALUATE function) rather than requiring Python, R, or dedicated ML frameworks.ML.EVALUATE and ML.PREDICT to assess model metrics and generate batch predictions directly in SQL workflows.BigQuery ML is designed precisely for scenarios where structured data resides in BigQuery and teams wish to leverage SQL for end-to-end model creation, evaluation, and prediction without managing external compute clusters or export pipelines.
This approach involves exporting tabular data from BigQuery into Cloud Storage files (such as CSV or Parquet) and setting up a self-managed Compute Engine virtual machine to train a custom TensorFlow model via Python scripts.
The scenario required developing highly customized, proprietary neural network architectures with custom low-level loss functions and training loops that cannot be defined through SQL or managed AutoML interfaces.
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