Free Snowflake COF-C02 Exam Dumps Questions & Answers

What does Snowflake recommend as a best practice for using secure views?

• A.  Do not expose the sequence-generated column(s)
• B.  Use secure views solely for query convenience.
• C.  Use sequence-gen era ted values
• D.  Programmatically reveal the identifiers.

What does the LATERAL modifier for the FLATTEN function do?

• A.  Joins information outside the object with the flattened data
• B.  Casts the values of the flattened data
• C.  Extracts the path of the flattened data
• D.  Retrieves a single instance of a repeating element in the flattened data

A user has been granted the APPLY privilege on a masking policy that partially masks customer telephone numbers. Which additional privilege must be granted so that the user can apply the masking policy to the relevant columns?

• A.  USAGE on the parent database and schemas and SELECT on the relevant tables or views
• B.  USAGE on the parent schemas and SELECT on the relevant tables or views
• C.  SELECT on the relevant tables or views
• D.  USAGE on the parent database and schemas

What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

• A.  The clone saves space by not duplicating storage.
• B.  The clone is created almost instantly.
• C.  The clone always stays in sync with the original table.
• D.  The clone will have time travel history from the original table.
• E.  The clone has better query performance.

How does Snowflake define i1s approach to Discretionary Access Control (DAC)?

• A.  Each object has an owner, who can in turn grail access to that object.
• B.  An entity in which access can be granted
• C.  Access privileges are assigned to roles. which are in turn assigned to use ' s
• D.  A defined level of access to an object