A data engineering team manages a daily-partitioned BigQuery table named telemetry_logs. To optimize storage costs and adhere to data retention guidelines, the team needs to ensure that individual partitions are automatically deleted 60 days after their partition date, while keeping the table definition and more recent partitions intact. Which SQL statement should the team execute to configure this automated retention rule?

ALTER TABLE telemetry_logs SET OPTIONS (partition_expiration_days = 60);: ### **What `partition_expiration_days` is:** In Google BigQuery, **`partition_expiration_days`** is a table-level option that defines the lifetime of individual partitions within a partitioned table. When configured, BigQuery automatically tracks the date or timestamp associated with each partition and deletes partitions that exceed the defined age limit. ### **How it meets the requirements:** - **Automated granular cleanup (✓):** Setting `partition_expiration_days = 60` ensures that BigQuery automatically removes partition slices older than 60 days without requiring scheduled manual `DELETE` jobs or custom scripts. - **Preserves table structure (✓):** Only expired partitions are removed; the table itself, its schema, and newer partitions remain completely intact and queryable. - **Cost reduction (✓):** Automatically purging historical partitions decreases the active storage volume in BigQuery, directly lowering long-term storage expenses. ### **Key capabilities of partition expiration:** - **Continuous evaluation:** BigQuery continuously checks the partition date against UTC time and removes outdated partitions automatically. - **Table-level override:** Applying partition expiration directly to a table overrides any default dataset-level partition expiration settings. - **SQL DDL support:** The configuration can be updated dynamically at any time using standard `ALTER TABLE ... SET OPTIONS` syntax. - **Support for various partition types:** Works seamlessly on ingestion-time partitioned, date/timestamp partitioned, and integer-range partitioned tables. ### **Why this is optimal:** Modifying the table options via SQL DDL provides a native, serverless, and declarative approach to lifecycle management. It eliminates the computational costs of running daily deletion queries and ensures reliable enforcement of organizational retention policies.

Bigquery Partition Expiration Sql Configuration | Unlock the power of your data in the cloud! Get hands-on with Google Cloud's core data services like BigQuery and Looker to validate your practical skills in data ingestion, analysis, and management, and earn your Associate Data Practitioner certification!

FundamentalAssociate Data Practitioner

A data engineering team at a retail organization uploads daily transaction log files into a Google Cloud Storage bucket. To minimize storage costs and comply with internal data retention guidelines, the team needs to automatically delete log files once they are 30 days old. Which method should the team use to configure and manage automated object deletion on the Cloud Storage bucket?

Configure rules to delete objects after a specified period to automatically remove unnecessary data and reduce storage expenses (e.g., BigQuery, Cloud Storage)

FundamentalAssociate Data Practitioner

A media analytics organization stores daily application log files in a Google Cloud Storage bucket. Due to data compliance and cost-optimization policies, the organization requires log files to be automatically deleted once they reach 30 days of age, without requiring manual intervention or custom maintenance scripts. Which Cloud Storage feature should you configure to satisfy this requirement?

FundamentalAssociate Data Practitioner

An organization is designing a data pipeline to process marketing analytics data collected from external advertising platforms. The analytics team wants to load the raw data directly into the cloud data warehouse first without pre-processing it in transit, and then use SQL scripts and Dataform to clean, model, and aggregate the data inside the warehouse. Which data integration pattern and Google Cloud service strategy should the team implement?

FundamentalAssociate Data Practitioner

A data analyst has trained a classification model named customer_churn_model using BigQuery ML to predict customer attrition. The analyst now needs to generate batch predictions on a new dataset of current subscribers stored in a table named active_customers and output the predicted labels alongside customer identifiers for a marketing campaign. Which BigQuery ML function should the analyst use to execute these predictions?

FundamentalAssociate Data Practitioner

A data engineering team is creating several new Google Cloud Storage buckets to store sensitive customer transaction records. To comply with internal security policies, the team must ensure that permissions are managed consistently across all objects in a bucket using only Cloud Identity and Access Management (Cloud IAM) policies, while completely disabling individual object-level Access Control Lists (ACLs). Which Cloud Storage access control configuration should the team implement?

AdvancedProfessional Cloud Security Engineer

An enterprise hosts its primary domain in a Google Cloud DNS public managed zone. A security engineer must configure Domain Name System Security Extensions (DNSSEC) to protect client resolvers from DNS spoofing and cache poisoning attacks. The solution must establish a verified chain of trust with the third-party domain registrar and define a zero-downtime rotation procedure for the Key Signing Key (KSK). Which procedure should the security engineer implement?

Associate Data Practitioner

Bigquery Partition Expiration Sql Configuration

Related questions