Exam SnowPro Core topic 1 question 93 discussion

NO,It is recommended to use on very large tables(> 1 TB)

Correct - it used for very large tables

B is correct

Answer: B It is not always best practice in Snowflake to define a clustering key on every table. Clustering keys are used to group related rows physically together in a table, which can improve query performance by minimizing the amount of data that needs to be scanned or skipped during query execution. However, clustering keys should be chosen carefully based on the access patterns of the table, and the type of queries that will be run against it. Defining a clustering key on every table may not always be necessary or beneficial. For example, in some cases, tables may be small or may not have well-defined access patterns, making clustering unnecessary. In other cases, tables may be loaded in a specific order or partitioned in a certain way that obviates the need for clustering. Therefore, it is not a best practice to define a clustering key on every table in Snowflake, but rather to carefully consider the access patterns and usage of each table, and to choose clustering keys judiciously based on those factors.

B is correct. It is not a best practice

Answer is correct.