All challenges
Multiple ChoiceHard 30s

Materialized views

Choose the best answer for: materialized views
Options
  1. 1Views computed at query time from base tables
  2. 2Queries cached in memory until the next restart
  3. 3Stored query results refreshed periodically
  4. 4Tables duplicated across nodes for read scale

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle