Google Cloud Associate Data Practitioner - Associate-Data-Practitioner Exam Questions [2026]

QUESTION NO: 1
Your organization has several datasets in their data warehouse in BigQuery. Several analyst teams in different departments use the datasets to run queries. Your organization is concerned about the variability of their monthly BigQuery costs. You need to identify a solution that creates a fixed budget for costs associated with the queries run by each department. What should you do?

A. Create a single reservation by using BigQuery editions. Assign all analysts to the reservation. B. Assign each analyst to a separate project associated with their department. Create a single reservation for each department by using BigQuery editions. Create assignments for each project in the appropriate reservation. C. Create a custom quota for each analyst in BigQuery. D. Assign each analyst to a separate project associated with their department. Create a single reservation by using BigQuery editions. Assign all projects to the reservation.

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
You manage a Cloud Storage bucket that stores temporary files created during data processing. These temporary files are only needed for seven days, after which they are no longer needed. To reduce storage costs and keep your bucket organized, you want to automatically delete these files once they are older than seven days. What should you do?

A. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days. B. Develop a batch process using Dataflow that runs weekly and deletes files based on their age. C. Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven days. D. Create a Cloud Run function that runs daily and deletes files older than seven days.

Correct Answer: A

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
You manage a BigQuery table that is used for critical end-of-month reports. The table is updated weekly with new sales data. You want to prevent data loss and reporting issues if the table is accidentally deleted. What should you do?

A. Create a clone of the table. On deletion, re-create the deleted table by copying the content of the clone. B. Configure the time travel duration on the table to be exactly seven days. On deletion, re-create the deleted table solely from the time travel data. C. Create a view of the table. On deletion, re-create the deleted table from the view and time travel data. D. Schedule the creation of a new snapshot of the table once a week. On deletion, re-create the deleted table using the snapshot and time travel data.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
Your company has several retail locations. Your company tracks the total number of sales made at each location each day. You want to use SQL to calculate the weekly moving average of sales by location to identify trends for each store. Which query should you use?

A.

B.

C.

D.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 5
You are a data analyst at your organization. You have been given a BigQuery dataset that includes customer information. The dataset contains inconsistencies and errors, such as missing values, duplicates, and formatting issues. You need to effectively and quickly clean the data. What should you do?

A. Use Cloud Data Fusion to create a data pipeline to read the data from BigQuery, perform data quality transformations, and write the clean data back to BigQuery. B. Use BigQuery's built-in functions to perform data quality transformations. C. Develop a Dataflow pipeline to read the data from BigQuery, perform data quality rules and transformations, and write the cleaned data back to BigQuery. D. Export the data from BigQuery to CSV files. Resolve the errors using a spreadsheet editor, and re- import the cleaned data into BigQuery.

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
You work for a financial organization that stores transaction data in BigQuery. Your organization has a regulatory requirement to retain data for a minimum of seven years for auditing purposes. You need to ensure that the data is retained for seven years using an efficient and cost-optimized approach. What should you do?

A. Set the dataset-level retention policy in BigQuery to seven years. B. Create a partition by transaction date, and set the partition expiration policy to seven years. C. Set the table-level retention policy in BigQuery to seven years. D. Export the BigQuery tables to Cloud Storage daily, and enforce a lifecycle management policy that has a seven-year retention rule.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 7
You are developing a data ingestion pipeline to load small CSV files into BigQuery from Cloud Storage. You want to load these files upon arrival to minimize data latency. You want to accomplish this with minimal cost and maintenance. What should you do?

A. Create a Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery. B. Create a Cloud Run function to load the data into BigQuery that is triggered when data arrives in Cloud Storage. C. Use the bq command-line tool within a Cloud Shell instance to load the data into BigQuery. D. Create a Cloud Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
You need to create a weekly aggregated sales report based on a large volume of data. You want to use Python to design an efficient process for generating this report. What should you do?

A. Create a Cloud Run function that uses NumPy. Use Cloud Scheduler to schedule the function to run once a week. B. Create a Cloud Data Fusion and Wrangler flow. Schedule the flow to run once a week. C. Create a Dataflow directed acyclic graph (DAG) coded in Python. Use Cloud Scheduler to schedule the code to run once a week. D. Create a Colab Enterprise notebook and use the bigframes.pandas library. Schedule the notebook to execute once a week.

Correct Answer: C

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 9
Your company's customer support audio files are stored in a Cloud Storage bucket. You plan to analyze the audio files' metadata and file content within BigQuery to create inference by using BigQuery ML. You need to create a corresponding table in BigQuery that represents the bucket containing the audio files. What should you do?

A. Create a temporary table. B. Create a native table. C. Create an external table. D. Create an object table.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 10
You manage an ecommerce website that has a diverse range of products. You need to forecast future product demand accurately to ensure that your company has sufficient inventory to meet customer needs and avoid stockouts. Your company's historical sales data is stored in a BigQuery table. You need to create a scalable solution that takes into account the seasonality and historical data to predict product demand. What should you do?

A. Use Colab Enterprise to create a Jupyter notebook. Use the historical sales data to train a custom prediction model in Python. B. Use the historical sales data to train and create a BigQuery ML time series model. Use the ML.
FORECAST function call to output the predictions into a new BigQuery table. C. Use the historical sales data to train and create a BigQuery ML logistic regression model. Use the ML.PREDICT function call to output the predictions into a new BigQuery table. D. Use the historical sales data to train and create a BigQuery ML linear regression model. Use the ML.
PREDICT function call to output the predictions into a new BigQuery table.

Correct Answer: B

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).