Question 1

Which COPY INTOoptions can be used to load data from a staged file when the metadata in the file has expired? (Select TWO)

Options :

A : LOAD_UNCERTAIN_FILES

B : LOAD_EXPIRED_FILES

C : FORCE

D : ENFORCE_LENGTH

E : PURGE

Answer: A,C

Question 2

Which file format option should be used when unloading data into a stage to create a CSV or a JSON file?

Options :

A : PARSE_HEADER

B : TRIM_SPACE

C : FILE_EXTENSION

D : SKIP_HEADER

Answer: C

Question 3

The following settings are configured: THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level. For how many days will the data be retained at the object level?

Options :

A : 2

B : 3

C : 5

D : 7

Answer: A

Question 4

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

Options :

A :

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B :

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C :

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E :

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

Answer: A,B

Question 5

Which items are considered schema objects in Snowflake? (Select TWO).

Options :

A : Pipe

B : File format

C : Resource monitor

D : Storage integration

E : Virtual warehouse

Answer: A,B

Higher Test Marks with Free Online COF-C02 Exam Practice

Buying Options: