Which parameter prevents streams on tables from becoming stale?
A. MAX_DATA_EXTENSION_TIME_IN_DAYS
B. MIN_DATA_RETENSION_TIME_IN_DAYS
C. LOCK_TIMEOUT
D. STALE_AFTER
A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Choose two.)
A. Rename listings
B. Delete provider profiles
C. Modify listings properties
D. Modify incoming listing access requests
E. Submit listings for approval/publishing
Which statement is true of zero-copy cloning?
A. It increases storage costs as cloning a table requires storing its data twice
B. A cloned table includes the load history of the original source
C. It is licensed as an additional Snowflake feature
D. All micro-partitions between the original and cloned tables are fully shared
How many resource monitors can be applied to a single virtual warehouse?
A. Zero
B. One
C. Eight
D. Unlimited
Which use case will always cause an exploding join in Snowflake?
A. A query that has more than 10 left outer joins.
B. A query that is using a UNION without an ALL.
C. A query that has not specified join criteria for tables.
D. A query that has requested too many columns of data.
Which virtual warehouse privilege is required to view a load-monitoring chart?
A. MONTTOR
B. MODIFY
C. OPERATE
D. USAGE
When unloading data, which file format preserves the data values for floating-point number columns?
A. Avro
B. CSV
C. JSON
D. Parquet
Which Snowflake table supports unstructured data?
A. Directory
B. Transient
C. Temporary
D. Permanent
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
A. 1
B. 5
C. 10
D. 100
Which function returns the URL of a stage using the stage name as the input?
A. BUILD_STAGE_FILE_URL
B. BUILD_SCOPED_FILE_URL
C. GET_PRESIGNED_URL
D. GET_STAGE_LOCATION
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.