Answer-first summary for fast verification
Answer: No costs will be incurred as the query will use metadata.
The CREATE TABLE ... LIKE statement in Snowflake creates an empty copy of an existing table using only metadata operations, without processing any actual data. This means no virtual warehouse compute resources are required, and since the new table is empty initially, no storage costs are incurred. The community discussion consistently supports option C with 100% consensus and references to Snowflake documentation confirming that CREATE TABLE LIKE creates an empty table structure using metadata only. Options A, B, and D are incorrect because they imply compute or storage costs that don't apply to this metadata-only operation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the cost implications of executing the following SQL statement?
CREATE TABLE SALES_BKP LIKE SALES;
CREATE TABLE SALES_BKP LIKE SALES;
A
Processing costs will be generated based on how long the query takes.
B
Storage costs will be generated based on the size of the data.
C
No costs will be incurred as the query will use metadata.
D
The cost for running the virtual warehouse will be charged by the second.
No comments yet.