Snowflake Updated COF-C02 Exam Questions and Answers by arlo-james

 To use Partner Connect, the ACCOUNTADMIN role is required. Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake

 When a view is defined on a permanent table, and a temporary table with the same name is created in the same schema, the query from the view will return the data from the permanent table. Temporary tables are session-specific and do not affect the data returned by views defined on permanent tables2.

 According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts. References: Based on my internal knowledge as of 2021.

The FIELD_OPTIONALLY_ENCLOSED_BY option in the COPY INTO command specifies how fields are optionally enclosed when unloading data.

Valid values are:

Single quote ('): Specifies that fields are enclosed in single quotes.

NULL: Specifies no enclosure for fields.

Examples:

COPY INTO 's3://mybucket/mypath/'

FROM my_table

FILE_FORMAT = (TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = '''');

COPY INTO 's3://mybucket/mypath/'

FROM my_table

FILE_FORMAT = (TYPE = CSV FIELD_OPTIONALLY_ENCLOSED_BY = NULL);

References:

Snowflake Documentation: COPY INTO

Snowflake File Format Options