A company is migrating its on-premises PostgreSQL database to Cloud SQL using DMS with continuous replication. The team wants to validate the target database before cutover. What is the best way to validate the data without impacting the source?

Run read-only queries against the Cloud SQL instance while replication is ongoing.

Stop replication and run a full data comparison between source and target.

Run write queries against the target to test its functionality.

Use a third-party tool to compare the source and target in real-time.

A retail company is migrating its on-premises PostgreSQL database to Cloud SQL for PostgreSQL. The migration must not cause any downtime for the application, and the team needs to validate the target before switching traffic. The source database is actively used and cannot be frozen. Which migration approach should the team use?

Use Storage Transfer Service to copy the database files to a Cloud Storage bucket and then import them into Cloud SQL.

Use Database Migration Service with continuous replication and perform a final cutover after validating the target.

Take a full backup of the source, restore it to Cloud SQL, and then redirect all application traffic to the target.

Set up dual-writes from the application to both the source and target, then switch reads to the target after a week.

Which component is essential to include in a comprehensive database migration plan to ensure the migration can be undone if a critical issue is discovered after cutover?

A backup of the target database only

A list of target database features

A team is migrating an on-premises SQL Server database to Cloud Spanner. The source schema uses stored procedures that contain T-SQL specific syntax. What should the team do to ensure the application works with Cloud Spanner?

Use a compatibility layer that translates T-SQL to GoogleSQL at runtime.

Rewrite the stored procedures using GoogleSQL or PostgreSQL dialect, and update the application to call the new procedures.

Keep the stored procedures as-is because Cloud Spanner supports T-SQL.

Move the stored procedures to Cloud Functions and call them from the application.

In which scenario is reverse replication most beneficial?

When the migration needs to be reversible and the source must remain up-to-date with changes made on Google Cloud

When the migration uses an extended outage approach

When the target database is read-only

When the source database is being decommissioned immediately after cutover

Google CloudProfessional Cloud Database Engineer

Domain 3Objective 1

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

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 11–15

11application · medium
A company is migrating its on-premises PostgreSQL database to Cloud SQL using DMS with continuous replication. The team wants to validate the target database before cutover. What is the best way to validate the data without impacting the source?
Select an answer first
12application · medium
A retail company is migrating its on-premises PostgreSQL database to Cloud SQL for PostgreSQL. The migration must not cause any downtime for the application, and the team needs to validate the target before switching traffic. The source database is actively used and cannot be frozen. Which migration approach should the team use?
Select an answer first
13foundation · easy
Which component is essential to include in a comprehensive database migration plan to ensure the migration can be undone if a critical issue is discovered after cutover?
Select an answer first
14application · medium
A team is migrating an on-premises SQL Server database to Cloud Spanner. The source schema uses stored procedures that contain T-SQL specific syntax. What should the team do to ensure the application works with Cloud Spanner?
Select an answer first
15foundation · easy
In which scenario is reverse replication most beneficial?
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.