GPDE
Google Professional Data Engineer (GPDE) practice exams
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
| 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 exam format before you book.
Domains and weights
| Domain | Weight | Weight bar | 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 |
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 (correct answer)
- 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
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 (correct answer)
- D Replacing BigQuery Data Owner grants with BigQuery Data Viewer so that analysts can read tables but never modify or delete them
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 (correct answer)
- 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
See all 10 free GPDE questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, GPDE practice test 3
79%
Passed
Pass mark 70%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Designing data processing systems | 22% | 88 | |
| Ingesting and processing the data | 25% | 81 | |
| Storing the data | 20% | 76 | |
| Preparing and using data for analysis | 15% | 58 | |
| Maintaining and automating data workloads | 18% | 84 |
Study next: Preparing and using data for analysis. It is below the pass mark and carries 15% of the exam.
Study plans
Two weeks
- Day 1: take practice test 1 in exam mode to get a baseline.
- Days 2 to 5: domain mode on Ingesting and processing the data and Designing data processing systems, the two most heavily weighted domains.
- Day 6: practice test 2 in exam mode, then the mistakes quiz.
- Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
- Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.
Four weeks
- Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
- Week 2: domain mode on those two domains, then a second practice test in exam mode.
- Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
- 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.
Related exams
| Exam | Vendor | Level | Questions | Minutes | Price |
|---|---|---|---|---|---|
| GCDLGoogle Cloud Digital Leader | Google Cloud | Foundational | 250 | 90 | $9.99 |
| GGALGoogle Generative AI Leader | Google Cloud | Foundational | 251 | 90 | $9.99 |
| DP-900Azure Data Fundamentals DP-900 | Microsoft | Foundational | 225 | 45 | $9.99 |
| SPLK-1001Splunk Core Certified User (SPLK-1001) | Splunk | Foundational | 300 | 60 | $9.99 |
| 1Z0-071Oracle Database SQL 1Z0-071 | Oracle | Associate | 315 | 120 | $12.99 |
| 1Z0-082Oracle Database Admin I 1Z0-082 | Oracle | Associate | 300 | 100 | $12.99 |