Prepare and test your skills

Prepare and test your skills

Free sample question, answered and explained below. The Professional Data Engineer practice bank has 1,353 more like it. Try 10 free: instant score, no account.
An enterprise is planning a multi-workload migration strategy to Google Cloud and must select the optimal data transfer mechanisms based on data source type, transfer volume, and network availability:
Which combination of services should the organization select for these workloads?
This architecture uses Transfer Appliance for high-volume offline physical data transport, Database Migration Service (DMS) for minimal-downtime relational database replication, and BigQuery Data Transfer Service (DTS) for scheduled, managed SaaS analytics ingestion.
Each selected tool maps directly to the specific data volume, change velocity, and network profile of the respective workload.
This option proposes using Storage Transfer Service on-premises agents over the existing network for the 350 TB archive, BigQuery Data Transfer Service for the transactional PostgreSQL database migration, and Cloud Data Fusion for daily SaaS reporting ingestion.
Workload 1 had a dedicated multi-gigabit Cloud Interconnect and Workload 2 targeted BigQuery for OLAP analytics rather than Cloud SQL for transactional workloads.
This option selects the gcloud storage CLI for multi-threaded file uploads over the network for Workload 1, alongside Database Migration Service for Workload 2 and BigQuery Data Transfer Service for Workload 3.
gcloud storage supports parallel multi-threaded uploads and error recovery, it is strictly constrained by available network bandwidth. Uploading 350 TB through a 100 Mbps uplink is physically impossible within the mandatory two-week window.gcloud storage tool is recommended for small-to-medium transfers or situations with high available bandwidth, not large-scale offline scenarios.Workload 1 involved a few gigabytes or terabytes of data with a multi-gigabit connection where online CLI scripts could easily meet the transfer timeline.
This combination selects Transfer Appliance for the physical archive, Datastream directly into BigQuery for the operational PostgreSQL database, and Storage Transfer Service for SaaS reporting.
Workload 2 required real-time CDC replication into an analytical data lake/warehouse and Workload 3 involved transferring large raw object buckets from Amazon S3.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated Validated