CertKeen

Google Cloud Professional Cloud Architect · Free practice question 5 of 12

BigQuery long-term storage pricing

Melrose Analytics keeps five years of event data in BigQuery. Most partitions are older than a year and are never modified, though they are queried occasionally. The finance team asks how to reduce storage costs without changing query patterns. What should the architect explain?

  1. A.Older partitions must be exported to Cloud Storage Archive class before any storage discount applies to them, then queried as external tables
  2. B.Old partitions must be copied into a new dataset marked as archival
  3. C.A long-term storage reservation must be purchased each year to receive the lower rate
  4. D.Partitions unmodified for 90 consecutive days are billed at the lower long-term rate automatically, with no query impact
Show answer and explanation

Correct answer: D. Partitions unmodified for 90 consecutive days are billed at the lower long-term rate automatically, with no query impact

Why: BigQuery automatically applies long-term storage pricing to tables or partitions that have not been modified for 90 consecutive days, and query performance and cost are unchanged. Exporting to Cloud Storage makes the data harder to query. There is no reservation or archival dataset flag to buy or set for this discount.

More free Google Cloud Professional Cloud Architect questions