Snowflake Updated COF-C02 Exam Questions and Answers by evie-mae

A single data type, with one or more conditions, and one or more masking functions

A single data type, with only one condition, and only one masking function

Multiple data types, with only one condition, and one or more masking functions

Multiple data types, with one or more conditions, and one or more masking functions

Temporary tables

Permanent tables

Transient tables

External tables

User-Defined Table Functions (UDTFs)

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

Use COPY INTO followed by a GET command to download the file.

Use COPY INTO followed by a put command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO with SINGLE = TRUE followed by a PUT command to download the file.