Palo Alto Networks

Google Associate-Data-Practitioner Exam (page: 1)
Google Cloud Associate Data Practitioner
Updated on: 25-Sep-2025

Access free Associate-Data-Practitioner actual exam questions, answers, explanations and user discussions.

Viewing Page 1 of 16 Pages

Associate-Data-Practitioner PDF with 106 Questions

QUESTION: 1

Your retail company wants to predict customer churn using historical purchase data stored in BigQuery. The dataset includes customer demographics, purchase history, and a label indicating whether the customer churned or not. You want to build a machine learning model to identify customers at risk of churning. You need to create and train a logistic regression model for predicting customer churn, using the customer_data table with the churned column as the target label.
Which BigQuery ML query should you use?

Answer(s): B

Explanation:

In BigQuery ML, when creating a logistic regression model to predict customer churn, the correct query should:

Exclude the target label column (in this case, churned) from the feature columns, as it is used for training and not as a feature input.

Rename the target label column to label, as BigQuery ML requires the target column to be named label.

The chosen query satisfies these requirements:

SELECT * EXCEPT(churned), churned AS label: Excludes churned from features and renames it to label.

The OPTIONS(model_type='logistic_reg') specifies that a logistic regression model is being trained.

This setup ensures the model is correctly trained using the features in the dataset while targeting the churned column for predictions.

Reveal Solution Next Question

QUESTION: 2

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?

Answer(s): C

Explanation:

To calculate the weekly moving average of sales by location:

The query must group by store_id (partitioning the calculation by each store).

The ORDER BY date ensures the sales are evaluated chronologically.

The ROWS BETWEEN 6 PRECEDING AND CURRENT ROW specifies a rolling window of 7 rows (1 week if each row represents daily data).

The AVG(total_sales) computes the average sales over the defined rolling window.

Chosen query meets these requirements:

PARTITION BY store_id groups the calculation by each store.

ORDER BY date orders the rows correctly for the rolling average.

ROWS BETWEEN 6 PRECEDING AND CURRENT ROW ensures the 7-day moving average.

Reveal Solution Next Question

QUESTION: 3

Your company is building a near real-time streaming pipeline to process JSON telemetry data from small appliances. You need to process messages arriving at a Pub/Sub topic, capitalize letters in the serial number field, and write results to BigQuery. You want to use a managed service and write a minimal amount of code for underlying transformations.
What should you do?

Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation query to run every five minutes.
Use a Pub/Sub to Cloud Storage subscription, write a Cloud Run service that is triggered when objects arrive in the bucket, performs the transformations, and writes the results to BigQuery.
Use the "Pub/Sub to BigQuery" Dataflow template with a UDF, and write the results to BigQuery.
Use a Pub/Sub push subscription, write a Cloud Run service that accepts the messages, performs the transformations, and writes the results to BigQuery.

Answer(s): C

Explanation:

Using the "Pub/Sub to BigQuery" Dataflow template with a UDF (User-Defined Function) is the optimal choice because it combines near real-time processing, minimal code for transformations, and scalability. The UDF allows for efficient implementation of custom transformations, such as capitalizing letters in the serial number field, while Dataflow handles the rest of the managed pipeline seamlessly.

Reveal Solution Next Question

QUESTION: 4

You want to process and load a daily sales CSV file stored in Cloud Storage into BigQuery for downstream reporting. You need to quickly build a scalable data pipeline that transforms the data while providing insights into data quality issues.
What should you do?

Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink.
Load the CSV file as a table in BigQuery, and use scheduled queries to run SQL transformation scripts.
Load the CSV file as a table in BigQuery. Create a batch pipeline in Cloud Data Fusion by using a BigQuery source and sink.
Create a batch pipeline in Dataflow by using the Cloud Storage CSV file to BigQuery batch template.

Answer(s): A

Explanation:

Using Cloud Data Fusion to create a batch pipeline with a Cloud Storage source and a BigQuery sink is the best solution because:

Scalability: Cloud Data Fusion is a scalable, fully managed data integration service.

Data transformation: It provides a visual interface to design pipelines, enabling quick transformation of data.

Data quality insights: Cloud Data Fusion includes built-in tools for monitoring and addressing data quality issues during the pipeline creation and execution process.

Reveal Solution Next Question

QUESTION: 5

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?

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

Answer(s): B

Explanation:

Configuring a Cloud Storage lifecycle rule to automatically delete objects older than seven days is the best solution because:

Built-in feature: Cloud Storage lifecycle rules are specifically designed to manage object lifecycles, such as automatically deleting or transitioning objects based on age.

No additional setup: It requires no external services or custom code, reducing complexity and maintenance.

Cost-effective: It directly achieves the goal of deleting files after seven days without incurring additional compute costs.

Reveal Solution Next Question

Viewing Page 1 of 16 Pages

Share your comments for Google Associate-Data-Practitioner exam with other users:

Comments:

Name:

Manasa 12/5/2023 3:15:00 AM

are these really financial cloud questions and answers, seems these are basic admin question and answers

Anonymous

Not Robot 5/14/2023 5:33:00 PM

are these comments real

Anonymous

kriah 9/4/2023 10:44:00 PM

please upload the latest dumps

UNITED STATES

ed 12/17/2023 1:41:00 PM

a company runs its workloads on premises. the company wants to forecast the cost of running a large application on aws. which aws service or tool can the company use to obtain this information? pricing calculator ... the aws pricing calculator is primarily used for estimating future costs

UNITED STATES

Muru 12/29/2023 10:23:00 AM

looks interesting

Anonymous

Tech Lady 10/17/2023 12:36:00 PM

thanks! that’s amazing

Anonymous

Mike 8/20/2023 5:12:00 PM

the exam dumps are helping me get a solid foundation on the practical techniques and practices needed to be successful in the auditing world.

UNITED STATES

Nobody 9/18/2023 6:35:00 PM

q 14 should be dmz sever1 and notepad.exe why does note pad have a 443 connection

Anonymous

Muhammad Rawish Siddiqui 12/4/2023 12:17:00 PM

question # 108, correct answers are business growth and risk reduction.

SAUDI ARABIA

Emmah 7/29/2023 9:59:00 AM

are these valid chfi questions

KENYA

Mort 10/19/2023 7:09:00 PM

question: 162 should be dlp (b)

EUROPEAN UNION

Eknath 10/4/2023 1:21:00 AM

good exam questions

INDIA

Nizam 6/16/2023 7:29:00 AM

I have to say this is really close to real exam. Passed my exam with this.

EUROPEAN UNION

poran 11/20/2023 4:43:00 AM

good analytics question

Anonymous

Antony 11/23/2023 11:36:00 AM

this looks accurate

INDIA

Ethan 8/23/2023 12:52:00 AM

question 46, the answer should be data "virtualization" (not visualization).

Anonymous

nSiva 9/22/2023 5:58:00 AM

its useful.

UNITED STATES

Ranveer 7/26/2023 7:26:00 PM

Pass this exam 3 days ago. The PDF version and the Xengine App is quite useful.

SOUTH AFRICA

Sanjay 8/15/2023 10:22:00 AM

informative for me.

UNITED STATES

Tom 12/12/2023 8:53:00 PM

question 134s answer shoule be "dlp"

JAPAN

Alex 11/7/2023 11:02:00 AM

in 72 the answer must be [sys_user_has_role] table.

Anonymous

Finn 5/4/2023 10:21:00 PM

i appreciated the mix of multiple-choice and short answer questions. i passed my exam this morning.

IRLAND

AJ 7/13/2023 8:33:00 AM

great to find this website, thanks

UNITED ARAB EMIRATES

Curtis Nakawaki 6/29/2023 9:11:00 PM

examination questions seem to be relevant.

UNITED STATES

Umashankar Sharma 10/22/2023 9:39:00 AM

planning to take psm test

Anonymous

ED SHAW 7/31/2023 10:34:00 AM

please allow to download

UNITED STATES

AD 7/22/2023 11:29:00 AM

please provide dumps

UNITED STATES

Ayyjayy 11/6/2023 7:29:00 AM

is the answer to question 15 correct ? i feel like the answer should be b

BAHRAIN

Blessious Phiri 8/12/2023 11:56:00 AM

its getting more technical

Anonymous

Jeanine J 7/11/2023 3:04:00 PM

i think these questions are what i need.

UNITED STATES

Aderonke 10/23/2023 2:13:00 PM

helpful assessment

UNITED KINGDOM

Tom 1/5/2024 2:32:00 AM

i am confused about the answers to the questions. do you know if the answers are correct?

KOREA REPUBLIC OF

Vinit N. 8/28/2023 2:33:00 AM

hi, please make the dumps available for my upcoming examination.

UNITED STATES

Sanyog Deshpande 9/14/2023 7:05:00 AM

good practice

UNITED STATES