- (Exam Topic 3)
Which of the following accurately describes shares?

1. A. Tables, secure views, and secure UDFs can be shared
2. B. Shares can be shared
3. C. Data consumers can clone a new table from a share
4. D. Access to a share cannot be revoked once granted

Correct Answer: A

- (Exam Topic 3)
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

1. A. To validate external table files in table t1 across all sessions
2. B. To validate task SQL statements against table t1 in the last 14 days
3. C. To validate a file for errors before it gets executed using a COPY command
4. D. To return errors from the last executed COPY command into table t1 in the current session

Correct Answer: D

- (Exam Topic 3)
Which of the following are characteristics of security in Snowflake?

1. A. Account and user authentication is only available with the Snowflake Business Critical edition.
2. B. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
3. C. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
4. D. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Correct Answer: C

- (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

- (Exam Topic 1)
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

1. A. The primary duster in the virtual warehouse
2. B. The entire Virtual Warehouse
3. C. The database the Virtual Warehouse resides in
4. D. The queries currently being run by the Virtual Warehouse

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