After migrating data to Google Cloud, a data engineer compares row counts and checksums between the source and target systems. Which activity is being performed?

Migration validation and testing

A logistics company is planning to migrate its on-premises PostgreSQL database to Cloud SQL. During the current state assessment, the data engineer discovers that several applications write directly to the database using different schemas, and there are undocumented stored procedures that perform complex calculations. What is the most important consideration for the migration plan?

Choose a lift-and-shift strategy because it requires no analysis.

Document all data flows, application dependencies, and stored procedures to understand the full migration baseline.

Use Datastream to replicate all changes to Cloud SQL without further analysis.

Immediately begin migrating the largest tables to Cloud SQL to save time.

A gaming company is migrating its clickstream analytics from a self-managed Hadoop cluster to Google Cloud. The target architecture must support real-time dashboards and ad-hoc SQL queries. The data is currently stored in Parquet files on HDFS. Which target architecture best meets these requirements?

Stream the data into Cloud Bigtable and use HBase queries for dashboards.

Load the Parquet files into BigQuery and use Data Studio for dashboards and standard SQL for ad-hoc queries.

Keep the data in a Dataproc cluster and use Hive for queries and Zeppelin for dashboards.

Store the Parquet files in Cloud Storage and query them with Spark on Dataproc.

Google CloudProfessional Data Engineer

Domain 1Objective 4

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

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 26–30

26foundation · easy
A data engineer is defining the target architecture on Google Cloud, including which storage services to use and how data will be accessed. Which activity is this?
Select an answer first
27foundation · easy
After migrating data to Google Cloud, a data engineer compares row counts and checksums between the source and target systems. Which activity is being performed?
Select an answer first
28application · medium
A logistics company is planning to migrate its on-premises PostgreSQL database to Cloud SQL. During the current state assessment, the data engineer discovers that several applications write directly to the database using different schemas, and there are undocumented stored procedures that perform complex calculations. What is the most important consideration for the migration plan?
Select an answer first
29application · medium
A gaming company is migrating its clickstream analytics from a self-managed Hadoop cluster to Google Cloud. The target architecture must support real-time dashboards and ad-hoc SQL queries. The data is currently stored in Parquet files on HDFS. Which target architecture best meets these requirements?
Select an answer first
30foundation · easy
A company needs a dedicated, high-bandwidth connection between its on-premises data center and Google Cloud for a large data migration. Which networking option is most appropriate?
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 6)

Questions 26–30

A data engineer is defining the target architecture on Google Cloud, including which storage services to use and how data will be accessed. Which activity is this?

After migrating data to Google Cloud, a data engineer compares row counts and checksums between the source and target systems. Which activity is being performed?

A company needs a dedicated, high-bandwidth connection between its on-premises data center and Google Cloud for a large data migration. Which networking option is most appropriate?

Keep studying — Designing data processing systems