📘 Free ASSOCIATE-DATA-PRACTITIONER Sample Questions
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?
A
Correct Answer:
A.
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
Correct Answer:
A.
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?
A
A. Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation
query to run every five minutes.
B
B. 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
C
C. Use the “Pub/Sub to BigQuery” Dataflow template with a UDF, and write the results to BigQuery
D
D. Use a Pub/Sub push subscription, write a Cloud Run service that accepts the messages, performs the
transformations, and writes the results to BigQuery.
Correct Answer:
C. C. Use the “Pub/Sub to BigQuery” Dataflow template with a UDF, and write the results to BigQuery
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?
A
A. Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink
B
B. Load the CSV file as a table in BigQuery, and use scheduled queries to run SQL transformation scripts.
C
C. Load the CSV file as a table in BigQuery. Create a batch pipeline in Cloud Data Fusion by using a BigQuery
source and sink.
D
D. Create a batch pipeline in Dataflow by using the Cloud Storage CSV file to BigQuery batch template.
Correct Answer:
A. A. Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink
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
A. Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven
days.
B
B. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.
C
C. Develop a batch process using Dataflow that runs weekly and deletes files based on their age
D
D. Create a Cloud Run function that runs daily and deletes files older than seven days.
Correct Answer:
B. B. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.
You work for a healthcare company that has a large on-premises data system containing patient records with
personally identifiable information (PII) such as names, addresses, and medical diagnoses. You need a standardized
managed solution that de-identifies PII across all your data feeds prior to ingestion to Google Cloud. What should
you do?
A
A. Use Cloud Run functions to create a serverless data cleaning pipeline. Store the cleaned data in BigQuery.
B
B. Use Cloud Data Fusion to transform the data. Store the cleaned data in BigQuery
C
C. Load the data into BigQuery, and inspect the data by using SQL queries. Use Dataflow to transform the
data and remove any errors.
D
D. Use Apache Beam to read the data and perform the necessary cleaning and transformation operations.
Store the cleaned data in BigQuery.
Correct Answer:
B. B. Use Cloud Data Fusion to transform the data. Store the cleaned data in BigQuery
You manage a large amount of data in Cloud Storage, including raw data, processed data, and backups. Your
organization is subject to strict compliance regulations that mandate data immutability for specific data types. You
want to use an efficient process to reduce storage costs while ensuring that your storage strategy meets retention
requirements. What should you do?
A
A. Configure lifecycle management rules to transition objects to appropriate storage classes based on access
patterns. Set up Object Versioning for all objects to meet immutability requirements
B
B. Move objects to different storage classes based on their age and access patterns. Use Cloud Key
Management Service (Cloud KMS) to encrypt specific objects with customer-managed encryption keys
(CMEK) to meet immutability requirements.
C
C. Create a Cloud Run function to periodically check object metadata, and move objects to the appropriate
storage class based on age and access patterns. Use object holds to enforce immutability for specific objects.
D
D. Use object holds to enforce immutability for specific objects, and configure lifecycle management rules totransition objects to appropriate storage classes based on age and access patterns
Correct Answer:
D. D. Use object holds to enforce immutability for specific objects, and configure lifecycle management rules totransition objects to appropriate storage classes based on age and access patterns
You work for an ecommerce company that has a BigQuery dataset that contains customer purchase history,
demographics, and website interactions. You need to build a machine learning (ML) model to predict which
customers are most likely to make a purchase in the next month. You have limited engineering resources and need
to minimize the ML expertise required for the solution. What should you do?
A
A. Use BigQuery ML to create a logistic regression model for purchase prediction.
B
B. Use Vertex AI Workbench to develop a custom model for purchase prediction.
C
C. Use Colab Enterprise to develop a custom model for purchase prediction.
D
D. Export the data to Cloud Storage, and use AutoML Tables to build a classification model for purchase
prediction
Correct Answer:
A. A. Use BigQuery ML to create a logistic regression model for purchase prediction.
You are designing a pipeline to process data files that arrive in Cloud Storage by 3:00 am each day. Data processing is
performed in stages, where the output of one stage becomes the input of the next. Each stage takes a long time to
run. Occasionally a stage fails, and you have to address the problem. You need to ensure that the final output is
generated as quickly as possible. What should you do?
A
A. Design a Spark program that runs under Dataproc. Code the program to wait for user input when an error
is detected. Rerun the last action after correcting any stage output data errors.
B
B. Design the pipeline as a set of PTransforms in Dataflow. Restart the pipeline after correcting any stage
output data errors.
C
C. Design the workflow as a Cloud Workflow instance. Code the workflow to jump to a given stage based on
an input parameter. Rerun the workflow after correcting any stage output data errors
D
D. Design the processing as a directed acyclic graph (DAG) in Cloud Composer. Clear the state of the failed
task after correcting any stage output data errors
Correct Answer:
D. D. Design the processing as a directed acyclic graph (DAG) in Cloud Composer. Clear the state of the failed
task after correcting any stage output data errors
Another team in your organization is requesting access to a BigQuery dataset. You need to share the dataset with
the team while minimizing the risk of unauthorized copying of data. You also want to create a reusable framework in
case you need to share this data with other teams in the future. What should you do?
A
A. Create authorized views in the team’s Google Cloud project that is only accessible by the team.
B
B. Create a private exchange using Analytics Hub with data egress restriction, and grant access to the team
members.
C
C. Enable domain restricted sharing on the project. Grant the team members the BigQuery Data Viewer IAM
role on the dataset.
D
D. Export the dataset to a Cloud Storage bucket in the team’s Google Cloud project that is only accessible by
the team
Correct Answer:
A. A. Create authorized views in the team’s Google Cloud project that is only accessible by the team.
Questions: 1-10 out of 110
Continue Full Practice..
GET ALL 110 QUESTIONS