Google ADP Exam Prep Guide Prep guide for the ADP Exam [Q21-Q45]

Google ADP Exam Prep Guide: Prep guide for the ADP Exam

2026 New Preparation Guide of Google ADP Exam

NEW QUESTION # 21
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 Archive storage.
• B. Store the data in Cloud Storage using Coldline storage.
• C. Store the data in Cloud Storage using Nearline storage.
• D. Store the data in Cloud Storage using Standard storage.

Answer: C

NEW QUESTION # 22
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. 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.
• D. 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.

Answer: D

NEW QUESTION # 23
Your organization is conducting analysis on regional sales metrics. Data from each regional sales team is stored as separate tables in BigQuery and updated monthly. You need to create a solution that identifies the top three regions with the highest monthly sales for the next three months. You want the solution to automatically provide up-to-date results. What should you do?

• A. Create a BigQuery materialized view that performs a union across all of the regional sales tables. Use the rank() window function to query the new materialized view.
• B. Create a BigQuery table that performs a union across all of the regional sales tables. Use the row_number() window function to query the new table.
• C. Create a BigQuery materialized view that performs a cross join across all of the regional sales tables. Use the row_number() window function to query the new materialized view.
• D. Create a BigQuery table that performs a cross join across all of the regional sales tables. Use the rank() window function to query the new table.

Answer: A

NEW QUESTION # 24
You created a customer support application that sends several forms of data to Google Cloud. Your application is sending:
1. Audio files from phone interactions with support agents that will be accessed during trainings.
2. CSV files of users' personally identifiable information (PII) that will be analyzed with SQL.
3. A large volume of small document files that will power other applications.
You need to select the appropriate tool for each data type given the required use case, while following Google- recommended practices. Which should you choose?

• A. Filestore Cloud SQL for PostgreSQL Datastore
• B. Cloud Storage BigQuery Firestore
• C. Filestore Bigtable BigQuery
• D. Cloud Storage CloudSQL for PostgreSQL Bigtable

Answer: B

NEW QUESTION # 25
Your organization has a BigQuery dataset that contains sensitive employee information such as salaries and performance reviews. The payroll specialist in the HR department needs to have continuous access to aggregated performance data, but they do not need continuous access to other sensitive dat a. You need to grant the payroll specialist access to the performance data without granting them access to the entire dataset using the simplest and most secure approach. What should you do?

• A. Use authorized views to share query results with the payroll specialist.
• B. Create a SQL query with the aggregated performance data. Export the results to an Avro file in a Cloud Storage bucket. Share the bucket with the payroll specialist.
• C. Create a table with the aggregated performance data. Use table-level permissions to grant access to the payroll specialist.
• D. Create row-level and column-level permissions and policies on the table that contains performance data in the dataset. Provide the payroll specialist with the appropriate permission set.

Answer: A

NEW QUESTION # 26
You have created a LookML model and dashboard that shows daily sales metrics for five regional managers to use. You want to ensure that the regional managers can only see sales metrics specific to their region. You need an easy-to-implement solution. What should you do?

• A. Create separate Looker dashboards for each regional manager. Set the default dashboard filter to the corresponding region for each manager.
• B. Create five different Explores with thesql_always_filterExplore filter applied on theregion_namedimension. Set eachregion_namevalue to the corresponding region for each manager.
• C. Add anaccess_filterExplore filter on theregion_namedimension by using thesales_regionuser attribute.
• D. Create asales_regionuser attribute, and assign each manager's region as the value of their user attribute.

Answer: D

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

Answer: D

NEW QUESTION # 28
Your company currently uses an on-premises network file system (NFS) and is migrating data to Google Cloud. You want to be able to control how much bandwidth is used by the data migration while capturing detailed reporting on the migration status. What should you do?

• A. Use a Transfer Appliance.
• B. Use Storage Transfer Service.
• C. Use gcloud storage commands.
• D. Use Cloud Storage FUSE.

Answer: B

NEW QUESTION # 29
You are working with a large dataset of customer reviews stored in Cloud Storage. The dataset contains several inconsistencies, such as missing values, incorrect data types, and duplicate entries. You need toclean the data to ensure that it is accurate and consistent before using it for analysis. What should you do?

• A. Use the PythonOperator in Cloud Composer to clean the data and load it into BigQuery. Use SQL for analysis.
• B. Use BigQuery to batch load the data into BigQuery. Use SQL for cleaning and analysis.
• C. Use Storage Transfer Service to move the data to a different Cloud Storage bucket. Use event triggers to invoke Cloud Run functions to load the data into BigQuery. Use SQL for analysis.
• D. Use Cloud Run functions to clean the data and load it into BigQuery. Use SQL for analysis.

Answer: B

NEW QUESTION # 30
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. 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.
• B. Copy the storm event dataset into your BigQuery project. Use BigQuery Studio to query and visualize the data in Looker Studio.
• C. 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.
• D. 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.

Answer: B

NEW QUESTION # 31
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. 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.
• B. 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.
• C. 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.
• D. 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.

Answer: B

NEW QUESTION # 32
Your organization uses scheduled queries to perform transformations on data stored in BigQuery. You discover that one of your scheduled queries has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

• A. Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.
• B. Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.
• C. Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.
• D. Set up a log sink using the gcloud CLI to export BigQuery audit logs to BigQuery. Query those logs to identify the error associated with the failed job I

Answer: B

NEW QUESTION # 33
You need to create a data pipeline that streams event information from applications in multiple Google Cloud regions into BigQuery for near real-time analysis. The data requires transformation before loading. You want to create the pipeline using a visual interface. What should you do?

• A. Push event information to a Pub/Sub topic. Create a Dataflow job using the Dataflow job builder.
• B. Push event information to Cloud Storage, and create an external table in BigQuery. Create a BigQuery scheduled job that executes once each day to apply transformations.
• C. Push event information to a Pub/Sub topic. Create a Cloud Run function to subscribe to the Pub/Sub topic, apply transformations, and insert the data into BigQuery.
• D. Push event information to a Pub/Sub topic. Create a BigQuery subscription in Pub/Sub.

Answer: A

NEW QUESTION # 34
Your organization has decided to migrate their existing enterprise data warehouse to BigQuery. The existing data pipeline tools already support connectors to BigQuery. You need to identify a data migration approach that optimizes migration speed. What should you do?

• A. Create a temporary file system to facilitate data transfer from the existing environment to Cloud Storage. Use Storage Transfer Service to migrate the data into BigQuery.
• B. Use the Cloud Data Fusion web interface to build data pipelines. Create a directed acyclic graph (DAG) that facilitates pipeline orchestration.
• C. Use the existing data pipeline tool's BigQuery connector to reconfigure the data mapping.
• D. Use the BigQuery Data Transfer Service to recreate the data pipeline and migrate the data into BigQuery.

Answer: C

NEW QUESTION # 35
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. CREATE OR REPLACE MODEL churn_prediction_model options(model_type='logistic_reg*) as select ' except(churned) FROM customer data;
• B. CREATE OR REPLACE MODEL churn_prediction_model OPTIONS (rr.odel_type=' logisric_reg *) AS select * except(churned), churned AS label FROM customer_data;
• C. CREATE OR REPLACE MODEL churn_prediction_model OPTIONS(model_uype='logisric_reg') AS SELECT * from cusromer_data;
• D. CREATE OR REPLACE MODEL churn_prediction_model options (model type='logistic_reg') AS select churned as label FROM customer_data;

Answer: B

NEW QUESTION # 36
You have a BigQuery dataset containing sales dat
a. This data is actively queried for the first 6 months. After that, the data is not queried but needs to be retained for 3 years for compliance reasons. You need to implement a data management strategy that meets access and compliance requirements, while keeping cost and administrative overhead to a minimum. What should you do?

• A. Partition a BigQuery table by month. After 6 months, export the data to Coldline storage. Implement a lifecycle policy to delete the data from Cloud Storage after 3 years.
• B. Store all data in a single BigQuery table without partitioning or lifecycle policies.
• C. Use BigQuery long-term storage for the entire dataset. Set up a Cloud Run function to delete the data from BigQuery after 3 years.
• D. Set up a scheduled query to export the data to Cloud Storage after 6 months. Write a stored procedure to delete the data from BigQuery after 3 years.

Answer: A

NEW QUESTION # 37
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 Composer to orchestrate 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 Run functions to trigger the Spark job and email the report.

Answer: C

NEW QUESTION # 38
You used BigQuery ML to build a customer purchase propensity model six months ago. You want to compare the current serving data with the historical serving data to determine whether you need to retrain the model.
What should you do?

• A. Compare the confusion matrix.
• B. Evaluate the data skewness.
• C. Evaluate data drift.
• D. Compare the two different models.

Answer: C

NEW QUESTION # 39
Your company is migrating their batch transformation pipelines to Google Cloud. You need to choose a solution that supports programmatic transformations using only SQL. You also want the technology to support Git integration for version control of your pipelines. What should you do?

• A. Use Dataflow pipelines.
• B. Use Cloud Data Fusion pipelines.
• C. Use Dataform workflows.
• D. Use Cloud Composer operators.

Answer: C

NEW QUESTION # 40
Your organization plans to move their on-premises environment to Google Cloud. Your organization's network bandwidth is less than 1 Gbps. You need to move over 500 ## of data to Cloud Storage securely, and only have a few days to move the dat a. What should you do?

• A. Request multiple Transfer Appliances, copy the data to the appliances, and ship the appliances back to Google Cloud to upload the data to Cloud Storage.
• B. Connect to Google Cloud using VPN. Use the gcloud storage command to move the data to Cloud Storage.
• C. Connect to Google Cloud using VPN. Use Storage Transfer Service to move the data to Cloud Storage.
• D. Connect to Google Cloud using Dedicated Interconnect. Use the gcloud storage command to move the data to Cloud Storage.

Answer: A

NEW QUESTION # 41
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. Develop a batch process using Dataflow that runs weekly and deletes files based on their age.
• B. Create a Cloud Run function that runs daily and deletes files older than seven days.
• C. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.
• D. Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven days.

Answer: C

NEW QUESTION # 42
Your organization has several datasets in their data warehouse in BigQuery. Several analyst teams in different departments use the datasets to run queries. Your organization is concerned about the variability of their monthly BigQuery costs. You need to identify a solution that creates a fixed budget for costs associated with the queries run by each department. What should you do?

• A. Create a custom quota for each analyst in BigQuery.
• B. Create a single reservation by using BigQuery editions. Assign all analysts to the reservation.
• C. Assign each analyst to a separate project associated with their department. Create a single reservation for each department by using BigQuery editions. Create assignments for each project in the appropriate reservation.
• D. Assign each analyst to a separate project associated with their department. Create a single reservation by using BigQuery editions. Assign all projects to the reservation.

Answer: C

NEW QUESTION # 43
Your organization uses Dataflow pipelines to process real-time financial transactions. You discover that one of your Dataflow jobs has failed. You need to troubleshoot the issue as quickly as possible. What should you do?

• A. Create a custom script to periodically poll the Dataflow API for job status updates, and send email alerts if any errors are identified.
• B. Use the gcloud CLI tool to retrieve job metrics and logs, and analyze them for errors and performance bottlenecks.
• C. Navigate to the Dataflow Jobs page in the Google Cloud console. Use the job logs and worker logs to identify the error.
• D. Set up a Cloud Monitoring dashboard to track key Dataflow metrics, such as data throughput, error rates, and resource utilization.

Answer: C

NEW QUESTION # 44
You created a curated dataset of market trends in BigQuery that you want to share with multiple external partners. You want to control the rows and columns that each partner has access to. You want to follow Google-recommended practices. What should you do?

• A. Grant each partner read access to the BigQuery dataset by using 1AM roles.
• B. Create a separate Cloud Storage bucket for each partner. Export the dataset to each bucket and assign each partner to their respective bucket. Grant bucket-level access by using 1AM roles.
• C. Create a separate project for each partner and copy the dataset into each project. Publish each dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.
• D. Publish the dataset in Analytics Hub. Grant dataset-level access to each partner by using subscriptions.

Answer: D

NEW QUESTION # 45
......

Latest Questions ADP Guide to Prepare Free Practice Tests: https://testoutce.pass4leader.com/Google/ADP-exam.html