We're so confident of our products that we provide no hassle product exchange.
Google ADP Exam Overview:
| Certification Vendor: | |
|---|---|
| Exam Name: | Google Cloud Associate Data Practitioner |
| Exam Number: | GCP-ADP |
| Related Certifications: | Google Cloud Professional Data Engineer Google Cloud Professional Data Analyst |
| Passing Score: | 70% |
| Exam Price: | $125 USD |
| Exam Format: | Multiple choice, Multiple select |
| Exam Duration: | 120 minutes |
| Available Languages: | English, Japanese |
| Certificate Validity Period: | 2 years |
| Real Exam Qty: | 50-60 |
| Recommended Training: | Google Cloud Associate Data Practitioner Learning Path Introduction to Data Engineering on Google Cloud |
| Exam Registration: | Google Cloud Certification Registration |
| Sample Questions: | Google ADP Sample Questions |
| Exam Way: | Online proctored (remote) or onsite proctored at authorized test centers |
| Pre Condition: | No mandatory prerequisites; recommended 6+ months hands-on experience working with data on Google Cloud |
| Official Syllabus URL: | https://cloud.google.com/learn/certification/data-practitioner |
Google ADP Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Data Management and Governance | 25% | - Data quality and maintenance
|
| Topic 2: Data Analysis and Presentation | 27% | - Data visualization and reporting
|
| Topic 3: Data Preparation and Ingestion | 30% | - Data formats and classification
|
| Topic 4: Data Pipeline Orchestration | 18% | - Data transformation concepts
|
Google Associate Data Practitioner Sample Questions:
You are migrating data from a legacy on-premises MySQL database to Google Cloud. The database contains various tables with different data types and sizes, including large tables with millions of rows and transactional dat a. You need to migrate this data while maintaining data integrity, and minimizing downtime and cost. What should you do?
- A. Use Cloud Data Fusion to migrate the MySQL database to MySQL on Compute Engine.
- B. Export the MySQL database to CSV files, transfer the files to Cloud Storage by using Storage Transfer Service, and load the files into a Cloud SQL for MySQL instance.
- C. Use Database Migration Service to replicate the MySQL database to a Cloud SQL for MySQL instance.
- D. Set up a Cloud Composer environment to orchestrate a custom data pipeline. Use a Python script to extract data from the MySQL database and load it to MySQL on Compute Engine.
Correct Answer: C 🗳️
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 Dataform to build, orchestrate, and monitor the pipelines.
- B. Use Cloud Data Fusion to visually design and manage the pipelines.
- C. Use Cloud Composer to orchestrate and run data workflows.
- D. Use Dataproc to run MapReduce jobs for distributed data processing.
Correct Answer: A 🗳️
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 Colab Enterprise notebook and use the bigframes.pandas library. Schedule the notebook to execute once a week.
- B. Create a Dataflow directed acyclic graph (DAG) coded in Python. Use Cloud Scheduler to schedule the code to run once a week.
- C. Create a Cloud Data Fusion and Wrangler flow. Schedule the flow to run once a week.
- D. Create a Cloud Run function that uses NumPy. Use Cloud Scheduler to schedule the function to run once a week.
Correct Answer: B 🗳️
Your organization has highly sensitive data that gets updated once a day and is stored across multiple datasets in BigQuery. You need to provide a new data analyst access to query specific data in BigQuery while preventing access to sensitive dat a. What should you do?
- A. Grant the data analyst the BigQuery Job User IAM role in the Google Cloud project.
- B. Create a new Google Cloud project, and copy the limited data into a BigQuery table. Grant the data analyst the BigQuery Data Owner IAM role in the new Google Cloud project.
- C. Grant the data analyst the BigQuery Data Viewer IAM role in the Google Cloud project.
- D. Create a materialized view with the limited data in a new dataset. Grant the data analyst BigQuery Data Viewer IAM role in the dataset and the BigQuery Job User IAM role in the Google Cloud project.
Correct Answer: D 🗳️
Your company uses Looker to generate and share reports with various stakeholders. You have a complex dashboard with several visualizations that needs to be delivered to specific stakeholders on a recurring basis, with customized filters applied for each recipient. You need an efficient and scalable solution to automate the delivery of this customized dashboard. You want to follow the Google- recommended approach. What should you do?
- A. Create a script using the Looker Python SDK, and configure user attribute filter values. Generate a new scheduled plan for each stakeholder.
- B. Embed the Looker dashboard in a custom web application, and use the application's scheduling features to send the report with personalized filters.
- C. Use the Looker Scheduler with a user attribute filter on the dashboard, and send the dashboard with personalized filters to each stakeholder based on their attributes.
- D. Create a separate LookML model for each stakeholder with predefined filters, and schedule the dashboards using the Looker Scheduler.
Correct Answer: C 🗳️
By Iris
