- (Exam Topic 2)
What happens when an external or an internal stage is dropped? (Select TWO).

1. A. When dropping an external stage, the files are not removed and only the stage is dropped
2. B. When dropping an external stage, both the stage and the files within the stage are removed
3. C. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
4. D. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
5. E. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Correct Answer: AC

- (Exam Topic 3)
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

1. A. CHECK_OPTION
2. B. IS_SECURE
3. C. IS_UPDATEABLE
4. D. TABLE_NAME

Correct Answer: B

- (Exam Topic 1)
What command is used to load files into an Internal Stage within Snowflake? Select one.

1. A. PUT
2. B. COPY INTO
3. C. TRANSFER
4. D. INSERT

Correct Answer: A
You must specify an internal stage in the PUT command
when uploading files to Snowflake. You must
specify the same stage in the COPY INTO <table> command when loading data into a table from the staged files.

- (Exam Topic 3)
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

1. A. The shared objects are transferred.
2. B. The shared objects are copied.
3. C. The shared objects become accessible.
4. D. The shared objects can be re-shared.

Correct Answer: B

- (Exam Topic 3)
What impacts the credit consumption of maintaining a materialized view? (Choose two.)

1. A. Whether or not it is also a secure view
2. B. How often the underlying base table is queried
3. C. How often the base table changes
4. D. Whether the materialized view has a cluster key defined
5. E. How often the materialized view is queried

Correct Answer: DE