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.
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.
Mallikharjuna452
4 months ago_yyukta
8 months, 4 weeks agoColourseun
1 year agoGwo
1 year, 1 month agoMayuri917233
1 year, 6 months agoalanhuangjob
1 year, 7 months agoRichMelbourne
1 year, 11 months agoTapasgup007
1 year, 11 months agoPercy2112
2 years, 3 months agoRajokkiyam
2 years, 9 months ago