- (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 1)
What is the recommended Snowflake data type to store semi-structured data like JSON?

1. A. VARCHAR
2. B. RAW
3. C. LOB
4. D. VARIANT

Correct Answer: D
Reference: https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html

- (Exam Topic 3)
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

1. A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
2. B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
3. C. The ACCOUNTADMIN role must be granted to only one user.
4. D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
5. E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Correct Answer: AD

- (Exam Topic 3)
Which of the following statements describes a schema in Snowflake?

1. A. A logical grouping of objects that belongs to a single database
2. B. A logical grouping of objects that belongs to multiple databases
3. C. A named Snowflake object that includes all the information required to share a database
4. D. A uniquely identified Snowflake account within a business entity

Correct Answer: A

- (Exam Topic 2)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

1. A. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;
2. B. SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())
3. C. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;
4. D. SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Correct Answer: D