Online Access Free COF-C02 Practice Test

In which use cases does Snowflake apply egress charges?

• A.Query result retrieval
• B.Data sharing within a specific region
• C.Database replication
• D.Loading data into Snowflake

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A.SELECT on tables used by the secure view
• B.CREATE_SHARE on the account
• C.SHARE on databases and schemas
• D.REFERENCE_USAGE on databases

Which function can be used to convert semi-structured data into a relational representation?

• A.ARRAYS_TO_OBJECT
• B.FLATTEN
• C.OBJECT_KEYS
• D.PARSE_JSON

What kind of authentication do Snowpipe REST endpoints use?

• A.OAuth
• B.Key-based
• C.Username and password
• D.Single Sign-On (SSO)

When is a DataFrame processed in Snowpark?

• A.When there is sufficient memory available in the virtual warehouse
• B.When a collect() action is triggered
• C.When the DataFrame is created
• D.When a new transformation is applied on the DataFrame