How does Snowflake handle the bulk unloading of data into single or multiple files?
A. It assigns each unloaded data file a unique name.
B. It uses the PUT command to download the data by default.
C. It uses COPY INTO for bulk unloading where the default option is SINGLE = TRUE.
D. It uses COPY INTO to copy the data from a table into one or more files in an external stage only.
A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently. What should the user do?
A. Add a clustering key to the table.
B. Add the search optimization service to the table.
C. Create a materialized view based on the query.
D. Enable the query acceleration service for the virtual warehouse.
When unloading data, which file formats are supported by the COPY INTO command? (Choose two.)
A. Avro
B. JSON
C. ORC
D. Parquet
E. XML
When using the ALLOW_CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A. 1 hour
B. 2 hours
C. 4 hours
D. 8 hours
A custom role owns multiple tables. If this role is dropped from the system, who becomes the owner of these tables?
A. ACCOUNTADMIN
B. SYSADMIN
C. Tables will be standalone or orphaned.
D. The role that dropped the custom role.
A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?
A. select data:BIKEID
B. select data.BIKE.BIKEID
C. select data:BIKE.BIKEID
D. select data:BIKE:BIKEID
What are characteristics of Snowflake network policies? (Choose two.)
A. They can be set for any Snowflake Edition
B. They can be applied to roles.
C. They restrict or enable access to specific IP addresses.
D. They are activated using ALTER DATABASE SQL commands.
E. They can only be managed using the ORGADMIN role.
Which function should be used to find the query ID of the second query executed in a current session?
A. Select LAST_QUERY_ID(-2)
B. Select LAST_QUERY_ID(-1)
C. Select LAST_QUERY_ID(1)
D. Select LAST_QUERY_ID(2)
Snowflake strongly recommends that all users with what type of role be required to use Multi-Factor Authentication (MFA)?
A. USERADMIN
B. ACCOUNTADMIN
C. SECURITYADMIN
D. SYSADMIN
Which function produces a lateral view of a VARIANT column?
A. GET_PATH
B. FLATTEN
C. GET
D. PARSE_JSON
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.