ADP Exam Training Practice Tests (Google Associate Data Practitioner)]

Question 1

Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your organization's storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

A. Create a view that filters out rows that are older than one year. B. Set the table partition expiration period to one year using the ALTER TABLE statement in SQL. C. Require users to specify a partition filter using the alter table statement in SQL. D. Create a scheduled query that periodically runs an update statement in SQL that sets the "deleted" column to "yes" for data that is more than one year old. Create a view that filters out rows that have been marked deleted.

Correct Answer: B

Question 2

You need to design a data pipeline that ingests data from CSV, Avro, and Parquet files into Cloud Storage.
The data includes raw user input. You need to remove all malicious SQL injections before storing the data in BigQuery. Which data manipulation methodology should you choose?

A. ELT B. EL C. ETLT D. ETL

Correct Answer: D

Question 3

Your organization has decided to move their on-premises Apache Spark-based workload to Google Cloud.
You want to be able to manage the code without needing to provision and manage your own cluster. What should you do?

A. Migrate the Spark jobs to Dataproc Serverless. B. Migrate the Spark jobs to Dataproc on Compute Engine. C. Configure a Google Kubernetes Engine cluster with Spark operators, and deploy the Spark jobs. D. Migrate the Spark jobs to Dataproc on Google Kubernetes Engine.

Correct Answer: A

Question 4

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. Use a Pub/Sub to BigQuery subscription, write results directly to BigQuery, and schedule a transformation query to run every five minutes. B. Use the "Pub/Sub to BigQuery" Dataflow template with a UDF, and write the results to BigQuery. C. Use a Pub/Sub push subscription, write a Cloud Run service that accepts the messages, performs the transformations, and writes the results to BigQuery. D. 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.

Correct Answer: B

Question 5

You have a Dataflow pipeline that processes website traffic logs stored in Cloud Storage and writes the processed data to BigQuery. You noticed that the pipeline is failing intermittently. You need to troubleshoot the issue. What should you do?

A. Use Cloud Logging to create a chart displaying the pipeline's error logs. Use Metrics Explorer to validate the findings from the chart. B. Use Cloud Logging to view error messages in the pipeline's logs. Use Cloud Monitoring to analyze the pipeline's metrics, such as CPU utilization and memory usage. C. Use Cloud Logging to identify error groups in the pipeline's logs. Use Cloud Monitoring to create a dashboard that tracks the number of errors in each group. D. Use the Dataflow job monitoring interface to check the pipeline's status every hour. Use Cloud Profiler to analyze the pipeline's metrics, such as CPU utilization and memory usage.

Correct Answer: B

Question 6

You manage data at an ecommerce company. You have a Dataflow pipeline that processes order data from Pub/Sub, enriches the data with product information from Bigtable, and writes the processed data to BigQuery for analysis. The pipeline runs continuously and processes thousands of orders every minute. You need to monitor the pipeline's performance and be alerted if errors occur. What should you do?

A. Use Cloud Monitoring to track key metrics. Create alerting policies in Cloud Monitoring to trigger notifications when metrics exceed thresholds or when errors occur. B. Use the Dataflow job monitoring interface to visually inspect the pipeline graph, check for errors, and configure notifications when critical errors occur. C. Use Cloud Logging to view the pipeline logs and check for errors. Set up alerts based on specific keywords in the logs. D. Use BigQuery to analyze the processed data in Cloud Storage and identify anomalies or inconsistencies. Set up scheduled alerts based when anomalies or inconsistencies occur.

Correct Answer: A

Question 7

Your organization needs to store historical customer order dat
a. The data will only be accessed once a month for analysis and must be readily available within a few seconds when it is accessed. You need to choose a storage class that minimizes storage costs while ensuring that the data can be retrieved quickly. What should you do?

A. Store the data in Cloud Storage using Nearline storage. B. Store the data in Cloud Storage using Archive storage. C. Store the data in Cloud Storage using Standard storage. D. Store the data in Cloud Storage using Coldline storage.

Correct Answer: A

Google Associate Data Practitioner - ADP Exam Practice Test