Please select what Alex is doing wrong here?

group by m.item_id;

Step 3: After 1 hour, he decided to temporarily suspend the use (and maintenance) of the DataReportMV materialized view for cost saving purpose.

alter materialized view DataReportMV suspend;

Please select what Alex is doing wrong here?
A . A materialized view, DataReportMV does not support Join operations, so Step 2 would be failed & he cannot proceed further.
B . Materialized view on top of External tables is not supported feature.
C . Once DataReportMV got suspended, any query on the top of the view will generate error like: Failure during expansion of view ‘DATAREPORTMV’: SQL compilation error: Materialized view DataReportMV is invalid.
D . There is no command like suspend for temporarily suspension of Materialized views, Step 3 will
give error like invalid Suspend command.
E . Alex is doing everything correct.

View Answer

Answer: B,D

Explanation:

B. As of my last training data, Snowflake does not support creating materialized views on external tables. Materialized views are typically built on native Snowflake tables or views.

D. There’s no "suspend" command for materialized views in Snowflake. Materialized views in Snowflake automatically stay up-to-date as the underlying data changes without the need to manually refresh, so there’s no need for a "suspend" operation.