Google Cloud Digital Leader Practice Exam

Which Google Cloud service allows you to create and execute machine learning models using SQL queries?

1. BigQuery ML

2. AI Platform

3. Dataflow

4. Dataproc

The correct answer is: BigQuery ML

BigQuery ML is designed specifically to enable users to create and execute machine learning models directly using SQL queries within the BigQuery environment. This service allows data analysts and other professionals who may not have extensive machine learning expertise to leverage their SQL skills to build and train ML models on large datasets. With BigQuery ML, users can run various types of machine learning models (like linear regression, logistic regression, and more) without needing to extract the data or switch to a different platform for model training. This integration streamlines the machine learning workflow, making it more accessible and efficient for those who are already familiar with SQL. While the other services listed—AI Platform, Dataflow, and Dataproc—do have roles in the machine learning ecosystem on Google Cloud, they each have a different focus. AI Platform is more catered to deploying and managing machine learning models at scale, Dataflow is primarily for data processing and stream analytics, and Dataproc is geared towards managing Apache Hadoop and Apache Spark clusters. None of these services allow for the creation of models using SQL in the straightforward and user-friendly manner that BigQuery ML provides.