Which table type is automatically deleted after a session is closed and has no Fail-safe or Time Travel cost?
A. Temporary
B. Transient
C. Permanent
D. External
What is to be expected when sharing worksheets in Snowsight?
A. Worksheets can be shared with users that are internal or external to any organization.
B. To run a shared worksheet, a user must be granted the role used for the worksheet session context.
C. Snowsight allows users to view and refresh results but not to edit shared worksheets.
D. Snowsight offers different sharing permissions at the worksheet, folder, and dashboard level.
Which file format is MOST performant in Snowflake for data loading?
A. Parquet
B. CSV
C. ORC
D. Avro
Which clustering indicator will show if a large table in Snowflake will benefit from explicitly defining a clustering key?
A. Percentage
B. Depth
C. Ratio
D. Total partition count
What is a characteristic of the Snowflake query profiler?
A. It can provide statistics on a maximum number of 100 queries per week.
B. It provides a graphic representation of the main components of the query processing.
C. It provides detailed statistics about which queries are using the greatest number of compute resources.
D. It can be used by third-party software using the query profiler API.
Which function is used to profile warehouse credit usage?
A. AUTOMATIC_CLUSTERING_HISTORY
B. MATERIALIZED_VIEW_REFRESH_HISTORY
C. WAREHOUSE_LOAD_HISTORY
D. WAREHOUSE_METERING_HISTORY
Which data types are valid in Snowflake? (Choose two.)
A. BLOB
B. Geography
C. JSON
D. CLOB
E. Variant
Several users are using the same virtual warehouse. The users report that the queries are running slowly, and that many queries are being queued.
What is the recommended way to resolve this issue?
A. Reduce the warehouse STATEMENT_QUEUED_TIMEOUT_IN SECONDS parameter.
B. Reduce the warehouse AUTO_SUSPEND parameter.
C. Increase the warehouse MAX_CONCURRENCY_LIMIT parameter.
D. Increase the warehouse MAX_CLUSTER_COUNT parameter.
What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?
A. 1 minute
B. 5 minutes
C. 10 minutes
D. 15 minutes
Which object type is granted permissions for reading a table?
A. User
B. Role
C. Attribute
D. Schema
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.