Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?
A. ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';
B. ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';
C. ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';
D. ALTER USER jsmith SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';
What is the MINIMUM Snowflake edition required to use the column-level security feature?
A. Standard
B. Enterprise
C. Business Critical
D. Virtual Private Snowflake (VPS)
What Snowflake objects can contain custom application logic written in JavaScript? (Choose two.)
A. Stored procedures
B. Stages
C. Tasks
D. Views
E. User-Defined Functions (UDFs)
Which service or tool is a Command Line Interface (CLI) client used for connecting to Snowflake to execute SQL queries?
A. Snowsight
B. SnowCD
C. Snowpark
D. SnowSQL
Which languages require that User-Defined Function (UDF) handlers be written inline? (Choose two.)
A. Java
B. Javascript
C. Scala
D. Python
E. SQL
Which task privilege does a Snowflake role need in order to suspend or resume a task?
A. USAGE
B. OPERATE
C. MONITOR
D. OWNERSHIP
What is a directory table in Snowflake?
A. A separate database object that is used to store file-level metadata.
B. An object layered on a stage that is used to store file-level metadata.
C. A database object with grantable privileges for unstructured data tasks.
D. A Snowflake table specifically designed for storing unstructured files.
What factors impact storage costs in Snowflake? (Choose two.)
A. The account type
B. The storage file format
C. The cloud region used by the account
D. The type of data being stored
E. The cloud platform being used
Which ACCOUNT_USAGE schema database role provides visibility into policy-related information?
A. USAGE_VIEWER
B. GOVERNANCE_VIEWER
C. OBJECT_VIEWER
D. SECURITY_VIEWER
How should clustering be used to optimize the performance of queries that run on a very large table?
A. Manually re-cluster the table regularly.
B. Choose one high cardinality column as the clustering key.
C. Use the column that is most-frequently used in query select clauses as the clustering key.
D. Assess the average table depth to identify how clustering is impacting the query.
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.