Which columns are available in the output of a Snowflake directory table? (Choose two.)
A. CATALOG_NAME
B. FILE_NAME
C. LAST_MODIFIED
D. RELATIVE_PATH
E. STAGE_NAME
Which native data types are used for storing semi-structured data in Snowflake? (Choose two.)
A. NUMBER
B. OBJECT
C. STRING
D. VARCHAR
E. VARIANT
What happens when a user exits Snowsight during a session that a query is running?
A. Snowflake executes the query during the same session immediately.
B. Snowflake cancels any queries submitted during this session that are still running.
C. Snowflake will cancel any queries submitted during this session after 24 hours.
D. Snowflake will continue to execute and complete upon the next login.
By default, the COPY INTO statement will separate table data into a set of output files to take advantage of which Snowflake feature?
A. Query acceleration
B. Query plan caching
C. Parallel processing
D. Time Travel
What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?
A. Pipe
B. Stream
C. Task
D. View
Which command can be used to view the allowed and blocked IP list of a network policy?
A. ALTER NETWORK POLICY
B. CREATE NETWORK POLICY
C. DESCRIBE NETWORK POLICY
D. SHOW NETWORK POLICIES
What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?
A. ACCOUNTADMIN
B. SECURITYADMIN
C. SYSADMIN
D. ORGADMIN
How can a Snowflake user optimize query performance in Snowflake? (Choose two.)
A. Create a view.
B. Cluster a table.
C. Enable the search optimization service.
D. Enable Time Travel.
E. Index a table.
Which file functions are non-deterministic? (Choose two.)
A. BUILD_SCOPED_FILE_URL
B. BUILD_STAGE_FILE_URL
C. GET_ABSOLUTE_PATH
D. GET_PRESIGNED_URL
E. GET_RELATIVE_PATH
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
A. Materialized view
B. Sequence
C. Secure view
D. Transient table
E. Clustered table
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.