Skip to content

Migrate data solutions Questions

Practice questions for Migrate data solutions topic in Google Professional Cloud Database Engineer. 43 questions covering this domain.

43 questions11 easy20 medium12 hard
Q1
hard

A team wants to leave HBase with no-downtime live migration while keeping an HBase-compatible API on Google Cloud. Which target is the best fit?

Q2
medium

Before cutover, a migration lead wants an official DMS step that helps confirm the migration is likely to succeed. What should the team run?

Q3
hard

A migration team needs AI-assisted conversion of stored procedures, triggers, and functions from Oracle to a PostgreSQL-compatible dialect, along with...

Q4
easy

How is Database Migration Service priced for homogeneous migrations where source and destination use the same database engine?

Q5
easy

Which Google Cloud service performs an initial snapshot followed by continuous replication to support minimal-downtime database migrations?

Q6
medium

A team is moving PostgreSQL to AlloyDB and wants Google's fully managed migration service with minimal downtime. Which service should it use?

Q7
medium

A data team wants every insert, update, and delete from MySQL or Oracle to land in BigQuery with minimal impact on the source database. Which service ...

Q8
medium

A program is moving Oracle and SQL Server workloads to PostgreSQL and wants built-in schema and code conversion to reduce manual effort. Which DMS cap...

Q9
medium

A company wants real-time analytics in BigQuery from an operational relational database and plans to process the incoming stream with a Google-managed...

Q10
easy

Which Google Cloud service is designed for serverless change data capture and replication with near real-time delivery?

Q11
hard

A company is comparing two projects: PostgreSQL to Cloud SQL and Oracle to PostgreSQL. Which pricing statement about Database Migration Service is cor...

Q12
medium

A migration team has assessed an Oracle-to-AlloyDB migration and found 30% of stored procedures require manual intervention after the automated conver...

Q13
easy

Which DMS feature validates schema, data, and application compatibility before the full migration cutover?

Q14
easy

Which Database Migration Service job type is recommended when the source and destination databases are both PostgreSQL?

Q15
hard

A team is migrating a 5 TB MySQL database to Cloud SQL using DMS continuous replication and notices the DMS job is falling behind on CDC events during...

Q16
easy

Which Google Cloud service provides AI-assisted conversion of stored procedures, triggers, and DML from Oracle to PostgreSQL?

Q17
hard

A Bigtable HBase migration team uses the HBase migration tool and needs data to remain queryable from HBase clients during the cut-over period. Which ...

Q18
medium

A team needs to migrate a large dataset from on-premises Oracle to Spanner with minimal downtime, using Dataflow for transformation. Which Dataflow te...

Q19
medium

A DMS migration job from MySQL to Cloud SQL is running continuous replication. The team wants to understand what happens to in-flight transactions dur...

Q20
medium

A company wants to move its on-premises PostgreSQL data to Cloud SQL with the least amount of manual work during initial setup. Which DMS source type ...

Sign in to see all 43 questions

Create a free account to browse all questions — completely free during our launch phase.