GCP Associate Cloud Engineer Practice Question

Creating a time-partitioned table on the event_date column means BigQuery automatically places each day's data in its own partition as it is loaded, so no extra tables or manual maintenance are required. Queries that filter on a seven-day window scan only those partitions, dramatically reducing the number of bytes read and therefore cost. Clustering the same table by user_id further prunes blocks inside the selected partitions, accelerating common user-centric queries. The other options either scan the entire table (unpartitioned), require manual table management (daily sharded tables), or add an unrelated feature (BI Engine) without addressing cost from unnecessary data scans.