SnowPro Advanced: Data Engineer — Question 83

A Data Engineer needs to create a SQL script that will load and transform data in batch mode into Snowflake. The script should be run with SnowSQL, and should be scheduled to run at specific times in the company’s corporate scheduler.

Based on this scenario, what is the MOST secure way to authenticate into Snowflake?

Answer options

• A. Single Sign-On (SSO)
• B. Key-pair authentication
• C. Username and password
• D. Multi-Factor Authentication (MFA)

Correct answer: B

Explanation

Key-pair authentication is considered the most secure method for accessing Snowflake because it uses cryptographic keys instead of passwords, reducing the risk of compromise. While Single Sign-On, Username and password, and Multi-Factor Authentication provide security, they are not as robust as key-pair authentication in preventing unauthorized access.