Free ADP Questions for Google ADP Exam

Question #1

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 Colab Enterprise notebook and use the bigframes.pandas library. Schedule the notebook to execute once a week.

C. Create a Cloud Data Fusion and Wrangler flow. Schedule the flow to run once a week.

D. Create a Dataflow directed acyclic graph (DAG) coded in Python. Use Cloud Scheduler to schedule the code to run once a week.

Discussion 0

Correct Answer: D Vote an answer

Question #2

You work for a healthcare company. You have a daily ETL pipeline that extracts patient data from a legacy system, transforms it, and loads it into BigQuery for analysis. The pipeline currently runs manually using a shell script. You want to automate this process and add monitoring to ensure pipeline observability and troubleshooting insights. You want one centralized solution, using open-source tooling, without rewriting the ETL code. What should you do?

A. Configure Cloud Dataflow to implement the ETL pipeline, and use Cloud Scheduler to trigger the Dataflow pipeline daily. Monitor the pipelines execution using the Dataflow job monitoring interface and Cloud Monitoring.

B. Create a Cloud Run function that runs the pipeline daily. Monitor the functions execution using Cloud Monitoring.

C. Create a direct acyclic graph (DAG) in Cloud Composer to orchestrate a pipeline trigger daily. Monitor the pipeline's execution using the Apache Airflow web interface and Cloud Monitoring.

D. Use Cloud Scheduler to trigger a Dataproc job to execute the pipeline daily. Monitor the job's progress using the Dataproc job web interface and Cloud Monitoring.

Discussion 0

Correct Answer: C Vote an answer

Question #3

You are designing a BigQuery data warehouse with a team of experienced SQL developers. You need to recommend a cost- effective, fully-managed, serverless solution to build ELT processes with SQL pipelines.
Your solution must include source code control, environment parameterization, and data quality checks. What should you do?

A. Use Cloud Data Fusion to visually design and manage the pipelines.

B. Use Cloud Composer to orchestrate and run data workflows.

C. Use Dataproc to run MapReduce jobs for distributed data processing.

D. Use Dataform to build, orchestrate, and monitor the pipelines.

Discussion 0

Correct Answer: D Vote an answer

Question #4

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. Export the data to Cloud Storage, and use AutoML Tables to build a classification model for purchase prediction.

B. Use BigQuery ML to create a logistic regression model for purchase prediction.

C. Use Colab Enterprise to develop a custom model for purchase prediction.

D. Use Vertex Al Workbench to develop a custom model for purchase prediction.

Discussion 0

Correct Answer: B Vote an answer

Question #5

You have a Dataproc cluster that performs batch processing on data stored in Cloud Storage. You need to schedule a daily Spark job to generate a report that will be emailed to stakeholders. You need a fully-managed solution that is easy to implement and minimizes complexity. What should you do?

A. Use Cloud Run functions to trigger the Spark job and email the report.

B. Use Cloud Scheduler to trigger the Spark job. and use Cloud Run functions to email the report.

C. Use Dataproc workflow templates to define and schedule the Spark job, and to email the report.

D. Use Cloud Composer to orchestrate the Spark job and email the report.

Discussion 0

Correct Answer: C Vote an answer

Question #6

You work for a home insurance company. You are frequently asked to create and save risk reports with charts for specific areas using a publicly available storm event dataset. You want to be able to quickly create and re- run risk reports when new data becomes available. What should you do?

A. Copy the storm event dataset into your BigQuery project. Use BigQuery Studio to query and visualize the data in Looker Studio.

B. Reference and query the storm event dataset using SQL in a Colab Enterprise notebook. Display the table results and document with Markdown, and use Matplotlib to create charts.

C. Reference and query the storm event dataset using SQL in BigQuery Studio. Export the results to Google Sheets, and use cell data in the worksheets to create charts.

D. Export the storm event dataset as a CSV file. Import the file to Google Sheets, and use cell data in the worksheets to create charts.

Discussion 0

Correct Answer: A Vote an answer

Question #7

Your company uses Looker to visualize and analyze sales dat
a. You need to create a dashboard that displays sales metrics, such as sales by region, product category, and time period. Each metric relies on its own set of attributes distributed across several tables. You need to provide users the ability to filter the data by specific sales representatives and view individual transactions. You want to follow the Google-recommended approach. What should you do?

A. Create a single Explore with all sales metrics. Build the dashboard using this Explore.

B. Use BigQuery to create multiple materialized views, each focusing on a specific sales metric. Build the dashboard using these views.

C. Create multiple Explores, each focusing on each sales metric. Link the Explores together in a dashboard using drill-down functionality.

D. Use Looker's custom visualization capabilities to create a single visualization that displays all the sales metrics with filtering and drill-down functionality.

Discussion 0

Correct Answer: A Vote an answer

Free ADP Questions for Google Associate Data Practitioner ADP Exam as PDF & Practice Test Engine

Download Free Google ADP Demo