Question 1

How can a user change which columns are referenced in a view?

Options :

A : Modify the columns in the underlying table

B : Use the ALTER VIEW command to update the view

C : Recreate the view with the required changes

D : Materialize the view to perform the changes

Answer: C

Question 2

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 3

How can a Data Exchange Administrator provide a user with account access to a Data Exchange?

Options :

A : Grant the user the USERADMIN role.

B : Add the user to the Data Exchange.

C : Enable the IMPORT SHARE privilege and grant this privilege to the user.

D : Create a new database for the Data Exchange and provide access to the user.

Answer: C

Question 4

Which function will generate a URL that can be accessed by a non-Snowflake user?

Options :

A : GET_PRESIGNED_URL

B : GET_STAGE_LOCATION

C : BUILD_SCOPED_FILE_URL

D : BUILD_STAGE_FILE_URL

Answer: B

Question 5

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options :

A : Management of metadata

B : Computing the data

C : Maintaining Availability Zones

D : Infrastructure security

E : Parsing and optimizing queries

Answer: A,E

Free COF-C02 Mock Exam – Practice Online Confidently