PROFESSIONAL-CLOUD-DATABASE-ENGINEER · Question #181
PROFESSIONAL-CLOUD-DATABASE-ENGINEER Question #181: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to reveal the answer and full explanation for question #181. The question stem and answer options stay visible for context.
Question
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-
Options
- AManually rewrite both the Oracle schema and queries to be compatible with PostgreSQL syntax
- BUse a schema conversion tool to automatically convert the Oracle schema to PostgreSQL
- CMigrate the data directly from Oracle to PostgreSQL without any conversion. Rely on application-
- DUse Database Migration Service code conversion workspace, then review and refactor as needed.
Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-CLOUD-DATABASE-ENGINEER questions. Unlock PROFESSIONAL-CLOUD-DATABASE-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.