Which snowflake objects will incur both storage and cloud compute charges? (Choose two.)
Which snowflake objects will incur both storage and cloud compute charges? (Choose two.)
Materialized views incur storage charges because they store the query results, and they incur compute charges because the view needs to be refreshed whenever the underlying data changes. Transient tables incur storage charges because they store data and incur compute charges due to the costs associated with querying and maintaining the table.
I think it is A and E. Clustered table needs to undergo clustering as the data changes and Materialized view also undergoes changes every time the underlying data changes or when the view is set to refresh.
The question doesn't say in which situation incur compute cost. Storage cost - Permanent, Temporary, Transient, MV Compute - creation, maintanance, query ?
correct
normally, transient table also