professional-cloud-data-engineer
Prepare and test your skills
Prepare and test your skills
Data access patterns describe how frequently and predictably applications read and write stored data over time. In Google Cloud Storage, matching these access patterns to the correct storage class allows systems to minimize storage expenses while delivering the required throughput and latency. Automated tools like Object Lifecycle Management and Autoclass inspect object ages or observed access patterns to transition data between classes automatically. This automation ensures workloads do not pay for high-performance storage on dormant datasets.
Network egress costs occur whenever data moves out of a Google Cloud region or across network boundaries to the public internet. Organizations lower these transfer fees by placing storage buckets in the same geographical region as the compute workloads and end users that query them. Within a Virtual Private Cloud (VPC) network, enabling Private Google Access allows virtual machine (VM) instances with private internal IP addresses to reach Google APIs and storage buckets directly without routing traffic over the public internet. Network administrators configure firewall rules allowing outbound traffic to designated Google service IP ranges, such as 199.36.153.8/30, and establish private DNS zones to keep storage traffic within the private network backbone.
Multi-regional distribution provides high availability (HA) and disaster recovery (DR) by copying data across multiple distinct geographical locations. Teams configure cross-bucket replication using the Storage Transfer Service to automatically replicate data from a primary source bucket to a secondary destination bucket in a separate region. This replication model introduces replication latency, which is the time delay required for a write in the source bucket to become visible in the destination bucket. To satisfy business Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO), systems balance the higher cost of multi-regional replication against the risk of regional downtime.
Cross-region replication workflows depend on specific Identity and Access Management (IAM) permissions granted to dedicated service accounts. The service account assigned to the replication service must hold the Storage Object Viewer role on the source bucket to read objects and the Storage Legacy Bucket Writer role on the destination bucket to write replicas. Without these paired IAM roles, automated replication fails across region boundaries. Correctly provisioning these roles enables secure, automated data synchronization between source and target buckets.
Exam tip: Enabling Private Google Access allows private VPC resources to reach Google Cloud Storage APIs without traversing the public internet, avoiding external data egress pathways.
Object storage tiering optimizes total cost of ownership by placing data into distinct Google Cloud Storage classes based on retrieval frequency and minimum storage duration rules. The four primary storage classes are Standard, Nearline, Coldline, and Archive, which trade lower monthly storage costs for higher retrieval fees and longer commitment windows. Choosing the appropriate class ensures that high-priority workloads achieve low-latency access while long-term archive data incurs minimal ongoing maintenance costs.
| Storage Class | Target Access Frequency | Minimum Duration | Primary Use Case |
|---|---|---|---|
| Standard | Multiple times per month or daily | None | Active data lakes, real-time analytics, and serving web assets |
| Nearline | At most once per month | 30 days | Monthly backups and regular disaster recovery stress tests |
| Coldline | Less than once per quarter | 90 days | Quarterly disaster recovery archives and rarely modified backups |
| Archive | Less than once per year | 365 days | Long-term digital preservation and regulatory compliance data |
Lifecycle management policies automate transitions between storage classes to reduce manual administrative overhead. When an object ages past a defined threshold, a lifecycle rule can move the object from Standard storage down to Nearline, Coldline, or Archive storage. However, organizations must account for early deletion penalties, which Google Cloud applies if an object is deleted, overwritten, or transitioned before completing the minimum storage duration of its current class. For example, deleting a file stored in Nearline storage after only 10 days incurs an early deletion fee equal to the remaining 20 days of storage costs.
A lifecycle diagram showing objects starting in Standard storage and being automatically transitioned by Object Lifecycle Management or Autoclass through Nearline, Coldline, and Archive classes as they age, with each class's minimum storage duration shown. A dashed red branch from Nearline illustrates the early deletion penalty charged when an object is deleted before its 30-day minimum duration expires.
Exam tip: Deleting, modifying, or rewriting an object before its class's minimum storage duration expires triggers an early deletion charge for the remaining duration.
Managing costs and performance across structured and semi-structured storage systems requires aligning data storage models with compute capacity. Google Cloud databases decouple compute power from persistent storage or provide granular scaling controls to prevent organizations from paying for idle resources. This separation allows storage volume to scale to petabytes independently of compute cluster sizing.
BigQuery manages costs by separating compute resources from underlying storage, allowing data volumes to grow without forcing an increase in processing capacity. Under on-demand query pricing, query costs depend directly on the volume of bytes scanned by the execution engine. Organizations control these scan volumes through specific architectural mechanics:
Operational database systems like Cloud Bigtable and Cloud Spanner manage cost and throughput by scaling processing nodes independently of total stored data. Cloud Bigtable delivers linear performance scaling based on cluster node count, allowing teams to scale down compute nodes during off-peak hours to maintain an efficient compute-to-storage ratio. Bigtable also supports dynamic autoscaling to adjust node counts automatically based on CPU utilization metrics without causing downtime.
Administrators evaluate two physical storage media options when creating Bigtable clusters:
Exam tip: BigQuery on-demand query costs depend on the number of bytes scanned, which can be minimized by combining table partitioning for query pruning with column clustering.
Standard storage has no minimum duration, while Nearline requires 30 days, Coldline requires 90 days, and Archive requires 365 days. Deleting, overwriting, or transitioning an object before its class completes this minimum duration incurs an early deletion fee equal to the cost of the remaining days.
Automated cross-bucket replication requires assigning the Storage Object Viewer role on the primary source bucket and the Storage Legacy Bucket Writer role on the secondary destination bucket to the replication service account. Without these paired roles, the automated replication workflow cannot read source objects or write replicas across regions.
Partitioning divides tables into smaller segments by date, timestamp, or integer ranges to enable query pruning, allowing BigQuery to skip unread partitions. Clustering colocates related rows within storage blocks based on specified column values, which accelerates filter operations and reduces the total volume of bytes scanned.
Cloud Bigtable clusters should use standard SSD storage for high-throughput workloads that require ultra-low latency for random reads and writes. HDD storage is designed for large volumes of infrequently accessed key-value data where sub-millisecond latency is not necessary.
An enterprise runs an online transaction processing (OLTP) database on Cloud SQL in us-central1. The engineering team is designing a disaster recovery (DR) and global read-scaling architecture for downstream analytics and regional services located in europe-west1.
The architecture must satisfy the following criteria:
Which strategy should the data engineering team implement?
Keep all database instances solely in us-central1 with High Availability (HA) enabled across two zones, and configure European analytical clients to query the standby instance directly over Cloud Interconnect.
Deploy a minimal shared-core read replica in europe-west1 and route both write transactions and heavy analytical read queries through a single Cloud SQL Auth Proxy located in us-central1.
Configure automated hourly Cloud SQL export dumps to a multi-region Cloud Storage bucket in Europe, and restore the bucket dump to a new Cloud SQL instance whenever European analytics runs.
Deploy a cross-region read replica in europe-west1, direct European analytical read queries to this replica, and resize the replica's compute resources to match the primary while breaking bulk transactional updates into smaller batches.