Which Snowflake object creates a materialized data result derived from two tables while automatically tracking...

A dynamic table stores the result of a query and refreshes that result automatically according to its target lag and refresh configuration. Snowflake tracks dependencies between dynamic tables and their source objects, allowing developers to build multi-level transformation pipelines without manually scheduling every dependency.

A dynamic table query can use data from multiple supported source tables.

A materialized view has more restrictive query-definition requirements and is not the general multi-table pipeline object intended by this question. A stream records change-tracking information for a source object but does not independently execute and maintain a multi-table transformation. A transient table is a table-storage type and does not automatically track or refresh transformation dependencies.