COF-C02 Snowflake Exam Lab Questions

DESCRIBE FILE FORMAT

SHOW FILE FORMAT

LIST

SELECT $1 FROM

Structured data is supported through the use of traditional relational database tables, organized into rows and columns.

Structured and semi-structured data are stored in separate physical storage locations; users must choose which type of data to use when creating a table.

Semi-structured data is supported through the use of automatically indexed database tables.

All semi-structured data is automatically converted into structured data when it is loaded into Snowflake.

Users can load and query semi-structured data using SQL using the SQL semi-structured data handling functions.

ARRAY_CONSTRUCT('a', 'b');

TO_ARRAY('a', 'b');

AS_ARRAY('a', 'b');

LISTAGG('a', 'b');

Old partitions will not be changed to transient, but any new partitions added to the clone will follow the transient lifecycle.

Old partitions will be changed to transient, and any new partitions added to the clone will follow the transient lifecycle.

Both old and new partitions will be changed to transient, but the original table will keep the original table type.

Both old and new partitions will be changed to transient, and the original table type will change to transient.