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 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

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:

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

Save Cancel