Deal of The Day! 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

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
D) ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...'; To use key pair authentication in Snowflake, you need to set the public key for the user. This allows the user to authenticate using their private key. Generate Key Pair: Generate a public and private key pair. Set Public Key: ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...'; Authentication: The user can now authenticate by signing requests with the corresponding private key. References: Snowflake Documentation: Key Pair Authentication & Key Rotation Snowflake Documentation: ALTER USER
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...';

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
9 months ago
Just to confirm, it's ALTER USER jsmith SET RSA_PUBLIC_KEY='...'!
upvoted 0 times
...
Fidelia
9 months ago
Wait, are you sure about that? Sounds a bit off.
upvoted 0 times
...
Evangelina
9 months ago
Definitely RSA_PUBLIC_KEY, that's how key pair auth works!
upvoted 0 times
...
Stevie
10 months ago
I thought it was RSA_PRIVATE_KEY?
upvoted 0 times
...
Mica
10 months ago
The correct command is to set the RSA_PUBLIC_KEY.
upvoted 0 times
...
Novella
10 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
10 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
10 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
11 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
11 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
11 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
11 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
11 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
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.
upvoted 0 times
Casey
2 years ago
D) ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';
upvoted 0 times
...
Amie
2 years ago
C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Celestina
2 years ago
B) ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Britt
2 years ago
A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
...
Kanisha
2 years ago
Hmm, I'm leaning towards option A. Seems more straightforward to set the RSA P8 key, doesn't it?
upvoted 0 times
...
Terry
2 years 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
2 years ago
I agree with Jesusa. Setting the RSA public key is necessary for key pair authentication in Snowflake.
upvoted 0 times
...
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.
upvoted 0 times
Wilda
2 years ago
Setting the RSA private key is the correct choice for this scenario.
upvoted 0 times
...
Lashandra
2 years ago
Exactly, the private key is crucial for key pair authentication.
upvoted 0 times
...
Youlanda
2 years ago
That makes sense. The private key is needed for authentication.
upvoted 0 times
...
Leanora
2 years ago
Option C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Felice
2 years ago
Setting the RSA private key is essential for key pair authentication in Snowflake.
upvoted 0 times
...
Teddy
2 years ago
Make sure to use the correct command to assign the key to the user.
upvoted 0 times
...
Laurene
2 years ago
Option C is correct. You need to set the RSA private key for key pair authentication.
upvoted 0 times
...
...
Jesusa
2 years ago
I think the correct command is A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...

Save Cancel