Design innovative, scalable, and highly available cloud database solutions →mediumMultiple SelectObjective-mapped
PCDE Practice Question: Design innovative, scalable, and highly available cloud database solutions
A company is migrating a monolithic application to Google Cloud and needs to modernize the database layer. The application has both OLTP (high-volume transactions) and OLAP (complex reporting) workloads. The team wants to use a single database to simplify operations but with high performance for both. Which TWO Google Cloud database services support hybrid transactional/analytical processing (HTAP)? (Choose two.)
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
✓
AlloyDB
AlloyDB with columnar engine and Spanner with analytics interface support HTAP. Cloud SQL and Bigtable do not natively support HTAP. BigQuery is purely analytical.
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 Bigtable
Why it's wrong here
Bigtable is NoSQL, not HTAP.
- ✗
BigQuery
Why it's wrong here
BigQuery is purely analytical, not transactional.
- ✓
AlloyDB
Why this is correct
AlloyDB includes a columnar engine for analytics on transactional data.
- ✓
Cloud Spanner
Why this is correct
Spanner has an analytics interface supporting complex queries.
- ✗
Cloud SQL
Why it's wrong here
Cloud SQL does not have built-in analytics capabilities.
Go deeper
Related to this question
About these practice questions
One of 1,446 original PCDE 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 PCDE 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 PCDE exam.