PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #191
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #191: Real Exam Question with Answer & Explanation
The correct answer is C: Use AlloyDB for PostgreSQL.. AlloyDB for PostgreSQL is a fully managed, PostgreSQL-compatible service that automates chores like vacuuming and memory tuning while still supporting standard Postgres schemas and drivers. Its built-in analytics acceleration (columnar storage and vectorized execution engines) le
Question
You are migrating an on-premises online transactional process (OLTP) PostgreSQL database to Google Cloud. You want to reduce the administrative overhead on database maintenance activities, such as vacuum and memory tuning. You are also planning to introduce analytic use cases in this database. You need the migration to have minimal schema and application changes. What should you do-
Options
- AUse Spanner with PGAdapter.
- BUse Cloud SQL for PostgreSQL.
- CUse AlloyDB for PostgreSQL.
- DDeploy a self-managed PostgreSQL database on Compute Engine.
Explanation
AlloyDB for PostgreSQL is a fully managed, PostgreSQL-compatible service that automates chores like vacuuming and memory tuning while still supporting standard Postgres schemas and drivers. Its built-in analytics acceleration (columnar storage and vectorized execution engines) lets you run OLAP queries alongside your OLTP workload with minimal changes to your existing
Topics
Community Discussion
No community discussion yet for this question.