Pre-Winter Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Snowflake SnowPro Advanced: Data Analyst Exam DAA-C01 Question # 9 Topic 1 Discussion

Snowflake SnowPro Advanced: Data Analyst Exam DAA-C01 Question # 9 Topic 1 Discussion

DAA-C01 Exam Topic 1 Question 9 Discussion:
Question #: 9
Topic #: 1

Which query will provide this data without incurring additional storage costs?


A.

CREATE TABLE DEV.PUBLIC.TRANS_HIST LIKE PROD.PUBLIC.TRANS_HIST;


B.

CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST);


C.

CREATE TABLE DEV.PUBLIC.TRANS_HIST CLONE PROD.PUBLIC.TRANS_HIST;


D.

CREATE TABLE DEV.PUBLIC.TRANS_HIST AS (SELECT * FROM PROD.PUBLIC.TRANS_HIST WHERE extract(year from (TRANS_DATE)) = 2019);


Get Premium DAA-C01 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.