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

Questions 1–5

1. 1application · medium

   A media company needs to migrate 800 TB of archived video files from a local NAS to Cloud Storage. The office has a 1 Gbps internet connection that is shared with production traffic. The migration must be completed within 30 days, and the data is not needed for active processing during the transfer. What is the most appropriate approach?

   • AUse `gsutil rsync` over a Cloud VPN connection to copy the data to Cloud Storage.
   • BUse Transfer Appliance to ship the data to Google, then copy it to Cloud Storage.
   • CUse Datastream to replicate the files continuously to Cloud Storage.
   • DUse Storage Transfer Service with a URL list pointing to the NAS over the public internet.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which Google Cloud service is used for continuous, near-real-time replication of data from source databases to Google Cloud?

   • ACloud VPN
   • BBigQuery Data Transfer Service
   • CDatastream
   • DTransfer Appliance
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A company has 500 TB of data to migrate to Google Cloud, but the network connection is too slow to transfer it in a reasonable time. Which service is most appropriate for this scenario?

   • ATransfer Appliance
   • BBigQuery Data Transfer Service
   • CDatastream
   • DDatabase Migration Service
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   A data engineer is starting a migration project and needs to understand why the business wants to move to Google Cloud and what constraints must be respected. Which activity directly addresses this need?

   • AInventorying all data sources and their dependencies in the current environment
   • BSelecting the migration strategy for each workload based on cost and performance
   • CDocumenting stakeholder needs, users, processes, and current technologies to define migration goals and constraints
   • DDefining the target architecture including storage and processing services on Google Cloud
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A healthcare provider is migrating a 2 TB MySQL database from an on-premises data center to Cloud SQL for MySQL. The database is mission-critical and can only tolerate a few minutes of downtime. The on-premises network connects to Google Cloud via a 10 Gbps Dedicated Interconnect. What is the recommended migration path?

   • AExport the database with `mysqldump` and import it into Cloud SQL using the gcloud CLI.
   • BTake a physical backup of the data directory and copy it to a Compute Engine VM, then attach it to Cloud SQL.
   • CUse Transfer Appliance to ship the database files and then load them into Cloud SQL.
   • DUse Database Migration Service to perform a continuous replication migration and then promote the Cloud SQL instance at cutover.
   Reveal Solution Discussion Select an answer first