ASSOCIATE-DATA-PRACTITIONER practice question 4 of 25
You are predicting customer churn for a subscription-based service. You have a 50 PB historical customer dataset in BigQuery that includes demographics, subscription information, and engagement metrics. You want to build a churn prediction model with minimal overhead. You want to follow the Google-recommended approach. What should you do?
Full set: 106 questionsBigQuery ML (BQML) is the Google-recommended approach for building machine learning models on large-scale data stored in BigQuery with minimal overhead. The CREATE MODEL statement allows you to train models directly within BigQuery using SQL, eliminating the need to export data or manage separate compute infrastructure. This serverless approach is highly scalable and cost-effective for petabyte-scale datasets. Using the Python client library in a notebook is a common and efficient way to orchestrate these BQML queries and preprocessing steps.
A. Exporting 50 PB of data to a local machine is technically infeasible and impractical due to its massive size.
B. Using Dataproc requires managing a separate Spark cluster, which adds operational overhead and complexity compared to the serverless BQML approach.
C. Looker is a business intelligence and visualization tool; its LookML modeling layer is for defining metrics, not for training predictive machine learning models.
1. Google Cloud. (n.d.). Introduction to BigQuery ML. Google Cloud Documentation. Retrieved from https://cloud.google.com/bigquery/docs/bqml-introduction. (See "Why use BigQuery ML" section, which highlights benefits like no data movement and no need for a separate ML cluster).
2. Google Cloud. (n.d.). The CREATE MODEL statement. Google Cloud Documentation. Retrieved from https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create. (This page details the core SQL statement for training models directly in BigQuery).
Keep practicing
Take the free ASSOCIATE-DATA-PRACTITIONER practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ASSOCIATE-DATA-PRACTITIONER practice questions
- Question 1You are designing a pipeline to process data files that arrive in Cloud Storage by 3:00 a…
- Question 2Your organization plans to move their on-premises environment to Google Cloud. Your organ…
- Question 3You are responsible for managing Cloud Storage buckets for a research company. Your compa…
- Question 5Your retail company collects customer data from various sources:Online transactions: Stor…
- Question 6Your company has developed a website that allows users to upload and share video files. T…
- Question 8Another team in your organization is requesting access to a BigQuery dataset. You need to…
