BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

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

AALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

BALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';

CALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

DALTER 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

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

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

Britt

10 days ago

A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

upvoted 0 times

...

...

Kanisha

22 days ago

Hmm, I'm leaning towards option A. Seems more straightforward to set the RSA P8 key, doesn't it?

upvoted 0 times

...

Terry

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

24 days ago

I agree with Jesusa. Setting the RSA public key is necessary for key pair authentication in Snowflake.

upvoted 0 times

...

Yuki

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

Leanora

18 hours ago

Option C) ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

upvoted 0 times

...

Felice

2 days ago

Setting the RSA private key is essential for key pair authentication in Snowflake.

upvoted 0 times

...

Teddy

8 days ago

Make sure to use the correct command to assign the key to the user.

upvoted 0 times

...

Laurene

16 days ago

Option C is correct. You need to set the RSA private key for key pair authentication.

upvoted 0 times

...

...

Jesusa

30 days ago

I think the correct command is A) ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

upvoted 0 times

...