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

- Free Preparation Discussions

Snowflake Exam COF-C02 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

Contribute your Thoughts:

Cheryll
2 months 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
22 days ago
D) ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';
upvoted 0 times
...
Amie
1 months ago
C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Celestina
1 months ago
B) ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Britt
2 months ago
A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
...
Kanisha
2 months 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 months 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 months ago
I agree with Jesusa. Setting the RSA public key is necessary for key pair authentication in Snowflake.
upvoted 0 times
...
Yuki
2 months 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
26 days ago
Setting the RSA private key is the correct choice for this scenario.
upvoted 0 times
...
Lashandra
27 days ago
Exactly, the private key is crucial for key pair authentication.
upvoted 0 times
...
Youlanda
1 months ago
That makes sense. The private key is needed for authentication.
upvoted 0 times
...
Leanora
1 months ago
Option C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...
Felice
1 months ago
Setting the RSA private key is essential for key pair authentication in Snowflake.
upvoted 0 times
...
Teddy
2 months ago
Make sure to use the correct command to assign the key to the user.
upvoted 0 times
...
Laurene
2 months ago
Option C is correct. You need to set the RSA private key for key pair authentication.
upvoted 0 times
...
...
Jesusa
2 months ago
I think the correct command is A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
upvoted 0 times
...

Save Cancel