SnowPro Core Certification — Question 298

A user executes the following SQL query:

create table SALES_BKP like SALES;

What are the cost implications for processing this query?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because the command creates a new table based on the structure of an existing table, utilizing metadata without affecting data storage. Options A and B are incorrect as they suggest costs related to query duration and data size, which do not apply in this scenario. Option D is also incorrect because it refers to charges for the virtual warehouse, which are not incurred when the query only accesses metadata.