ASSOCIATE-DATA-PRACTITIONER practice question 25 of 25
You work for an ecommerce company that has a BigQuery dataset that contains customer purchase history, demographics, and website interactions. You need to build a machine learning (ML) model to predict which customers are most likely to make a purchase in the next month. You have limited engineering resources and need to minimize the ML expertise required for the solution. What should you do?
Full set: 106 questionsBigQuery ML is designed specifically for this scenario. It enables users to build and train machine learning models, including logistic regression for classification tasks, directly on data within BigQuery using standard SQL syntax. This approach minimizes data movement and leverages existing SQL skills, perfectly aligning with the requirements to use limited engineering resources and minimize the need for specialized ML expertise. The entire workflow from data preparation to prediction can be managed within BigQuery.
B. Vertex AI Workbench is a notebook-based environment for data scientists and requires significant coding and ML expertise, which contradicts the user's constraints.
C. Colab Enterprise is also a notebook-based environment requiring custom code and ML expertise, making it unsuitable for a team with limited resources in this area.
D. While AutoML Tables is a low-code solution, this option requires an unnecessary data export step from BigQuery to Cloud Storage, adding complexity and engineering overhead.
1. Google Cloud Documentation, "Introduction to BigQuery ML". It states, "BigQuery ML lets you create and execute machine learning models in BigQuery by using standard SQL queries. BigQuery ML democratizes machine learning by letting SQL practitioners build models using their existing tools and skills."
2. Google Cloud Documentation, "The CREATE MODEL statement for logistic regression models". This page provides the exact SQL syntax for creating a logistic regression model, demonstrating the simplicity and SQL-native approach of BigQuery ML for this type of prediction task.
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 4You are predicting customer churn for a subscription-based service. You have a 50 PB hist…
- 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…
