What columns are returned when performing a FLATTEN command on semi-structured data? (Choose two.)
A. KEY
B. NODE
C. VALUE
D. LEVEL
E. ROOT
Which of the following SQL statements will list the version of the drivers currently being used?
A. Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
B. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
C. Execute SELECT CURRENT_CLIENT(); from an application
D. Execute SELECT CURRENT_VERSION(); from the Python Connector
What is the maximum length of time travel available in the Snowflake Standard Edition?
A. 1 Day
B. 7 Days
C. 30 Days
D. 90 Days
A user executes the following SQL query:
create table SALES_BKP like SALES;
What are the cost implications for processing this query?
A. Processing costs will be generated based on how long the query takes.
B. Storage costs will be generated based on the size of the data.
C. No costs will be incurred as the query will use metadata.
D. The cost for running the virtual warehouse will be charged by the second.
What actions are supported by Snowflake resource monitors? (Choose two.)
A. Alert
B. Notify
C. Notify and suspend
D. Abort
E. Suspend immediately
Masking policies can be applied to which of the following Snowflake objects? (Choose two.)
A. A materialized view
B. A stored procedure
C. A table
D. A stream
E. A pipe
F. A User-Defined Function (UDF)
What is the compressed size limit for semi-structured data loaded into a VARIANT data type using the COPY command?
A. 8 MB
B. 16 MB
C. 32 MB
D. 64 MB
Which statement describes when a virtual warehouse can be resized?
A. A resize will affect running, queued, and new queries.
B. A resize can only be completed when the warehouse is in an auto-resume status.
C. A resize must be completed when the warehouse is suspended.
D. A resize can be completed at any time.
What is the default compression typo when unloading data from Snowflake?
A. Brotli
B. bzip2
C. Zstandard
D. gzip
Which of the following view types are available in Snowflake? (Choose two.)
A. Layered view
B. Secure view
C. External view
D. Embedded view
E. Materialized view
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Snowflake exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your COF-C02 exam preparations and Snowflake certification application, do not hesitate to visit our Vcedump.com to find your solutions here.