SnowPro Advanced: Administrator Free Practice Exam Questions

10 real SnowPro Advanced: Administrator exam questions with answers and AI explanations. Snowflake certification prep — page 1 of 1.

1. Question 1: Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)
2. Question 2: What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?
3. Question 3: What is a characteristic of Snowflake's transaction locking and concurrency modeling?
4. Question 5: A user has built a view named DB.VWS.TEST_VIEW in Snowflake which only allows users having ROLE_XYZ to retrieve data from the view. Roles Setup: GRANT USAGE ON…
5. Question 6: For Snowflake network policies, what will occur when the account_level and user_level network policies are both defined?
6. Question 7: What are characteristics of Dynamic Data Masking? (Choose two.)
7. Question 8: What roles can be used to create network policies within Snowflake accounts? (Choose three.)
8. Question 9: What are characteristics of data replication in Snowflake? (Choose three.)
9. Question 10: What are benefits of using Snowflake organizations? (Choose two.)
10. Question 12: What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)