Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 915

What is the purpose of collecting statistics on data in Snowflake?

    Correct Answer: B

    Collecting statistics on data in Snowflake mainly serves to enable efficient pruning based on query filters. These statistics inform the query optimizer about the data distribution and characteristics, allowing it to skip irrelevant micro-partitions and thereby improving query performance by reducing the amount of data that needs to be processed.

Discussion
Mike722Option: B

B. Stats help with partition pruning telling optimizer what micro-partitions to skip.

DR369Option: D

Answer- D