Practice Free COF-C02 Exam Online Questions
Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)
- A . Caching query results
- B . Running EXPLAIN and SHOW commands
- C . Cloning a database
- D . Running a custom query
- E . Running COPY commands
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
- A . VARIANT
- B . ARRAY
- C . VARCHAR
- D . XML
- E . BLOB
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A . A read-only copy of the cloned tables is stored.
- B . The replication will not be successful.
- C . The physical data is replicated
- D . Additional costs for storage are charged to a secondary account
- E . Metadata pointers to cloned tables are replicated
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A . Materialized views
- B . Sequences
- C . Procedures
- D . Tables
- E . Secure User Defined Functions (UDFs)
What feature can be used to reorganize a very large table on one or more columns?
- A . Micro-partitions
- B . Clustering keys
- C . Key partitions
- D . Clustered partitions
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
- A . Data is hashed by the cluster key to facilitate fast searches for common data values
- B . Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned
- C . Smaller micro-partitions are created for common data values to allow for more parallelism
- D . Data may be colocated by the cluster key within the micro-partitions to improve pruning performance
Which pages are included in the Activity area of Snowsight? (Select TWO).
- A . Contacts
- B . Sharing settings
- C . Copy History
- D . Query History
- E . Automatic Clustering History
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
- A . READ
- B . OWNERSHIP
- C . USAGK
- D . WRTTF
Which of the following describes the Snowflake Cloud Services layer?
- A . Coordinates activities in the Snowflake account
- B . Executes queries submitted by the Snowflake account users
- C . Manages quotas on the Snowflake account storage
- D . Manages the virtual warehouse cache to speed up queries
How does Snowflake recommend handling the bulk loading of data batches from files already available in cloud storage?
- A . Use Snowpipe.
- B . Use the INSERT command.
- C . Use an external table.
- D . Use the COPY command.