A data engineer has migrated a 5 TB data warehouse from on-premises Teradata to BigQuery. Before declaring the migration complete, the engineer needs to verify that all rows were transferred and that the data is accurate. The source system is still available. What is the most reliable validation approach?

Run row count and checksum queries on both the source and BigQuery, and compare the results.

Verify that the BigQuery Data Transfer Service job completed with status 'SUCCEEDED'.

Compare the total size of the source database files with the size of the BigQuery tables.

Run a sample of queries on BigQuery and confirm the results look reasonable.

A multinational corporation is planning to migrate its data warehouse from Teradata on-premises to BigQuery. The data engineering team has identified the source tables and their sizes, but the business analysts have not been consulted about their reporting requirements. Several legacy reports depend on features that BigQuery does not support, such as recursive queries with specific syntax. What is the first step the data engineer should take before designing the migration plan?

Set up a Datastream pipeline to continuously replicate Teradata data to BigQuery.

Select the migration strategy based on the table sizes identified by the data engineering team.

Create a proof-of-concept BigQuery environment and start loading the largest tables.

Interview business analysts and report owners to document all reporting requirements and dependencies.

Why is it important to document technical debt during a current state assessment?

To select the appropriate migration strategy for each workload

To determine the exact cost of running the new system on Google Cloud

To identify which stakeholders need to approve the migration budget

To understand limitations in the existing systems that may affect migration planning

Google CloudProfessional Data Engineer

Domain 1Objective 4

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

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 6–10

6foundation · easy
Which Google Cloud service is designed for offline transfer of very large datasets that would take too long to send over the network?
Select an answer first
7foundation · easy
Which networking option encrypts traffic between an on-premises network and Google Cloud over the public internet?
Select an answer first
8application · medium
A data engineer has migrated a 5 TB data warehouse from on-premises Teradata to BigQuery. Before declaring the migration complete, the engineer needs to verify that all rows were transferred and that the data is accurate. The source system is still available. What is the most reliable validation approach?
Select an answer first
9application · medium
A multinational corporation is planning to migrate its data warehouse from Teradata on-premises to BigQuery. The data engineering team has identified the source tables and their sizes, but the business analysts have not been consulted about their reporting requirements. Several legacy reports depend on features that BigQuery does not support, such as recursive queries with specific syntax. What is the first step the data engineer should take before designing the migration plan?
Select an answer first
10foundation · easy
Why is it important to document technical debt during a current state assessment?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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 2)

Questions 6–10

Which Google Cloud service is designed for offline transfer of very large datasets that would take too long to send over the network?

Which networking option encrypts traffic between an on-premises network and Google Cloud over the public internet?

Why is it important to document technical debt during a current state assessment?

Keep studying — Designing data processing systems