When unloading the data for file format type specified (TYPE = 'CSV'), SQL NULL can be converted to string `null' using which file format option?
A. SKIP_BYTE_ORDER_MARK
B. EMPTY_FIELD_AS_NULL
C. NULL_IF
D. ESCAPE_UNENCLOSED_FIELD
Which table function should be used to view details on a Directed Acyclic Graph (DAG) run that is presently scheduled or is executing?
A. TASK_HISTORY
B. TASK_DEPENDENTS
C. CURRENT_TASK_GRAPHS
D. COMPLETE_TASK_GRAPHS
What Snowflake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
A. Temporary table
B. External table
C. Secure view
D. Materialized view
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history. What will happen if User2 tries to access the query history?
A. If User2 has the SYSADMIN role they will be able to see the results.
B. If User2 has the SECURITYADMIN role they will be able to see the results.
C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
D. User2 will be unable to view the result set of the query executed by User1.
Why is a federated environment used for user authentication in Snowflake?
A. To enhance data security and privacy
B. To provide real-time monitoring of user activities
C. To separate user authentication from user access
D. To enable direct integration with external databases
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
A. The provisioning of new compute resources for the warehouse will begin immediately.
B. The warehouse will remain suspended but new resources will be added to the query acceleration service.
C. The provisioning of additional compute resources will be in effect when the warehouse is next resumed.
D. The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
A. LAST_QUERY_ID
B. CURRENT_STATEMENT
C. UUID_STRING
D. JOB_ID
Which Snowflake edition supports Protected Health Information (PHI) data (in accordance with HIPAA and HITRUST CSF regulations), and has a dedicated metadata store and pool of compute resources?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPS)
Which Snowflake table types are used to manage costs for short-lived tables? (Choose two.)
A. External tables
B. Permanent tables
C. Shared tables
D. Temporary tables
E. Transient tables
What are key characteristics of virtual warehouses in Snowflake? (Choose two.)
A. Warehouses that are multi-cluster can have nodes of different sizes.
B. Warehouses can be started and stopped at any time.
C. Warehouses can be resized at any time, even while running.
D. Warehouses are billed on a per-minute usage basis.
E. Warehouses can only be used for querying and cannot be used for data loading.
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.