What is a core benefit of clustering?
What is a core benefit of clustering?
The core benefit of clustering is to increase scan efficiency in queries by improving pruning. Clustering helps in organizing data in a way that allows the database to more effectively skip over irrelevant data during a query. This reduces the amount of data that needs to be scanned and increases the overall efficiency of query execution.
B is correct https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html#:~:text=Using%20a%20clustering%20key%20to,in%20tables%20with%20no%20clustering.
correct answer
correct
B. To increase scan efficiency in queries by improving pruning
B is correct answer