SnowPro-Core Snowflake Exam Questions and Free Practice Test

A. Use the DROP <file> command after the load completes.

B. Specify the TEMPORARY option when creating the file format.

C. Specify the PURGE copy option in the COPY INTO

command.

D. Use the REMOVE command after the load completes.

E. Use the DELETE LOAD HISTORY command after the load completes.

Correct Answer:CD

- (Exam Topic 1)
Which of the following commands sets the Virtual Warehouse for a session?

A. COPT WAREHOUSE FROM <<Config file> ;

B. SET warehouse = <>;

C. USE WAREHOUSE <>;

D. USE VIRTUAL_WAREHOUSE <>;

Correct Answer:C
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

- (Exam Topic 1)
True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

A. True

B. False

Correct Answer:B
Reference: https://docs.snowflake.com/en/sql-reference/constraints-overview.html

START SnowPro-Core EXAM