SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ91

Implement Data Protection and Recovery

A Data Engineer must create a SQL script to batch-load and transform data into Snowflake. The script must run through SnowSQL and be scheduled for execution at specified times by the company’s corporate scheduler.

Based on this scenario, what is the MOST secure authentication method for Snowflake?

Explanation

Key-pair authentication supports non-interactive SnowSQL connections for scheduled batch workloads and provides enhanced security compared with basic username-and-password authentication. Snowflake supports encrypted private keys for SnowSQL and recommends using them to protect against unauthorized key use.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!