Snowflake Updated COF-C03 Exam Questions and Answers by alfie-james

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.

The correct answer is C. The privileges accessed by the PUBLIC role .

Every Snowflake user is automatically granted the PUBLIC role. This means that when a user receives a custom role, the user still also has access to privileges granted to PUBLIC.

Why C is correct:

The PUBLIC role is automatically available to all users. Therefore, in addition to privileges granted through the custom role, the user also has privileges available through PUBLIC.

Why the other options are incorrect:

A. Granting a custom role to a user does not give the user ACCOUNTADMIN privileges.

B. This describes the privileges provided by the custom role itself, not the additional privileges the user has by default.

D. Granting a custom role does not give the user USERADMIN privileges.

Official Snowflake documentation reference:

Snowflake documentation explains that the PUBLIC role is automatically granted to every user and every role. Privileges granted to PUBLIC are available to all users.