Can we create materialized views without any additional cost?

• A. True
• B. False
• C. They incur storage costs
• D. They incur no compute costs

Answer: (B)

Materialized views involve storing the precomputed results, so you incur storage costs for the materialized data. They also require compute resources to build the view initially and to refresh it as underlying data changes. Because of both storage and compute needs, you cannot create a materialized view without any additional cost.