SnowPro Advanced: Architect — Question 162

A company has several applications that have been developed in-house that need to connect to Snowflake. These applications do not have access to a web browser, and have no redirect capabilities.

Based on this scenario, what is the Snowflake best practice recommendation for application authentication?

Answer options

• A. Use Snowflake OAuth.
• B. Use usernames and passwords.
• C. Use an external OAuth.
• D. Use key pair authentication with a service user.

Correct answer: D

Explanation

Key pair authentication with a service user is the most secure and suitable method for applications that cannot redirect or interact through a web browser. Other options, such as OAuth or usernames and passwords, would not be feasible in this scenario due to the limitations of the applications.