Examkin

Question

Difficulty: MediumDesigning Infrastructure for Business Requirements and Cost Optimization

An international media organization is migrating its digital asset management platform to Google Cloud. The architecture requires a single-region relational database (400 GB size) for content metadata that supports standard SQL queries and high availability (HA). Additionally, the organization needs to transfer 800 TB of legacy video archives from an on-premises data center to Cloud Storage Coldline within a 2-week migration window, but their available internet connection bandwidth is capped at 100 Mbps.

To minimize baseline operational costs while satisfying all technical and timeframe requirements, which TWO architectural decisions should you recommend? (Select TWO.)

  1. Provision Cloud SQL for MySQL configured with High Availability (HA) for the relational metadata database.Answer
  2. Order a Google Cloud Transfer Appliance to ingest the 800 TB historical video archive offline and ship it for data upload.Answer
  3. C
    Deploy a multi-zone Cloud Spanner instance to host the relational metadata database.
  4. D
    Configure Storage Transfer Service to stream the 800 TB of video files directly over the 100 Mbps internet connection.

Answer

The organization should provision Cloud SQL for MySQL configured with High Availability for the database workload, and order a Google Cloud Transfer Appliance to transfer the 800 TB video archive offline.
Provisioning Cloud SQL for MySQL with High Availability fulfills single-region HA relational database requirements while keeping baseline infrastructure costs low compared to enterprise multi-region databases. Utilizing a Google Cloud Transfer Appliance provides an offline migration path capable of transferring 800 TB within the requested 2-week window, bypassing the throughput limitations of a 100 Mbps link.

Step-by-Step Solution

1
Evaluate relational database requirements and cost implications.
Cloud SQL supports regional HA workloads up to several terabytes cost-effectively, whereas Cloud Spanner introduces unnecessary cost for non-global, sub-terabyte relational needs.
Choosing Cloud SQL satisfies the high availability and SQL requirement without incurring Cloud Spanner baseline multi-node costs.
2
Calculate data transfer rate capabilities over the 100 Mbps WAN connection.
At a maximum theoretical bandwidth of 100 Mbps (12.5 MB/s12.5\text{ MB/s}), transferring 800 TB800\text{ TB} (800,000,000 MB800,000,000\text{ MB}) requires approximately 64,000,000 seconds (740 days740\text{ days}), exceeding the 2-week limit.
Online migration via Storage Transfer Service is infeasible, necessitating an offline appliance transfer.
3
Select appropriate offline migration tooling.
Google Cloud Transfer Appliance allows rackable appliance data capture on-premises and physical shipment to Google for rapid ingestion.
Transfer Appliance meets the 2-week completion requirement cost-effectively.

Key Concept

Cost-Optimized Database Selection and Large-Scale Offline Data Migration
Rate this question

Topics

Designing Infrastructure for Business Requirements and Cost Optimization