Free COF-R02 Practice Test Questions and Answers (2026) | Cert Empire Practice Questions

Get COF-R02 Exam Questions

Free preview: 20 questions.

Already purchased? Log in

SnowFlake COF R02

View Mode
Q: 1
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Options
Q: 2
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
Options
Q: 3
Which command sets the Virtual Warehouse for a session?
Options
Q: 4
Which statement describes how Snowflake supports reader accounts?
Options
Q: 5
Which of the following describes a Snowflake stored procedure?
Options
Q: 6
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Options
Q: 7
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Options
Q: 8
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
Options
Q: 9
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Options
Q: 10
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII. Which Snowflake feature will support this?
Options
Q: 11
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
Options
Q: 12
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps: 1. Created a user called "CONSUMER" 2. Created a database to hold the share and an extra-small warehouse to query the data 3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
Options
Q: 13
What type of query benefits the MOST from search optimization?
Options
Q: 14
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
Options
Q: 15
What file formats does Snowflake support for loading semi-structured data? (Choose three.)
Options
Q: 16
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
Options
Q: 17
What happens to historical data when the retention period for an object ends?
Options
Q: 18
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed: COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON) The load failed with this error: Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
Options
Q: 19
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Options
Q: 20
How many days is load history for Snowpipe retained?
Options
Question 1 of 20

Premium Access Includes

  • ✓Quiz Simulator
  • ✓Exam Mode
  • ✓Progress Tracking
  • ✓Question Saving
  • ✓Flash Cards
  • ✓Drag & Drops
  • ✓3 Months Access
  • ✓PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE

  • USE THE CODE GIVEN BELOW ON YOUR CHECKOUT
DISCOUNT10