Question

Difficulty: MediumEstimating GCP Costs with the Pricing Calculator

A cloud architecture team is using the Google Cloud Pricing Calculator to estimate monthly expenses for a new enterprise analytical application. The planned architecture includes a Cloud SQL for PostgreSQL database configured with High Availability (HA) and a Cloud Pub/Sub message broker that ingests streaming telemetry from client applications across multiple geographic regions. Which TWO configuration options or cost parameters must be explicitly specified in the Google Cloud Pricing Calculator to produce an accurate monthly estimate?

  1. The storage capacity and regional failover replication settings for the High Availability Cloud SQL instanceAnswer
  2. Network egress data transfer volumes generated when delivering messages across regional boundariesAnswer
  3. C
    Automatic 3-year Committed Use Discounts without selecting an explicit commitment term in the calculator tool
  4. D
    Spot VM provisioning options for the primary managed Cloud SQL database instance

Answer

Accurate cost estimation in the Google Cloud Pricing Calculator requires configuring the Cloud SQL High Availability storage and regional failover replication settings, as well as accounting for cross-region network egress data volumes generated by Cloud Pub/Sub telemetry stream delivery.
Configuring High Availability for Cloud SQL doubles the database instance and storage resource allocation due to active-standby zonal replication. Additionally, streaming data across GCP region boundaries incurs inter-region egress charges that must be calculated in the pricing calculator using estimated monthly data throughput.

Step-by-Step Solution

1
Analyze the Cloud SQL requirements for cost modeling in the pricing calculator
Identify that High Availability (HA) provisions both a primary and standby instance along with replicated storage, which must be selected in the calculator.
Cloud SQL HA configuration impacts both database compute instance costs and storage capacity pricing.
2
Analyze the networking and messaging components for hidden operational costs
Identify inter-region and internet egress data transfer requirements for Cloud Pub/Sub cross-region messaging.
Data transfer out of a GCP region is billed per gigabyte and must be explicitly estimated in the pricing calculator.
3
Evaluate and discard invalid pricing model assumptions
Reject automatic CUD application and Spot VM options for stateful database tiers.
CUDs require explicit term configuration in the tool, and Cloud SQL does not run on Spot/Preemptible VMs.

Key Concept

Multi-component GCP cost estimation involving managed database HA replication and cross-region egress networking parameters.
Estimated Time:1m 30s
Rate this question