Exam Professional Cloud Database Engineer topic 1 question 161 discussion

Actual exam question from Google's Professional Cloud Database Engineer

Question #: 161
Topic #: 1

[All Professional Cloud Database Engineer Questions]

Your company is migrating a legacy on-premises Oracle database to Cloud SQL for PostgreSQL. As a part of the migration, you need to convert schema and other database code objects, such as procedures, functions, and triggers, from Oracle to PostgreSQL. The database migration needs to be accomplished with minimal application code changes and manual intervention. What is the Google-recommended approach you should do?

A. Manually rewrite both the Oracle schema and queries to be compatible with PostgreSQL syntax and semantics.
B. Use a schema conversion tool to automatically convert the Oracle schema to PostgreSQL schema, then manually rewrite all queries.
C. Migrate the data directly from Oracle to PostgreSQL without any conversion. Rely on application-level compatibility layers to handle any syntax or semantic differences.
D. Use Database Migration Service code conversion workspace, then review and refactor as needed.

Show Suggested Answer

Suggested Answer: D 🗳️

by Sai_Vignesh at Aug. 7, 2025, 3:17 a.m.

Comments

Submit Cancel

Sai_Vignesh

1 week, 1 day ago

Selected Answer: C

Pretty sure it's C. This pattern is very common.

upvoted 1 times

...