Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 5 of 38
Free Preview · 38 of 126 · questions 1–38 of 126 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Both will work. Depth is more precise and only shows the depth. Information will show many other properties
Both A & B will give average depth. I will go with B as it only provides the average depth. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions select system$clustering_depth('GOOGLE_ADS_DEMO.CLICK_PERFORMANCE','CAMPAIGN_ID', 'AD_GROUP_ID=''broccoli'''); The information schema will provide more information like histogram etc.
Both A & B will give average depth. I will go with B as it only provides the average depth. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions select system$clustering_depth('GOOGLE_ADS_DEMO.CLICK_PERFORMANCE','CAMPAIGN_ID', 'AD_GROUP_ID=''broccoli'''); The information schema will provide more information like histogram etc.