What types of transfers does BigQuery Data Transfer Service support?

Scheduled and one-time transfers

Only offline physical transfers

Only continuous real-time transfers

Only database schema migrations

A company is migrating its customer database from on-premises SQL Server to Cloud SQL for SQL Server. The database is 3 TB and is used by a critical application that can only tolerate 15 minutes of downtime. The company also needs to migrate 10 years of historical data from an archived SQL Server backup into BigQuery for analytics. The network link is 10 Gbps. Which combination of services should the data engineer use?

Use Datastream for both the live SQL Server migration and the archived backup load into BigQuery.

Use `bcp` to export the live database and import it into Cloud SQL, and use `bq load` for the archived backup.

Use Transfer Appliance to ship the archived backup to Google Cloud, then use Database Migration Service for the live database.

Use Database Migration Service for the live SQL Server to Cloud SQL migration, and use BigQuery Data Transfer Service to load the archived backup into BigQuery.

A company is migrating its production PostgreSQL database to Cloud SQL for PostgreSQL. The database is 5 TB and is used by a critical application. The company has a 1 Gbps internet connection and cannot afford more than 10 minutes of downtime. The data changes at a rate of about 100 MB per minute. The migration must be completed within 2 weeks. What is the best approach to minimize downtime?

Use Datastream to replicate changes to Cloud SQL, then switch the application at cutover.

Use Database Migration Service to perform an initial snapshot and continuous replication, then promote the Cloud SQL instance at cutover.

Export the database with `pg_dump` and import it into Cloud SQL, then switch the application.

Use Transfer Appliance to ship the initial data, then use `pg_dump` for the final changes.

A research institution needs to migrate 2 PB of genomic research data from an on-premises tape archive to Cloud Storage. The data is stored on 100 LTO tapes. The institution has a 10 Gbps research network connection to Google Cloud. The migration must be completed within 60 days, and the data is not actively accessed during the migration. What is the most practical approach?

Use Datastream to replicate the data from the tape archive to Cloud Storage.

Use multiple Transfer Appliances to ship the data from the tapes, then copy to Cloud Storage.

Use Storage Transfer Service with the tape library as an HTTP source.

Read the tapes into a staging server and use `gsutil rsync` over the 10 Gbps connection.

Google CloudProfessional Data Engineer

Domain 1Objective 4

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

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 31–35

31foundation · easy
What types of transfers does BigQuery Data Transfer Service support?
Select an answer first
32expert · hard
A company is migrating its customer database from on-premises SQL Server to Cloud SQL for SQL Server. The database is 3 TB and is used by a critical application that can only tolerate 15 minutes of downtime. The company also needs to migrate 10 years of historical data from an archived SQL Server backup into BigQuery for analytics. The network link is 10 Gbps. Which combination of services should the data engineer use?
Select an answer first
33expert · hard
A company is migrating its production PostgreSQL database to Cloud SQL for PostgreSQL. The database is 5 TB and is used by a critical application. The company has a 1 Gbps internet connection and cannot afford more than 10 minutes of downtime. The data changes at a rate of about 100 MB per minute. The migration must be completed within 2 weeks. What is the best approach to minimize downtime?
Select an answer first
34expert · hard
A research institution needs to migrate 2 PB of genomic research data from an on-premises tape archive to Cloud Storage. The data is stored on 100 LTO tapes. The institution has a 10 Gbps research network connection to Google Cloud. The migration must be completed within 60 days, and the data is not actively accessed during the migration. What is the most practical approach?
Select an answer first
35foundation · easy
A data engineer needs to load data from Google Cloud Storage into BigQuery on a daily schedule. Which service is designed for this purpose?
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 7)

Questions 31–35

What types of transfers does BigQuery Data Transfer Service support?

A data engineer needs to load data from Google Cloud Storage into BigQuery on a daily schedule. Which service is designed for this purpose?

Keep studying — Designing data processing systems