20:00

PDF|

Guide for Google Cloud Certified - Associate Data Practitioner

Quiz Google Cloud Certified - Associate Data Practitioner

Free Test
/ 10

Quiz

1/10
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)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 1-3815153287



B)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 2-2399004069

C)
Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 4-1928968648

D)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 3-2464951971
Select the answer
1 correct answer
A.
Option A
B.
Option B
C.
Option C
D.
Option D

Quiz

2/10
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)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 5-4111651232



B)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 6-3861710984

C)
Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 8-2377030141

D)

Certification Exam Google Cloud Certified - Associate Data Practitioner Google Google-Associate-Data-Practitioner 7-485812722
Select the answer
1 correct answer
A.
Option A
B.
Option B
C.
Option C
D.
Option D

Quiz

3/10
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?
Select the answer
1 correct answer
A.
Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation query to run every five minutes.
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.
Use the “Pub/Sub to BigQuery” Dataflow template with a UDF, and write the results to BigQuery.
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.

Quiz

4/10
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?
Select the answer
1 correct answer
A.
Create a batch pipeline in Cloud Data Fusion by using a Cloud Storage source and a BigQuery sink.
B.
Load the CSV file as a table in BigQuery, and use scheduled queries to run SQL transformation scripts.
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.
Create a batch pipeline in Dataflow by using the Cloud Storage CSV file to BigQuery batch template.

Quiz

5/10
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?
Select the answer
1 correct answer
A.
Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven days.
B.
Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.
C.
Develop a batch process using Dataflow that runs weekly and deletes files based on their age.
D.
Create a Cloud Run function that runs daily and deletes files older than seven days.

Quiz

6/10
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?
Select the answer
1 correct answer
A.
Use Cloud Run functions to create a serverless data cleaning pipeline. Store the cleaned data in BigQuery.
B.
Use Cloud Data Fusion to transform the data. Store the cleaned data in BigQuery.
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.
Use Apache Beam to read the data and perform the necessary cleaning and transformation operations. Store the cleaned data in BigQuery.

Quiz

7/10
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?
Select the answer
1 correct answer
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.
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.
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.
Use object holds to enforce immutability for specific objects, and configure lifecycle management rules to transition objects to appropriate storage classes based on age and access patterns.

Quiz

8/10
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?
Select the answer
1 correct answer
A.
Use BigQuery ML to create a logistic regression model for purchase prediction.
B.
Use Vertex AI Workbench to develop a custom model for purchase prediction.
C.
Use Colab Enterprise to develop a custom model for purchase prediction.
D.
Export the data to Cloud Storage, and use AutoML Tables to build a classification model for purchase prediction.

Quiz

9/10
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?
Select the answer
1 correct answer
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.
Design the pipeline as a set of PTransforms in Dataflow. Restart the pipeline after correcting any stage output data errors.
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.
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.

Quiz

10/10
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 dat
a. 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?
Select the answer
1 correct answer
A.
Create authorized views in the team’s Google Cloud project that is only accessible by the team.
B.
Create a private exchange using Analytics Hub with data egress restriction, and grant access to the team members.
C.
Enable domain restricted sharing on the project. Grant the team members the BigQuery Data Viewer IAM role on the dataset.
D.
Export the dataset to a Cloud Storage bucket in the team’s Google Cloud project that is only accessible by the team.
Looking for more questions?Buy now

Google Cloud Certified - Associate Data Practitioner Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Google Cloud Certified - Associate Data Practitioner practice test! Further deepen your knowledge on Google Simulator; by unlocking the full version of our Google Cloud Certified - Associate Data Practitioner Simulator you will be able to take tests with over 72 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 72 questions.

BUY NOW

What to expect from our Google Cloud Certified - Associate Data Practitioner practice tests and how to prepare for any exam?

The Google Cloud Certified - Associate Data Practitioner Simulator Practice Tests are part of the Google Database and are the best way to prepare for any Google Cloud Certified - Associate Data Practitioner exam. The Google Cloud Certified - Associate Data Practitioner practice tests consist of 72 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Google Cloud Certified - Associate Data Practitioner database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Google Cloud Certified - Associate Data Practitioner Simulator will also give you an idea of the time it will take to complete each section of the Google Cloud Certified - Associate Data Practitioner practice test . It is important to note that the Google Cloud Certified - Associate Data Practitioner Simulator does not replace the classic Google Cloud Certified - Associate Data Practitioner study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Google Cloud Certified - Associate Data Practitioner exam.

BUY NOW

Google Cloud Certified - Associate Data Practitioner Practice test therefore represents an excellent tool to prepare for the actual exam together with our Google practice test . Our Google Cloud Certified - Associate Data Practitioner Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Google Cloud Certified - Associate Data Practitioner Simulator and how our unique Google Cloud Certified - Associate Data Practitioner Database made up of real questions:

Info quiz:

  • Quiz name:Google Cloud Certified - Associate Data Practitioner
  • Total number of questions:72
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Google Cloud Certified - Associate Data Practitioner exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Google Cloud Certified - Associate Data Practitioner Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Google Cloud Certified - Associate Data Practitioner Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Google Cloud Certified - Associate Data Practitioner practice tests which consist of 72 questions and also provide study material to pass the final Google Cloud Certified - Associate Data Practitioner exam with guaranteed success. Our Google Cloud Certified - Associate Data Practitioner database contain hundreds of questions and Google Tests related to Google Cloud Certified - Associate Data Practitioner Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW