exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 299 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 299
Topic #: 1
[All SnowPro Core Questions]

A user executes the following SQL query:

create table SALES_BKP like SALES;

What are the cost implications for processing this query?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
halol
Highly Voted 1 year, 11 months ago
Snowflake SQL provides “CREATE TABLE LIKE” statement to create a new table with just the structure of the existing table without copying the data. So I think it's C
upvoted 9 times
...
KeshavaMugulur
Highly Voted 1 year, 11 months ago
C is right.
upvoted 9 times
...
_yyukta
Most Recent 8 months, 2 weeks ago
Selected Answer: C
C is correct
upvoted 1 times
...
Marge23
1 year, 1 month ago
Selected Answer: C
CREATE TABLE … LIKE (creates an empty copy of an existing table) https://docs.snowflake.com/en/sql-reference/sql/create-table
upvoted 2 times
...
MultiCloudIronMan
1 year, 4 months ago
Selected Answer: C
Correct
upvoted 1 times
...
shyemko
1 year, 7 months ago
Selected Answer: C
CREATE TABLE … LIKE (creates an empty copy of an existing table) source : https://docs.snowflake.com/en/sql-reference/sql/create-table
upvoted 2 times
...
tpiscaglia
1 year, 7 months ago
Selected Answer: C
CREATE TABLE LIKE creates an empty copy. It should use only metadata to create so it shouldn't need a warehouse/compute or storage. https://docs.snowflake.com/en/sql-reference/sql/create-table#create-table-like
upvoted 1 times
...
EmiB
1 year, 8 months ago
Selected Answer: C
CREATE TABLE … AS SELECT (creates a populated table; also referred to as CTAS) CREATE TABLE … USING TEMPLATE (creates a table with the column definitions derived from a set of staged files) CREATE TABLE … LIKE (creates an empty copy of an existing table) CREATE TABLE … CLONE (creates a clone of an existing table)
upvoted 4 times
...
OTE
1 year, 8 months ago
Selected Answer: C
should be C
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago