- (Exam Topic 2)
What SQL command would be used to view all roles that were granted to user.1?
Correct Answer:A
- (Exam Topic 3)
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Correct Answer:B
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg
- (Exam Topic 3)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
Correct Answer:B
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition
- (Exam Topic 3)
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
Correct Answer:AD
- (Exam Topic 2)
How often are encryption keys automatically rotated by Snowflake?
Correct Answer:A
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All Snowflake-man
- (Exam Topic 3)
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
Correct Answer:AE