Free Snowflake COF-C02 Exam Dumps Questions & Answers

A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).

• A.  Rename listings.
• B.  Delete provider profiles.
• C.  Submit listings for approval/publishing.
• D.  Modify listings properties.
• E.  Modify incoming listing access requests.

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

• A.  An HTTPS server with WebDAV
• B.  A Windows server file share on Azure
• C.  An FTP server with TLS encryption
• D.  A Google Cloud storage bucket

Which statements reflect valid commands when using secondary roles? (Select TWO).

• A.  USE SECONDARY RLES ALL
• B.  USE SECONDARY ROLES SUSPEND
• C.  Use SECONDARY ROLES RESUME
• D.  USE SECONDARY ROLES ADD < Role Name >
• E.  Use SECONDARY ROLES NONE

Which governance feature is supported by all Snowflake editions?

• A.  OBJECT_DEPENDENCIES View
• B.  Masking policies
• C.  Row access policies
• D.  Object tags

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

• A.  DATATYPE
• B.  CONTENT
• C.  PATH
• D.  BYTE_SIZE
• E.  INDEX