An existing clustering key is copied in which of the below scenarios

An existing clustering key is copied in which of the below scenarios
A . CREATE TABLE…CLONE
B. CREATE TABLE…LIKE
C. CREATE TABLE…AS SELECT

View Answer

Answer: A

Explanation

https://docs.snowflake.com/en/sql-reference/functions/system_estimate_search_optimization_costs.html#out

put

BuildCosts

This object describes the predicted costs of building the search access path for the table. If search optimization has already been added to the table, this object contains no cost information. StorageCosts

This object describes the predicted amount of storage space (in TB) needed for the search access path for the table. If search optimization has already been added to the table, this object shows the current amount of space used by the search access path.

Benefit

This object does not contain any cost information at this time.

MaintenanceCosts

This object describes the predicted costs of maintaining the search access path for the table. If this table has been created recently, this object does not contain any cost information.