A Snowflake user is writing a User-Defined Function (UDF) with some unqualified object names.
How will those object names be resolved during execution?
A. Snowflake will resolve them according to the SEARCH_PATH parameter.
B. Snowflake will only check the schema the UDF belongs to.
C. Snowflake will first check the current schema, and then the schema the previous query used.
D. Snowflake will first check the current schema, and then the PUBLIC schema of the current database.
Why should a user select the economy scaling policy for a multi-cluster warehouse?
A. To prevent/minimize query queuing
B. To increase performance of the clusters
C. To reduce queuing concurrent user queries
D. To conserve credits by keeping running clusters fully loaded
What is the difference between a stored procedure and a User-Defined Function (UDF)?
A. Stored procedures can execute database operations while UDFs cannot.
B. Returning a value is required in a stored procedure while returning values in a UDF is optional.
C. Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.
D. Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.
How does Snowflake store a table's underlying data? (Choose two.)
A. Columnar file format
B. Micro-partitions
C. Text file format
D. Uncompressed
E. User-defined partitions
A user wants to add additional privileges to the system-defined roles for their virtual warehouse.
How does Snowflake recommend they accomplish this?
A. Grant the additional privileges to a custom role.
B. Grant the additional privileges to the ACCOUNTADMIN role.
C. Grant the additional privileges to the SYSADMIN role.
D. Grant the additional privileges to the ORGADMIN role.
A Snowflake user wants to share data with someone who does not have a Snowflake account.
How can the Snowflake user share the data?
A. Use the Snowflake Marketplace.
B. Create a reader account.
C. Create a consumer account.
D. Use a Snowflake share.
What command is used to export or unload data from Snowflake?
A. PUT @mystage
B. GET @mystage
C. Copy INTO @mystage
D. INSERT @mystage
Which user object property requires contacting Snowflake Support in order to set a value for it?
A. DISABLED
B. MINS_TO_BYPASS MFA
C. MINS_TO_BYPASS_NETWORK_POLICY
D. MINS_TO_UNLOCK
What is the MAXIMUM number of days a Snowflake-managed encryption key can be used before it gets automatically rotated?
A. 1 day
B. 14 days
C. 30 days
D. 120 days
What information is included in the display in the Query Profile? (Choose two.)
A. Index hints used in query
B. Credit usage details
C. Clustering keys details
D. Details and statistics for the overall query
E. Graphical representation of the query processing plan
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.