- (Exam Topic 2)
What tasks can be completed using the copy command? (Select TWO)

1. A. Columns can be aggregated
2. B. Columns can be joined with an existing table
3. C. Columns can be reordered
4. D. Columns can be omitted
5. E. Data can be loaded without the need to spin up a virtual warehouse

Correct Answer: CD

- (Exam Topic 2)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 1)
True or False: It is possible to load data into Snowflake without creating a named File Format object.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

- (Exam Topic 3)
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

1. A. SHOW GRANTS OF ROLE MY_ROLE
2. B. SHOW GRANTS TO ROLE MY_ROLE
3. C. SHOW GRANTS FOR ROLE MY_ROLE
4. D. SHOW GRANTS ON ROLE MY_ROLE

Correct Answer: B

- (Exam Topic 3)
Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

1. A. Use the DROP <file> command after the load completes.
2. B. Specify the TEMPORARY option when creating the file format.
3. C. Specify the PURGE copy option in the COPY INTO <table> command.
4. D. Use the REMOVE command after the load completes.
5. E. Use the DELETE LOAD HISTORY command after the load completes.

Correct Answer: CD