Google ADP Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Data Pipeline Orchestration | 18% | - Pipeline automation and scheduling
|
| Data Analysis and Presentation | 27% | - Data visualization and reporting
|
| Data Preparation and Ingestion | 30% | - Storage solutions selection
|
| Data Management and Governance | 25% | - Data quality and maintenance
|
Google Associate Data Practitioner Sample Questions:
Question #1
Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company's products in your Looker Explores and dashboards.
You need to implement a solution quickly and efficiently. What should you do?
A. Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
B. Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
C. Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
D. Apply a filter to only show products with a positive profit margin.
Question #2
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. Create a Cloud Run function that runs daily and deletes files older than seven days.
B. Set up a Cloud Scheduler job that invokes a weekly Cloud Run function to delete files older than seven days.
C. Configure a Cloud Storage lifecycle rule that automatically deletes objects older than seven days.
D. Develop a batch process using Dataflow that runs weekly and deletes files based on their age.
Question #3
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. Request access from your admin to the BigQuery information_schema. Query the jobs view with the failed job ID, and analyze error details.
B. Navigate to the Scheduled queries page in the Google Cloud console. Select the failed job, and analyze the error details.
C. 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
D. Navigate to the Logs Explorer page in Cloud Logging. Use filters to find the failed job, and analyze the error details.
Question #4
Your company's customer support audio files are stored in a Cloud Storage bucket. You plan to analyze the audio files' metadata and file content within BigQuery to create inference by using BigQuery ML. You need to create a corresponding table in BigQuery that represents the bucket containing the audio files. What should you do?
A. Create an external table.
B. Create a temporary table.
C. Create a native table.
D. Create an object table.
Question #5
You are developing a data ingestion pipeline to load small CSV files into BigQuery from Cloud Storage. You want to load these files upon arrival to minimize data latency. You want to accomplish this with minimal cost and maintenance. What should you do?
A. Use the bq command-line tool within a Cloud Shell instance to load the data into BigQuery.
B. Create a Dataproc cluster to pull CSV files from Cloud Storage, process them using Spark, and write the results to BigQuery.
C. Create a Cloud Run function to load the data into BigQuery that is triggered when data arrives in Cloud Storage.
D. Create a Cloud Composer pipeline to load new files from Cloud Storage to BigQuery and schedule it to run every 10 minutes.
Solutions:
| Question #1 Correct Answer: A | Question #2 Correct Answer: C | Question #3 Correct Answer: B | Question #4 Correct Answer: D | Question #5 Correct Answer: C |














802 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
