- (Exam Topic 1)
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

1. A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
2. B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
3. C. SECURITYADMIN, ACCOUNTADMIN
4. D. ACCOUNTADMIN

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

- (Exam Topic 2)
Which of the following commands cannot be used within a reader account?

1. A. CREATE SHARE
2. B. ALTER WAREHOUSE
3. C. DROP ROLE
4. D. SHOW SCHEMAS
5. E. DESCRBE TABLE

Correct Answer: B
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.

- (Exam Topic 1)
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

1. A. True
2. B. False

Correct Answer: A
Reference: https://docs.snowflake.com/en/user-guide/ui-worksheet.html

- (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 happens to historical data when the retention period for an object ends?

1. A. The data is cloned into a historical object.
2. B. The data moves to Fail-safe
3. C. Time Travel on the historical data is dropped.
4. D. The object containing the historical data is dropped.

Correct Answer: D