Which command below will load data from result_scan to a table?

Which command below will load data from result_scan to a table?
A . CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from table(result_scan(last_query_id()));
B. CREATE OR REPLACE TABLE STORE_FROM_RESULT_SCAN AS select * from result_scan(last_query_id());
C. INSERT INTO STORE_FROM_RESULT_SCAN select * from result_scan(last_query_id());

View Answer

Answer: A

Explanation:

RESULT_SCAN is a system defined table function in snowflake. It returns the result set of a previous

command (within 24 hours of when you executed the query) as if the result was a table. https://docs.snowflake.com/en/sql-reference/functions/result_scan.html#result-scan