Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

Question

Options

• AALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
• BALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
• CALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
• DALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';

• A
  5% (1)
• B
  5% (1)
• D
  90% (18)

Explanation

In Snowflake key pair authentication, the PUBLIC key is assigned to the user account in Snowflake, while the user retains the private key locally. The correct property name is RSA_PUBLIC_KEY. The command syntax is: ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...'; Options A (RSA_P8_KEY) and B (ENCRYPTED_KEY) are not valid Snowflake property names. Option C (RSA_PRIVATE_KEY) is incorrect because you never upload a private key to Snowflake - that would be a severe security violation. Only the public key is stored server-side.

No community discussion yet for this question.