SnowflakeSnowflake
DEA-C02 · Question #5
DEA-C02 Question #5: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.
Performance Optimization
Question
Given the table SALES which has a clustering key of column CLOSED_DATE, which table function will return the average clustering depth for the SALES_REPRESENTATIVE column for the North American region?
Options
- Aselect system$clustering_information('Sales', 'sales_representative', 'region = ''North America''');
- Bselect system$clustering_depth('Sales', 'sales_representative', 'region = ''North America''');
- Cselect system$clustering_depth('Sales', 'sales_representative') where region = 'North America';
- Dselect system$clustering_information('Sales', 'sales_representative') where region = 'North
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Snowflake Clustering#Clustering Depth#System Functions#Performance Optimization