Authorization to execute CREATE
A. Primary role
B. Secondary role
C. Application role
D. Database role
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
A. RETURN_-1_ROWS
B. RETURN_n_ROWS
C. RETURN_ERRORS
D. RETURN_ALL_ERRORS
Which command is used to upload data files from a local directory or folder on a client machine to an internal stage, for a specified table?
A. GET
B. PUT
C. CREATE STREAM
D. COPY INTO
Which governance feature is supported by all Snowflake editions?
A. Object tags
B. Masking policies
C. Row access policies
D. OBJECT_DEPENDENCIES view
Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?
A. Area chart
B. Box plot
C. Heat grid
D. Pie chart
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
A. Account
B. Database
C. Schema
D. Table
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
A. APPROXIMATE_SIMILARITY
B. JAROWINKLER_SIMILARITY
C. APPROXIMATE_JACCARD_INDEX
D. MINHASH_COMBINE
Which Snowflake data governance feature can support auditing when a user query reads column data?
A. Access History
B. Data classification
C. Column-level security
D. Object dependencies
Which categories are included in the execution time summary in a Query Profile? (Choose two.)
A. Pruning
B. Spilling
C. Initialization
D. Local Disk I/O
E. Percentage of data read from cache
Which command can be used to list all network policies available in an account?
A. DESCRIBE SESSION POLICY
B. DESCRIBE NETWORK POLICY
C. SHOW SESSION POLICIES
D. SHOW NETWORK POLICIES
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.