PDE Designing Data Processing Systems Practice Question
A company wants to use BigQuery materialized views to accelerate queries on a table that is updated every hour. Which statement about materialized views is true?
⚠ Common exam trap
PDE often tests materialized view refresh behavior and restrictions, so the trap is assuming manual refresh is required or that materialized views cannot be clustered or built on standard partitioned tables.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Materialized views are automatically updated when the base table changes.
BigQuery materialized views are automatically refreshed when the base table changes, within a bounded staleness window, so queries against them return fresh results without manual intervention. This automatic refresh is a core property that makes them suitable for accelerating queries on hourly-updated tables.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Materialized views cannot be clustered.
Why it's wrong here
BigQuery materialized views can be clustered, which reduces bytes scanned when queries filter on the clustering columns. It is tempting because clustering restrictions apply to some other object types, and that statement would be correct for those rather than for materialized views in BigQuery.
- ✗
Materialized views must be manually refreshed by the user.
Why it's wrong here
BigQuery materialized views refresh automatically, with smart tuning balancing freshness against cost, so hourly base-table updates are handled without user intervention. It is tempting because manual refresh exists for some other warehouse products, and that statement would be correct for those platforms rather than BigQuery.
- ✗
Materialized views can only be created on ingestion-time partitioned tables.
Why it's wrong here
BigQuery materialized views can be built on partitioned tables generally, including ingestion-time and column-based partitioning, not ingestion-time only. It is tempting because ingestion-time partitioning is a common pattern, and that restriction would be correct for certain legacy constructs rather than materialized views.
- ✓
Materialized views are automatically updated when the base table changes.
Why this is correct
BigQuery materialized views refresh automatically, but not instantly on every base-table change. They use a configurable refresh interval, with a default of 30 minutes, so hourly updates are covered. This satisfies the stem's hourly-update constraint without manual intervention, unlike logical views, which recompute on every query.
About these practice questions
Courseiva writes every PDE question from scratch — 747 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Google Cloud exam blueprint
This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.