SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ112

Secure Data Sharing and Consumption

A company deployed a Snowflake design solution that uses multiple public cloud services. An AWS Lambda function is invoked several times per day.

The company has implemented Multi-Factor Authentication (MFA) for user authentication. For machine-to-machine authentication, usernames and passwords are used in many instances. The company needs a solution that will MINIMIZE disruption to the production environment, security implementation, and operating costs, while protecting the Snowflake account against common vulnerabilities.

How can these requirements be satisfied?

Explanation

Snowflake key-pair authentication is a more secure alternative to username-and-password authentication for programmatic connections. Snowflake supports two active public keys for a user, allowing a replacement key to be introduced and clients transitioned before the old key is removed, which enables rotation without interrupting production access.

Learn more

Community Discussion

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