Which of the following is an example of DML conversion?

Converting a table definition from VARCHAR to TEXT

Translating a SQL SELECT statement to use the target database's function syntax

Modifying the database user permissions

Changing the storage engine of a table

A company is planning to migrate its production database to Google Cloud. The business has a strict requirement that the database must remain available to users throughout the migration, with no scheduled maintenance window. Which migration strategy should the database engineer recommend?

Extended outage migration with a planned downtime window

Lift-and-shift migration with a brief application pause

Fallback strategy that reverts to the source after cutover

Zero or near-zero downtime migration using replication

A database engineer is creating a migration plan. Which element should be defined to assign ownership and ensure each phase of the migration is completed on schedule?

A list of target database limitations

A list of potential migration tools

A timeline with milestones and assigned resources

A team is planning an extended outage migration of a PostgreSQL database to Cloud SQL. They have a rollback plan that involves restoring the source from a backup. What is the most important factor to ensure the rollback plan is effective?

The rollback plan must be documented in a runbook and approved by management.

The team must have a second backup taken a week before the migration.

The backup must be taken immediately before the migration starts and tested for restorability.

The rollback plan must include a step to notify all users of the rollback.

Before cutting over to the target database in an extended outage migration, what should be performed to ensure the migrated data is accurate and complete?

Data validation and consistency checks

Google CloudProfessional Cloud Database Engineer

Domain 3Objective 1

3.1 Design and Implement Data Migration and Replication PROFESSIONAL-CLOUD-DATABASE-ENGINEER Practice Questions (Page 6)

Part of the Migrate data solutions domain, which accounts for ~23% of the PROFESSIONAL-CLOUD-DATABASE-ENGINEER exam.

33questions here

7free pages

9concepts

~23%of the exam

Questions 26–30

26foundation · easy
Which of the following is an example of DML conversion?
Select an answer first
27foundation · easy
A company is planning to migrate its production database to Google Cloud. The business has a strict requirement that the database must remain available to users throughout the migration, with no scheduled maintenance window. Which migration strategy should the database engineer recommend?
Select an answer first
28foundation · easy
A database engineer is creating a migration plan. Which element should be defined to assign ownership and ensure each phase of the migration is completed on schedule?
Select an answer first
29application · medium
A team is planning an extended outage migration of a PostgreSQL database to Cloud SQL. They have a rollback plan that involves restoring the source from a backup. What is the most important factor to ensure the rollback plan is effective?
Select an answer first
30foundation · easy
Before cutting over to the target database in an extended outage migration, what should be performed to ensure the migrated data is accurate and complete?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-CLOUD-DATABASE-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-CLOUD-DATABASE-ENGINEER” is a trademark of its owner, used for identification only.