Materialized view patterns, trade-offs, and when to use each on SQL Server/Azure SQL and .NET

What do we mean by “materialized view” on Azure SQL? SQL Server/Azure SQL doesn’t have Oracle-style materialized views; the closest native feature is an Indexed View (schema-bound view with a clustere