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 data analyst has a BigQuery table containing thousands of unstructured customer support feedback records. The analyst needs to summarize the text and classify customer sentiment directly within BigQuery using a pretrained Google large language model (LLM), such as Gemini, without moving the data outside the data warehouse.
Which approach should the analyst use to perform this text analysis?
This approach involves extracting data from BigQuery into Cloud Storage, executing an external Python script on a local machine or VM that calls the Gemini API row-by-row, writing the enriched data to disk, and loading the resulting CSV file back into BigQuery using load jobs or the BigQuery Data Transfer Service.
The organization had a requirement to process data strictly on a custom on-premises server or used a proprietary third-party NLP library not available on Google Cloud.
The BigQuery Data Transfer Service (DTS) is a fully managed data ingestion service designed to automate scheduled data transfers from SaaS applications (such as Google Ads, YouTube, Campaign Manager) and cloud storage providers into BigQuery.
The goal was to schedule automated daily data transfers from Google Ads, Campaign Manager, or Amazon Redshift into BigQuery storage.
Dataproc is a fully managed cloud service for running open-source data processing engines such as Apache Spark, Apache Hadoop, and MapReduce. This option provisions a dedicated cluster to read data from BigQuery, run distributed data processing logic, and output results.
The organization had legacy open-source Apache Hadoop/Spark jobs that needed to be migrated as-is to Google Cloud for petabyte-scale batch data processing.
BigQuery AI functions and BigQuery ML allow SQL practitioners to leverage pretrained foundation models—such as Google's Gemini models hosted in Vertex AI—directly inside their data warehouse. By setting up a BigQuery remote connection via the BigQuery Connection API, BigQuery securely authenticates with Vertex AI, enabling users to execute large language model (LLM) inference on tabular and unstructured text data using standard GoogleSQL syntax.
SELECT statements, making AI capabilities accessible to SQL analysts.This approach eliminates the need to build custom ETL pipelines, provision separate compute infrastructure, or write external Python scripts. It delivers immediate, secure text analysis and summarization at scale directly within the analyst's existing SQL environment.
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