You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.

You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.

What may be the most possible cause of this.
A . There may be a symptom on skew in your data where one of the value of the column is significantly more than rest of the values in the column
B. Your warehouses do not have enough memory
C. Since you have configured an warehouse with a low auto-suspend value, your warehouse is going
down frequently

View Answer

Answer: A

Explanation:

In the snowflake advanced architect exam, 40% of the questions will be based on work experience and this is one such question. You need to have a very good hold on the concepts of Snowflake. So, what may be happening here?