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.
Your team is preparing to build a machine learning model to predict customer churn. You have collected raw historical transaction records and uploaded the CSV files into a Google Cloud Storage bucket. You now plan to ingest and organize this structured data into BigQuery for data exploration and machine learning preparation.
What foundational resource must you create in your Google Cloud project before you can load the data into BigQuery tables?
A flat-rate slot commitment (or capacity reservation) is a compute purchasing model where an organization purchases dedicated query processing capacity (slots) rather than paying for queries on an on-demand basis.
The team needed to reserve fixed compute capacity to guarantee consistent query execution time and predictable monthly pricing for large-scale production query workloads.
A BigQuery dataset is a top-level container within a Google Cloud project used to organize, manage, and control access to tables and views. In BigQuery's resource hierarchy, all tables and views must reside within a specific dataset. When defining a dataset, you specify its geographic location (region or multi-region), default table expiration parameters, and access permissions via Identity and Access Management (IAM).
Creating a dataset is the prerequisite architectural step in BigQuery. Without a target dataset, BigQuery cannot provision tables or execute batch load jobs from Cloud Storage files.
A Cloud Translation connection is an external resource connection in BigQuery that links BigQuery to the Cloud Translation API via a managed service account, enabling text translation SQL functions (ML.TRANSLATE).
The scenario required setting up BigQuery to perform automated multi-language text translation on textual columns using remote machine learning models via SQL.
A materialized view is a precomputed view that periodically executes a query and caches the results in BigQuery storage to accelerate analytical query performance and lower query costs on frequently accessed query patterns.
The data was already loaded into base tables, and the data practitioner wanted to improve query performance on complex aggregations by storing precomputed results.
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