SnowPro Core Certification — Question 1102

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

Answer options

• A. ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
• B. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
• C. ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
• D. ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';

Correct answer: D

Explanation

The correct command is D, which sets the RSA_PUBLIC_KEY for the user, enabling key pair authentication. Options A and C are incorrect because they refer to private keys, which are not used for authentication in this context. Option B is also incorrect as it pertains to an encrypted key which is not relevant for key pair authentication in Snowflake.