A data engineer is migrating a 20 TB on-premises SQL Server data warehouse to BigQuery. The migration must be completed over a weekend. The source database is actively used during the week, but is read-only on weekends. The engineer plans to use BigQuery Data Transfer Service. What is the most important consideration to ensure a successful migration?

Configure a rollback plan in case the migration fails midway through the weekend.

Ensure that the BigQuery destination dataset is in the same region as the source database.

Verify that the source database is running on a supported version of SQL Server.

Ensure the source database is accessible from BigQuery Data Transfer Service and that the transfer window is sufficient for 20 TB.

A media streaming company runs its recommendation engine on a custom in-house platform that processes user activity logs stored in a self-managed Cassandra cluster. The platform is tightly coupled to Cassandra's specific query patterns. The company wants to move to Google Cloud to reduce operational overhead, but the recommendation engine cannot be rewritten in the next 12 months. The data volume is 100 TB and grows by 1 TB per day. What is the most appropriate migration strategy?

Re-architect the recommendation engine to use Bigtable and Dataflow for stream processing.

Migrate the data to Cloud Storage and use Dataproc with Spark to process the logs.

Re-platform the Cassandra cluster to run on Compute Engine with locally attached SSDs, and migrate the application as-is.

Lift-and-shift the Cassandra cluster to Google Kubernetes Engine using the Cassandra container image.

What is a key benefit of using Database Migration Service for a database migration?

It supports minimal downtime through continuous replication and cutover

It only works for offline migrations with no network connectivity

It is only used for migrating data to BigQuery

It automatically redesigns the database schema for cloud-native performance

Google CloudProfessional Data Engineer

Domain 1Objective 4

1.4 Designing Data Migrations PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 8)

Part of the Designing data processing systems domain, which accounts for ~22% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~11–18 in this domain), expect 3–5 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

12concepts

~22%of the exam

Questions 36–38

36expert · hard
A data engineer is migrating a 20 TB on-premises SQL Server data warehouse to BigQuery. The migration must be completed over a weekend. The source database is actively used during the week, but is read-only on weekends. The engineer plans to use BigQuery Data Transfer Service. What is the most important consideration to ensure a successful migration?
Select an answer first
37expert · hard
A media streaming company runs its recommendation engine on a custom in-house platform that processes user activity logs stored in a self-managed Cassandra cluster. The platform is tightly coupled to Cassandra's specific query patterns. The company wants to move to Google Cloud to reduce operational overhead, but the recommendation engine cannot be rewritten in the next 12 months. The data volume is 100 TB and grows by 1 TB per day. What is the most appropriate migration strategy?
Select an answer first
38foundation · easy
What is a key benefit of using Database Migration Service for a database migration?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to PROFESSIONAL-DATA-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-DATA-ENGINEER” is a trademark of its owner, used for identification only.

1.4 Designing Data Migrations PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 8)

Questions 36–38

What is a key benefit of using Database Migration Service for a database migration?

Keep studying — Designing data processing systems