PDE Ingesting and Processing the Data Practice Question
A company uses Google Ads and wants to automatically load their advertising data into BigQuery daily. They also need to transform the data with SQL and schedule a recurring query. Which combination of services meets these requirements with minimal operational overhead?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
BigQuery Data Transfer Service for Google Ads and scheduled queries
BigQuery Data Transfer Service can automatically load Google Ads data; scheduled queries handle transformation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Cloud Functions triggered by Cloud Scheduler to call Google Ads API and load into BigQuery
Why it's wrong here
This option introduces substantial operational overhead by requiring custom code within Cloud Functions to manage Google Ads API interaction, authentication, pagination, and data loading into BigQuery. This contradicts the requirement for minimal operational overhead. While Cloud Functions are excellent for scheduled, serverless execution of custom logic, they are best suited for bespoke integrations, real-time event processing, or when pre-built connectors lack specific functionality needed for complex data manipulation before ingestion.
- ✗
Cloud Composer to extract Google Ads API and Dataflow to transform
Why it's wrong here
Higher operational overhead; unnecessary for simple scheduled loads.
- ✗
Storage Transfer Service to move CSV files to GCS, then load into BigQuery
Why it's wrong here
Storage Transfer Service is for cloud storage transfers, not Google Ads data.
- ✓
BigQuery Data Transfer Service for Google Ads and scheduled queries
Why this is correct
Direct integration with scheduled queries for transformation.
Go deeper
Related to this question
About these practice questions
One of 890 original PDE practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.