Which command below will you choose?

You have created a table as below

CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP );

Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE.

Which command below will you choose?
A . ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR)
B. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR, BLOG_CREATE_DATE);
C. ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_CREATE_DATE);

View Answer

Answer: B

Explanation:

The question may not come this way. But please try this out by following the below steps 1. Create the table first

CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP ); 2. Create the cluster keys by running the below two queries

ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_AUTHOR); ALTER TABLE SNOWFLAKE_BLOG CLUSTER BY (BLOG_CREATE_DATE);

Did you see that the last command replaced the cluster key from BLOG_AUTHOR to

BLOG_CREATE_DATE.

So, what did you learn?