Correct Answer: The data in a table (or partition) must not have been modified for 90 consecutive days
BigQuery automatically drops the storage price by ~50% for data that hasn't been modified in 90 days, without a change in query performance or availability....
Correct Answer
The data in a table (or partition) must not have been modified for 90 consecutive days
Why This Answer Is Correct
BigQuery automatically drops the storage price by ~50% for data that hasn't been modified in 90 days, without a change in query performance or availability.
This question evaluates your knowledge of BigQuery — a core concept tested in Professional Cloud Architect. Understanding BigQuery is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
You are analyzing petabytes of data for business intelligence reports. You need a fully managed, serverless enterprise data warehouse that supports SQL queries. Which service is best suited for this task?
A data analytics team needs to process streaming data from millions of IoT devices. The data arrives at unpredictable intervals and must be analyzed in real-time before being stored in BigQuery. Which architecture is most scalable and cost-effective?
A data warehouse team needs to join data from BigQuery with data stored in a Cloud SQL PostgreSQL instance in real-time. Which BigQuery feature allows this federated query without moving the data?
Your data science team wants to use SQL to build and deploy a machine learning model for predicting customer churn directly where the data resides. They want to avoid complex ETL and data movement. Which service should they use?
To optimize costs for a BigQuery project, you want to identify which queries are consuming the most 'Slots' and which datasets are never accessed. Which tool should you use?