Which of the following operations require the use of a running virtual warehouse? (Choose two.)
A. Downloading data from an internal stage
B. Listing files in a stage
C. Executing a stored procedure
D. Altering a table
E. Querying data from a materialized view
If all virtual warehouse resources are maximized while processing a query workload, what will happen to new queries that are submitted to the warehouse?
A. All queries will terminate when the resources are maximized.
B. The warehouse will scale out automatically
C. The warehouse will move to a suspended state.
D. New queries will be queued and executed when capacity is available.
While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?
A. Statements that insert a duplicate record during a load
B. Statements that have a specific data type in the source
C. Statements that have duplicate file names
D. Statements that transform data during a load
Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?
A. Bytes sent over the network
B. Synchronization
C. Initialization D. Remote spillage
Snowflake virtual warehouses are part of which layer of the Snowflake architecture?
A. Compute layer
B. Storage layer
C. Database layer
D. Cloud services layer
Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)
A. TRUE
B. RETURN_ERROR_SUM
C. RETURN_ALL_ERRORS
D. RETURN__ROWS
E. RETURN_FIRST__ERRORS
What services are provided by the cloud services layer in Snowflake? (Choose two.)
A. Metadata management
B. Object authorization
C. Authentication
D. Query execution
E. Result caching
According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)
A. ACCOUNTADMIN
B. SYSADMIN
C. SECURITYADMIN
D. USERADMIN
E. ORGADMIN
Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?
A. Can SHOW users DESCRIBE a given user, or ALTER or DROP a user
B. Can DEFINE users, DESCRIBE a given user, or ALTER or DELETE a user
C. Can SHOW users, INDEX a given user, or ALTER or DELETE a user
D. Can SHOW users, DEFINE a given user or ALTER, DROP, or MODIFY a user
What is a characteristic of data micro-partitioning in Snowflake?
A. Micro-partitioning may introduce data skew
B. Micro-partitioning requires the definition of a partitioning schema
C. Micro-partitioning happens when the data is loaded
D. Micro-partitioning can be disabled within a Snowflake account
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.