Are dynamic tables similar to the classic materialized view?

There are some similarities. Dynamic tables support a much wider set of query constructs than Snowflake's materialized views, and have the TARGET_LAG parameter that Saras just mentioned. DTs are for building data pipelines, and MVs are for optimizing specific query patterns.