SOL-C01 Question #19: Real Exam Question with Answer & Explanation

Question

You have a permanent table 'ORDERS' in your Snowflake database. You want to create a temporary table 'TEMP ORDERS' that will automatically be dropped at the end of your session. You also want to ensure this table's data is not recoverable after the session ends. Which of the following SQL statements should you use?

Options

• ACREATE TABLE TEMP ORDERS AS SELECT FROM ORDERS;
• BCREATE TEMP TABLE TEMP ORDERS AS SELECT FROM ORDERS;
• CCREATE TRANSIENT TABLE TEMP ORDERS AS SELECT FROM ORDERS;
• DCREATE VOLATILE TABLE TEMP ORDERS AS SELECT FROM ORDERS;
• ECREATE TEMPORARY TABLE TEMP ORDERS AS SELECT FROM ORDERS;

Explanation

The correct answer is E. Snowflake uses the keyword `TEMPORARY or 'TEMP' to create a table that exists only for the duration of the session and is automatically dropped at the end of the session. The data in a temporary table is not recoverable. A creates permanent table, C create a transient table, and D - 'VOLATILE' table is not the keyword used in snowflake.

No community discussion yet for this question.