S
Google Professional Data Engineer (PDE) ACTUAL
PRACTICE EXAM 2026/2027 | Verified Questions
and Answers | Complex Architectural Scenarios &
Trade-off Analysis | Exam Pass Target - A+ Graded
SECTION 1: Designing Data Processing Systems (Questions 1–15)
Q1: A retail company processes 50 TB of daily transaction data from 10,000 global stores. The
data must support real-time inventory updates (sub-second latency) and complex analytical
queries for business intelligence. Current architecture struggles with both workloads on a single
system. Which architecture meets both requirements optimally?
A. Store all data in BigQuery for analytics; replicate to Cloud SQL for real-time lookups
B. Use Bigtable for real-time inventory lookups and BigQuery for analytical workloads, with
Dataflow streaming inserts to both [CORRECT]
C. Store everything in Cloud Spanner with read replicas for analytics
D. Use Cloud Storage with Hive on Dataproc for all workloads
Correct Answer: B
Q2: A financial services firm must retain transaction records for 7 years for regulatory
compliance. Data is accessed frequently for the first 90 days, occasionally for the next year, and
rarely thereafter. Cost optimization is critical. Which storage approach minimizes cost while
meeting access requirements?
A. Keep all data in BigQuery standard storage for 7 years
B. Use Cloud Storage with lifecycle policies: Standard (90 days), Nearline (275 days), Coldline
(remainder), and Archive after 1 year [CORRECT]
C. Store everything in Multi-Regional Cloud Storage
D. Use Bigtable with automatic garbage collection set to 7 years
Correct Answer: B
Q3: A gaming company generates 5 million events per second from player interactions. The data
requires immediate aggregation for leaderboards and must support historical trend analysis. The
schema evolves frequently as new game features are added. Which database combination is
optimal?
, S
A. Cloud SQL for transactions, BigQuery for analytics
B. Bigtable for real-time aggregations, BigQuery for historical analysis, with Dataflow for
stream processing [CORRECT]
C. Firestore for all data with export to BigQuery
D. Spanner for real-time and BigQuery for analytics
Correct Answer: B
Q4: A healthcare organization stores patient imaging data (DICOM files averaging 500 MB
each) that must be retained for 21 years. Radiologists need to retrieve specific studies within
seconds. Compliance requires encryption with customer-managed keys. Which architecture
meets these requirements?
A. Cloud Storage Nearline with CMEK, organized by patient ID and study date, with a Firestore
index for metadata lookup [CORRECT]
B. BigQuery with binary column storage
C. Cloud SQL with BLOB storage
D. Bigtable with image chunks as values
Correct Answer: A
Q5: An e-commerce platform needs to migrate 500 TB of on-premises Oracle data warehouse to
GCP. The migration must minimize downtime and support existing SQL queries with minimal
modification. Which approach is most appropriate?
A. Export to CSV and load into BigQuery
B. Use BigQuery Data Transfer Service from Oracle, with BigQuery's standard SQL
compatibility and scheduled queries for migration [CORRECT]
C. Replicate to Cloud SQL for PostgreSQL
D. Build custom Dataflow pipelines for each table
Correct Answer: B
Q6: A logistics company tracks 100,000 vehicles with GPS coordinates every 10 seconds. The
system must support geospatial queries (vehicles within radius) and historical route
reconstruction. Which storage and query architecture is optimal?
A. BigQuery with geospatial functions for all queries
B. Bigtable for real-time positions with geohash row keys, BigQuery for historical analysis
[CORRECT]
Google Professional Data Engineer (PDE) ACTUAL
PRACTICE EXAM 2026/2027 | Verified Questions
and Answers | Complex Architectural Scenarios &
Trade-off Analysis | Exam Pass Target - A+ Graded
SECTION 1: Designing Data Processing Systems (Questions 1–15)
Q1: A retail company processes 50 TB of daily transaction data from 10,000 global stores. The
data must support real-time inventory updates (sub-second latency) and complex analytical
queries for business intelligence. Current architecture struggles with both workloads on a single
system. Which architecture meets both requirements optimally?
A. Store all data in BigQuery for analytics; replicate to Cloud SQL for real-time lookups
B. Use Bigtable for real-time inventory lookups and BigQuery for analytical workloads, with
Dataflow streaming inserts to both [CORRECT]
C. Store everything in Cloud Spanner with read replicas for analytics
D. Use Cloud Storage with Hive on Dataproc for all workloads
Correct Answer: B
Q2: A financial services firm must retain transaction records for 7 years for regulatory
compliance. Data is accessed frequently for the first 90 days, occasionally for the next year, and
rarely thereafter. Cost optimization is critical. Which storage approach minimizes cost while
meeting access requirements?
A. Keep all data in BigQuery standard storage for 7 years
B. Use Cloud Storage with lifecycle policies: Standard (90 days), Nearline (275 days), Coldline
(remainder), and Archive after 1 year [CORRECT]
C. Store everything in Multi-Regional Cloud Storage
D. Use Bigtable with automatic garbage collection set to 7 years
Correct Answer: B
Q3: A gaming company generates 5 million events per second from player interactions. The data
requires immediate aggregation for leaderboards and must support historical trend analysis. The
schema evolves frequently as new game features are added. Which database combination is
optimal?
, S
A. Cloud SQL for transactions, BigQuery for analytics
B. Bigtable for real-time aggregations, BigQuery for historical analysis, with Dataflow for
stream processing [CORRECT]
C. Firestore for all data with export to BigQuery
D. Spanner for real-time and BigQuery for analytics
Correct Answer: B
Q4: A healthcare organization stores patient imaging data (DICOM files averaging 500 MB
each) that must be retained for 21 years. Radiologists need to retrieve specific studies within
seconds. Compliance requires encryption with customer-managed keys. Which architecture
meets these requirements?
A. Cloud Storage Nearline with CMEK, organized by patient ID and study date, with a Firestore
index for metadata lookup [CORRECT]
B. BigQuery with binary column storage
C. Cloud SQL with BLOB storage
D. Bigtable with image chunks as values
Correct Answer: A
Q5: An e-commerce platform needs to migrate 500 TB of on-premises Oracle data warehouse to
GCP. The migration must minimize downtime and support existing SQL queries with minimal
modification. Which approach is most appropriate?
A. Export to CSV and load into BigQuery
B. Use BigQuery Data Transfer Service from Oracle, with BigQuery's standard SQL
compatibility and scheduled queries for migration [CORRECT]
C. Replicate to Cloud SQL for PostgreSQL
D. Build custom Dataflow pipelines for each table
Correct Answer: B
Q6: A logistics company tracks 100,000 vehicles with GPS coordinates every 10 seconds. The
system must support geospatial queries (vehicles within radius) and historical route
reconstruction. Which storage and query architecture is optimal?
A. BigQuery with geospatial functions for all queries
B. Bigtable for real-time positions with geohash row keys, BigQuery for historical analysis
[CORRECT]
