Which Snowflake SQL command is used to get a subset of rows randomly from a table?
A. GENERATOR
B. LATERAL
C. PIVOT
D. SAMPLE
How long is the load history stored in the metadata of the pipe in Snowpipe?
A. 2 days
B. 7 days
C. 14 days
D. 64 days
Which command is used to generate a zero-copy "snapshot" of any table, schema, or database?
A. ALTER
B. CREATE ... CLONE
C. COPY INTO
D. CREATE REPLICATION GROUP
If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?
A. Decrease the warehouse size.
B. Decrease the MIN_CLUSTER_COUNT parameter.
C. Change the multi-cluster settings to add additional clusters.
D. Start a separate warehouse and move queued queries there.
Which statistic displayed in a Query Profile is specific to external functions?
A. Bytes written
B. Total invocations
C. Partitions scanned
D. Bytes sent over the network
Which Snowflake object can be used to record DML changes made to a table?
A. Snowpipe
B. Stage
C. Stream
D. Task
Which statement accurately describes how a virtual warehouse functions?
A. Increasing the size of a virtual warehouse will always improve data loading performance.
B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.
How does a scoped URL expire?
A. When the data cache clears.
B. When the persisted query result period ends.
C. The encoded URL access is permanent.
D. The length of time is specified in the expiration_time argument.
What are the key characteristics of ACOUNT_USAGE views? (Choose two.)
A. There is no data latency.
B. The data latency can vary from 45 minutes to 3 hours.
C. The historical data is not retained.
D. The historical data can be retained from 7 days to 6 months.
E. Records for dropped objects are included in each view.
If queries start to queue in a multi-cluster virtual warehouse an additional compute cluster starts immediately under what setting?
A. Auto-scale mode
B. Maximized mode
C. Economy scaling policy
D. Standard scaling policy
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.