Question 1

How does the authorization associated with a pre-signed URL work for an unstructured file?

Options :

A : Anyone who has the URL can access the referenced file for the life of the token.

B : Only the user who generates the URL can use the URL to access the referenced file.

C : Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D : The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

Answer: A

Question 2

What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)

Options :

A : Stored procedures

B : Stages

C : Tasks

D : Views

E : User-Defined Functions (UDFs)

Answer: A,E

Question 3

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options :

A : Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B : All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C : The ACCOUNTADMIN role must be granted to only one user.

D : Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E : All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Answer: A,D

Question 4

Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?

Options :

A : GET

B : PUT

C : CREATE STREAM

D :

Answer: B

Question 5

What factors impact storage costs in Snowflake? (Select TWO).

Options :

A : The account type

B : The storage file format

C : The cloud region used by the account

D : The type of data being stored

E : The cloud platform being used

Answer: A,C

Free COF-C02 Mock Exam – Practice Online Confidently