Databases · Middle · Question 40 of 75

What is a materialized view?

✓Correct answer: A stored query result that's fast to read but must be refreshed (REFRESH MATERIALIZED VIEW) to see new data
2A view that updates automatically on every write
3A view stored in Redis

Explanation

Good for heavy reports and dashboards. REFRESH ... CONCURRENTLY (needs a unique index) lets reads continue during the refresh.

Further reading

PostgreSQL: Materialized views ↗

Test yourself

Take the Databases · Middle quiz: questions and options are shuffled, and you get a review of your mistakes at the end.