GCDE
Google Cloud Database Engineer (GCDE) practice exams
240 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 4 exam domains.
Exam at a glance
| Practice tests | 5 |
|---|---|
| Questions in total | 240 |
| Questions per test | About 50 |
| Time limit per test | 120 minutes |
| Pass mark | 70% |
| Question types | Single answer and multiple answer (22 multiple-answer questions) |
| Level | Associate |
| 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 |
|---|---|---|---|
| Design Innovative, Scalable, and Highly Available Cloud Database Solutions | 32% | 77 | |
| Manage a Solution That Can Span Multiple Database Technologies | 25% | 59 | |
| Migrate Data Solutions | 23% | 56 | |
| Deploy Scalable and Highly Available Databases in Google Cloud | 20% | 48 |
Sample questions
Question 1 of 3
A payments API must keep running if a single zone fails, with an RPO of zero and an RTO of a few minutes. The workload is MySQL, fits on one machine, and serves customers from one region only. Budget matters, so the team wants the simplest configuration that meets these targets. What should the database engineer provision?
- A A Spanner multi-region instance so that writes are committed across regions before being acknowledged to the payments API
- B A Cloud SQL for MySQL instance with high availability (regional) enabled, which keeps a synchronous standby in another zone (correct answer)
- C A zonal Cloud SQL instance with automated backups and point-in-time recovery enabled so it can be restored into another zone
- D A zonal Cloud SQL for MySQL instance with a read replica in a second zone that is promoted manually when the zone fails
Question 2 of 3
A support team already stores ticket text in AlloyDB for PostgreSQL. They want to build retrieval-augmented generation by creating embeddings inside SQL statements and running approximate nearest-neighbor searches over 50 million vectors with low latency, without adding a separate vector database. What should the database engineer implement?
- A Export the tickets to BigQuery nightly, generate embeddings with ML.GENERATE_EMBEDDING, and use VECTOR_SEARCH from the application
- B Use the google_ml_integration embedding() function to call a Vertex AI model and create a ScaNN index on the vector column (correct answer)
- C Store embeddings in a pgvector column without any index, relying on the AlloyDB columnar engine to speed up exact searches
- D Generate embeddings in a Cloud Run service, store them in Memorystore, and run brute-force similarity in the application
Question 3 of 3
An industrial IoT platform ingests about 500,000 sensor readings per second, stores 30 TB of history, and serves queries that fetch the readings of one device over a time range. No multi-row transactions or joins are needed. Which database is the BEST fit?
- A Cloud SQL for PostgreSQL with a table partitioned by day
- B Spanner with an interleaved Readings table under a Devices table and secondary indexes on time
- C Firestore in Native mode with one document per reading and a composite index on device and time
- D Bigtable with a row key that combines the device ID and a timestamp (correct answer)
See all 10 free GCDE questions with answers Read them or quiz yourself.
What your score report looks like
Example attempt, GCDE practice test 3
77%
Passed
Pass mark 70%
| Domain | Weight | Your score | % |
|---|---|---|---|
| Design Innovative, Scalable, and Highly Available Cloud Database Solutions | 32% | 88 | |
| Manage a Solution That Can Span Multiple Database Technologies | 25% | 81 | |
| Migrate Data Solutions | 23% | 76 | |
| Deploy Scalable and Highly Available Databases in Google Cloud | 20% | 58 |
Study next: Deploy Scalable and Highly Available Databases in Google Cloud. It is below the pass mark and carries 20% 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 Design Innovative, Scalable, and Highly Available Cloud Database Solutions and Manage a Solution That Can Span Multiple Database Technologies, 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 GCDE practice exams
- Are these real GCDE exam questions?
- No. We write every question ourselves and map it to the published GCDE 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 |
|---|---|---|---|---|---|
| GPCDGoogle Professional Cloud Developer | Google Cloud | Professional | 250 | 120 | $14.99 |
| GPCDEGoogle Professional Cloud DevOps Engineer | Google Cloud | Professional | 250 | 120 | $14.99 |
| GPCSEGoogle Professional Cloud Security Engineer | Google Cloud | Professional | 250 | 120 | $14.99 |
| GPDEGoogle Professional Data Engineer | Google Cloud | Professional | 251 | 120 | $14.99 |
| GPSOGoogle Professional Security Operations | Google Cloud | Professional | 251 | 120 | $14.99 |
| PCAGoogle Professional Cloud Architect | Google Cloud | Professional | 250 | 120 | $14.99 |