Practice Free COF-C02 Exam Online Questions
Snowflake’s hierarchical key mode includes which keys? (Select TWO).
- A . Account master keys
- B . Database master keys
- C . File keys
- D . Secure view keys
- E . Schema master keys
Using variables in Snowflake is denoted by using which SQL character?
- A . @
- B . &
- C . $
- D . #
The Snowflake Cloud Data Platform is described as having which of the following architectures?
- A . Shared-disk
- B . Shared-nothing
- C . Multi-cluster shared data
- D . Serverless query engine
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?
- A . CHECK_OPTION
- B . IS_SECURE
- C . IS_UPDATEABLE
- D . TABLE_NAME
How many days is load history for Snowpipe retained?
- A . 1 day
- B . 7 days
- C . 14 days
- D . 64 days
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
- A . INSERT
- B . PUT
- C . GET
- D . COPY
When loading data into Snowflake, how should the data be organized?
- A . Into single files with 100-250 MB of compressed data per file
- B . Into single files with 1-100 MB of compressed data per file
- C . Into files of maximum size of 1 GB of compressed data per file
- D . Into files of maximum size of 4 GB of compressed data per file
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
- A . Indefinitely
- B . Until the result_cache expires
- C . Until the retention_time is met
- D . Until the expiration time is exceeded
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
- A . Data is live, ready-to-query, and can be personalized.
- B . Data needs to be loaded into a cloud provider as a consumer account.
- C . Data is not available for copying or moving to an individual Snowflake account.
- D . Data is available without copying or moving.
- E . Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A . The warehouse size does not change until all queries currently running in the warehouse have completed.
- B . The warehouse size does not change until all queries currently in the warehouse queue have completed.
- C . The warehouse size does not change until the warehouse is suspended and restarted.
- D . It does not return from the command until the warehouse has finished changing its size.