Question 55

- (Exam Topic 2)
What SQL command would be used to view all roles that were granted to user.1?

Correct Answer:A

Question 56

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

Question 57

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

Question 58

- (Exam Topic 3)
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Correct Answer:AD

Question 59

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

Question 60

- (Exam Topic 3)
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

Correct Answer:AE

START SnowPro-Core EXAM