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

True or False: It is best practice to define a clustering key on every table.

    Correct Answer: B

    It is not best practice to define a clustering key on every table. Clustering keys are useful for improving query performance by grouping related rows together, but they should be chosen based on the specific access patterns and queries of the table. For small tables or those without well-defined access patterns, clustering keys may be unnecessary and not provide any significant benefit. Therefore, clustering keys should be used judiciously rather than applied universally to every table.

Discussion
SteveCrownOption: B

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.

Mayuri917233Option: B

B is correct

Mallikharjuna452Option: B

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

MultiCloudIronManOption: B

Correct - it used for very large tables

Tapasgup007Option: B

B is correct. It is not a best practice

moon2351

Answer is correct.