Intrigued by the art of cloud architecture? Discover how to design, develop, and manage robust, secure, scalable, and dynamic solutions on Google Cloud as you prepare for the Professional Cloud Architect exam!
Prepare and test your skills
Prepare and test your skills
Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.
Keep the momentum going with these hand-picked practice scenarios
Want more questions like this?
Get a free certification question every week.
Last updated
A financial analytics company ingests terabytes of transaction logs daily into Google Cloud. Analysts frequently query recent log data within a 30-day window, but analytical queries occasionally analyze records up to 90 days old. Logs older than 90 days are no longer queried in the data warehouse and must automatically expire to control operational expenditure. Additionally, raw audit files stored in Cloud Storage must be preserved for three years for compliance, transitioning automatically to lower-cost storage tiers as access frequency declines.
Which storage and lifecycle design should the cloud architect implement to balance query performance, data availability, and cost?
Create a nonpartitioned BigQuery table managed by scheduled SQL queries executing DELETE statements, and enable Cloud Storage soft delete with a 3-year retention duration.
Configure BigQuery clustering on the timestamp column without partitioning, and deploy a Cloud Run function that copies objects between separate regional buckets for each storage class.
Configure a timestamp-partitioned BigQuery table with partition expiration set to 90 days, and apply a Cloud Storage Object Lifecycle Management policy to transition raw audit files from Standard to Nearline, Coldline, and Archive storage classes.
Create a BigLake Iceberg table in BigQuery with partition expiration configured, and enable hierarchical namespaces on the Cloud Storage bucket to automatically manage storage tiers.
Create a nonpartitioned BigQuery table managed by scheduled SQL queries executing DELETE statements, and enable Cloud Storage soft delete with a 3-year retention duration.
Configure BigQuery clustering on the timestamp column without partitioning, and deploy a Cloud Run function that copies objects between separate regional buckets for each storage class.
Configure a timestamp-partitioned BigQuery table with partition expiration set to 90 days, and apply a Cloud Storage Object Lifecycle Management policy to transition raw audit files from Standard to Nearline, Coldline, and Archive storage classes.
This architecture combines BigQuery partition-level expiration with Cloud Storage Object Lifecycle Management (OLM) to automate data retention and tiered storage across analytics and object storage systems.
StudyCerts
StudyCertspartition_expiration_days = 90 ensures that individual partition slices automatically expire and are deleted once they reach 90 days, eliminating unnecessary data warehouse storage costs without requiring scheduled deletion scripts.Native BigQuery partition expiration combined with Cloud Storage Object Lifecycle Management provides a fully managed, serverless lifecycle tiering framework that requires zero custom operational compute infrastructure.
Create a BigLake Iceberg table in BigQuery with partition expiration configured, and enable hierarchical namespaces on the Cloud Storage bucket to automatically manage storage tiers.