Snowflake, tables are logical structures that represent the data stored in the underlying cloud storage . Snowflake manages the physical storage and optimization of the data transparently.
The best statement that describes Snowflake tables is Snowflake tables are logical representations of underlying physical data.
Snowflake tables do not require that clustering keys be defined to perform optimally. However, defining clustering keys can improve the performance of queries that filter or sort the data.
Snowflake tables can be owned by a user or by a role.
Therefore, the correct answer is
A. Snowflake tables are logical representations of underlying physical data.
C seems correct too. Snowflake tables require clustering keys to perform optimally. Clustering keys help manage micro partitions for a table, which in turn helps in query performance by means of partition pruning.
Clustering is defined automatically by SF, not by the user, and clustering is an output of MPs, which are based on contiguous records. You can overwrite clustering keys but it is not recommended.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sudhansu21
3 days, 2 hours agoMallikharjuna452
7 months, 1 week ago_yyukta
12 months agoColourseun
1 year, 3 months agoGwo
1 year, 4 months ago56d43d6
1 month, 3 weeks agoMayuri917233
1 year, 9 months agoalanhuangjob
1 year, 10 months agoRichMelbourne
2 years, 2 months agoTapasgup007
2 years, 2 months agoPercy2112
2 years, 6 months agoRajokkiyam
3 years ago