MENU
Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
Suggested Answer: D
Get Premium COF-C02 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
30 comments · newest first
ST
Stefania
11 months ago
Just to confirm, it's ALTER USER jsmith SET RSA_PUBLIC_KEY='...'!
FI
Fidelia
11 months ago
Wait, are you sure about that? Sounds a bit off.
EV
Evangelina
11 months ago
Definitely RSA_PUBLIC_KEY, that's how key pair auth works!
ST
Stevie
11 months ago
I thought it was RSA_PRIVATE_KEY?
MI
Mica
11 months ago
The correct command is to set the RSA_PUBLIC_KEY.
NO
Novella
12 months ago
I thought it was RSA_P8_KEY, but now I'm second-guessing myself. I need to review the documentation again.
GL
Gladis
12 months ago
I'm a bit unsure about the exact syntax, but I remember that it has to do with key pair authentication. Maybe it's ALTER USER with RSA_PRIVATE_KEY?
KA
Kassandra
12 months ago
I practiced a similar question last week, and I believe the correct command is to set the RSA_PUBLIC_KEY for the user.
PH
Phyliss
1 year ago
I think the command should involve setting the public key, but I can't remember if it's RSA_PUBLIC_KEY or something else.
LE
Lea
1 year ago
I'm a bit confused here. Is it the public or private key that we need to set? I want to make sure I get this right, so I'll double-check the details before answering.
GU
Gussie
1 year ago
Okay, I remember from the Snowflake docs that we need to set the RSA public key for the user to enable key pair authentication. So I'm going to go with option A.
MI
Mitzie
1 year ago
Hmm, I'm a bit unsure about this one. I know we need to set a key for the user, but I'm not sure if it's the public or private key. I'll have to think this through carefully.
LI
Lisbeth
1 year ago
This looks straightforward. I think the key is to set the RSA public key for the user, so I'd go with option A.
CH
Cheryll
2 years ago
Wait, does this mean I can't use my top-secret decoder ring to get into Snowflake? That's a real bummer.
CA
Casey
2 years ago
D) ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';
AM
Amie
2 years ago
C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
CE
Celestina
2 years ago
B) ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
BR
Britt
2 years ago
A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
KA
Kanisha
2 years ago
Hmm, I'm leaning towards option A. Seems more straightforward to set the RSA P8 key, doesn't it?
TE
Terry
2 years ago
Option B looks good to me. Encrypting the key is probably the most secure way to store it in Snowflake.
AZ
Azzie
2 years ago
I agree with Jesusa. Setting the RSA public key is necessary for key pair authentication in Snowflake.
YU
Yuki
2 years ago
I think option C is the way to go. Setting the RSA private key seems like the logical choice for key pair authentication.
WI
Wilda
2 years ago
Setting the RSA private key is the correct choice for this scenario.
LA
Lashandra
2 years ago
Exactly, the private key is crucial for key pair authentication.
YO
Youlanda
2 years ago
That makes sense. The private key is needed for authentication.
LE
Leanora
2 years ago
Option C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
FE
Felice
2 years ago
Setting the RSA private key is essential for key pair authentication in Snowflake.
TE
Teddy
2 years ago
Make sure to use the correct command to assign the key to the user.
LA
Laurene
2 years ago
Option C is correct. You need to set the RSA private key for key pair authentication.
JE
Jesusa
2 years ago
I think the correct command is A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';