# Google Professional Data Engineer (GPDE) practice exams

> Google Professional Data Engineer practice exams: 241 questions in 5 timed tests, every answer explained.

Page: https://devopscodelab.com/exams/google-professional-data-engineer/

241 questions in 5 timed practice tests. Each test has about 50 questions and a 120-minute limit. The pass mark is 70%. Results are split across the 5 exam domains.

## Exam at a glance

| Setting | Value |
| --- | --- |
| Practice tests | 5 |
| Questions in total | 241 |
| Questions per test | About 50 |
| Time limit per test | 120 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (26 multiple-answer questions) |
| Level | Professional |
| Category | Data & Analytics |

These are the settings of our practice tests. Check the official Google Cloud exam page for the current format before you book.

## Domains and weights

| Domain | Weight | Questions in our bank |
| --- | --- | --- |
| Designing data processing systems | 22% | 53 |
| Ingesting and processing the data | 25% | 60 |
| Storing the data | 20% | 48 |
| Preparing and using data for analysis | 15% | 37 |
| Maintaining and automating data workloads | 18% | 43 |

## Price and access

- GPDE practice exams: $14.99 for 12 months of access.
- Free mini exam: 15 questions with explanations (free account): https://devopscodelab.com/app/exams/google-professional-data-engineer/mini/
- All-Access subscription includes every exam: https://devopscodelab.com/pricing/
- 10 free questions with answers: https://devopscodelab.com/exams/google-professional-data-engineer/free-practice-questions/

## Sample questions

### Question 1 of 3

A SaaS provider stores each tenant's data in its own BigQuery dataset. Contracts require that when a tenant leaves, all of its data becomes permanently unreadable immediately, including any copies in time travel or fail-safe storage. Which design supports this?

- A. Remove all IAM bindings on the tenant's dataset when the contract ends and record the change for auditors
- B. Encrypt each tenant's dataset with its own Cloud KMS key, then disable and destroy that key's versions when the tenant leaves
- C. Run a Sensitive Data Protection de-identification job over the tenant's tables before deleting the dataset
- D. Delete the tenant's dataset when the contract ends and set the dataset time travel window to its minimum allowed length

**Answer:** B

**Explanation:** Using a dedicated CMEK key per tenant enables crypto-shredding: disabling the key versions makes the tenant's data unreadable right away, and destroying them makes every copy, including time travel and fail-safe copies, permanently unreadable. Deleting the dataset still leaves data recoverable for the time travel and fail-safe periods. Removing IAM bindings leaves data readable by anyone who regains access. De-identification transforms only selected values and does not reach existing recovery copies.

### Question 2 of 3

A healthcare provider stores patient records in BigQuery datasets and Cloud Storage buckets inside three projects. Auditors require that even a user holding valid IAM permissions cannot copy this data into a project that belongs to another organization, for example by running a query whose destination table sits elsewhere. What should the data engineer implement?

- A. An organization policy using the resource locations constraint so that every BigQuery dataset and bucket can only be created in approved regions
- B. Customer-managed encryption keys in Cloud KMS for every dataset and bucket, with key access limited to the healthcare team's groups
- C. A VPC Service Controls service perimeter around the three projects that restricts the BigQuery and Cloud Storage APIs for all callers
- D. Replacing BigQuery Data Owner grants with BigQuery Data Viewer so that analysts can read tables but never modify or delete them

**Answer:** C

**Explanation:** A VPC Service Controls perimeter blocks API calls that move data from protected projects to resources outside the perimeter, which is exactly the exfiltration path described, even for users with valid IAM roles. The resource locations constraint only controls where new resources may be created. CMEK protects data at rest but an authorized user can still read it and write the results elsewhere. Data Viewer users can still query tables and save results to a destination table in another project.

### Question 3 of 3

Mobile clients publish purchase events to Pub/Sub and retry when they time out, so the same purchase is sometimes published twice with different Pub/Sub message IDs. Each event carries a unique purchase_id. A Dataflow pipeline written with the Apache Beam Java SDK writes the events to BigQuery, and finance requires each purchase to appear once. What should the data engineer do?

- A. Enable exactly-once delivery on the Pub/Sub subscription that the Dataflow pipeline reads from so that redelivered messages are suppressed
- B. Set the purchase_id as the insertId when streaming rows to BigQuery and rely on the streaming buffer to remove duplicate rows permanently
- C. Add purchase_id as a message attribute, configure PubsubIO to use it as the ID attribute, and deduplicate downstream by that key
- D. Publish the events with an ordering key equal to purchase_id so that Pub/Sub delivers duplicates in sequence and drops the second copy

**Answer:** C

**Explanation:** Publisher retries create new message IDs, so the deduplication must use a business key; configuring PubsubIO with an ID attribute lets Dataflow drop repeats of the same purchase_id, and a keyed deduplication step covers repeats outside that window. Exactly-once delivery only prevents redelivery of the same message ID. Ordering keys order messages but do not remove duplicates. BigQuery insertId deduplication is best effort over a short period and is not a guarantee.


## Study plans

### Two weeks

1. Day 1: take practice test 1 in exam mode to get a baseline.
2. Days 2 to 5: domain mode on Ingesting and processing the data and Designing data processing systems, the two most heavily weighted domains.
3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

### Four weeks

1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

## Questions about the GPDE practice exams

**Are these real GPDE exam questions?**

No. We write every question ourselves and map it to the published GPDE exam objectives. We do not use leaked or recalled questions.

**Do the time limit and pass mark match the official exam?**

They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.

**Can I try it before I pay?**

Yes. The free mini exam has 15 questions with full explanations and needs no account.

**How long do I keep access?**

A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.

**What happens after I finish a test?**

You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026.

DevOpsCode Lab is not affiliated with Google Cloud. GPDE and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
