New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-C02 Exam - Topic 6 Question 46 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 46
Topic #: 6
[All COF-C02 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer: D

by Sherly at Oct 21, 2024, 05:38 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Stefania
3 months ago
Just to confirm, it's ALTER USER jsmith SET RSA_PUBLIC_KEY='...'!
upvoted 0 times
...
Fidelia
3 months ago
Wait, are you sure about that? Sounds a bit off.
upvoted 0 times
...
Evangelina
3 months ago
Definitely RSA_PUBLIC_KEY, that's how key pair auth works!
upvoted 0 times
...
Stevie
4 months ago
I thought it was RSA_PRIVATE_KEY?
upvoted 0 times
...
Mica
4 months ago
The correct command is to set the RSA_PUBLIC_KEY.
upvoted 0 times
...
Novella
4 months ago
I thought it was RSA_P8_KEY, but now I'm second-guessing myself. I need to review the documentation again.
upvoted 0 times
...
Gladis
4 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?
upvoted 0 times
...
Kassandra
4 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.
upvoted 0 times
...
Phyliss
5 months 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.
upvoted 0 times
...
Lea
5 months 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.
upvoted 0 times
...
Gussie
5 months 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.
upvoted 0 times
...
Mitzie
5 months 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.
upvoted 0 times
...
Lisbeth
5 months 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.
upvoted 0 times
...
Cheryll
1 year ago
Wait, does this mean I can't use my top-secret decoder ring to get into Snowflake? That's a real bummer.
upvoted 0 times
Casey
1 year ago
D) ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';
upvoted 0 times
...
Amie
1 year ago
C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Celestina
1 year ago
B) ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Britt
1 year ago
A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
...
Kanisha
1 year ago
Hmm, I'm leaning towards option A. Seems more straightforward to set the RSA P8 key, doesn't it?
upvoted 0 times
...
Terry
1 year ago
Option B looks good to me. Encrypting the key is probably the most secure way to store it in Snowflake.
upvoted 0 times
...
Azzie
1 year ago
I agree with Jesusa. Setting the RSA public key is necessary for key pair authentication in Snowflake.
upvoted 0 times
...
Yuki
1 year ago
I think option C is the way to go. Setting the RSA private key seems like the logical choice for key pair authentication.
upvoted 0 times
Wilda
1 year ago
Setting the RSA private key is the correct choice for this scenario.
upvoted 0 times
...
Lashandra
1 year ago
Exactly, the private key is crucial for key pair authentication.
upvoted 0 times
...
Youlanda
1 year ago
That makes sense. The private key is needed for authentication.
upvoted 0 times
...
Leanora
1 year ago
Option C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Felice
1 year ago
Setting the RSA private key is essential for key pair authentication in Snowflake.
upvoted 0 times
...
Teddy
1 year ago
Make sure to use the correct command to assign the key to the user.
upvoted 0 times
...
Laurene
1 year ago
Option C is correct. You need to set the RSA private key for key pair authentication.
upvoted 0 times
...
...
Jesusa
1 year ago
I think the correct command is A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...

Save Cancel