Snowflake COF-C02 - SnowPro Core Certification Exam
What is the purpose of multi-cluster virtual warehouses?
How can a row access policy be applied to a table or a view? (Choose two.)
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
True or False: Snowpipe via REST API can only reference External Stages as source.
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates
How can this worksheet be shared?
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
What is the maximum Time Travel retention period for a temporary Snowflake table?
What type of query benefits the MOST from search optimization?
How are serverless features billed?
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Network policies can be set at which Snowflake levels? (Choose two.)
Which file formats are supported for unloading data from Snowflake? (Choose two.)
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Which minimum Snowflake edition allows for a dedicated metadata store?
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
