Does the statement CREATE OR REPLACE TABLE MYTABLE LIKE MY_TABLE cost compute credits?

• A. True
• B. False
• C. Only if the source table contains data
• D. It always uses credits

Answer: (B)

This operation creates a new table by duplicating the existing table’s schema and metadata, without copying any actual data. Because nothing is read from the source table and no data is moved or processed, there is no data scanning or heavy compute involved. It’s a metadata-only change, so it doesn’t trigger the kind of compute work you’d see when querying or loading data. If you instead used a statement that selects data from the source (for example, creating a table as select), that would involve reading the data and would use compute credits. In short, creating a table with LIKE copies the structure only, so it does not cost compute credits.