Free COF-C02 Questions for Snowflake COF-C02 Exam

Question #1

Which steps will help optimize query performance? (Select TWO).

A. Clustering a table

B. Using the query acceleration service

C. Decreasing the size of the virtual warehouse

D. Increasing the size of the micro-partitions

E. Indexing a column

Discussion 0

Correct Answer: C,D Vote an answer

Question #2

What is a recommended best practice when loading data into Snowflake?

A. When loading a single large file split it into multiple files before loading.

B. Set the DATA_RETENTION_TIME_IN_DAYS on the table to 0 before loading.

C. Make sure the files in the stage are either all compressed or all uncompressed.

D. Combine smaller files into larger tiles before loading.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #3

What activities can a user with the ORGADMIN role perform? (Select TWO).

A. Create an account for an organization.

B. Select all the data in tables for all accounts in an organization.

C. View usage information for all accounts in an organization.

D. Delete the account data for an organization.

E. Edit the account data for an organization.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #4

When tracking data storage metrics, how can a user identify deleted bytes that are still accruing storage charges?

A. Query the STORAGE_USAGE view in ACCOUNT_USAGE.

B. Query the TABLE_STORAGE_METRICS view in the INFORMATION_SCHEMA.

C. Use the DATABASE_STORAGE_USAGE_HISTORY table function.

D. Query the DATABASE_STORAGE_USAGE_HISTORY view in ACCOUNT_USAGE.

Discussion 0

Correct Answer: D Vote an answer

Question #5

Which statement accurately describes Snowflake ' s architecture?

A. It reorganizes loaded data into internal optimized, compressed, and row-based format.

B. It is a hybrid of traditional shared-disk and shared-nothing database architectures.

C. It uses a local data repository for all compute nodes in the platform.

D. It is a blend of shared-disk and shared-everything database architectures.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #6

Which role can create and manage Snowflake accounts?

A. ACCOUNTADMIN

B. SECURITYADMIN

C. SYSADMIN

D. ORGADMIN

Discussion 0

Correct Answer: A Vote an answer

Question #7

While unloading a relational table to JSON, which function can be combined with the COPY INTO < location
> command to convert the table rows into a relational table with a single VARIANT column and then unload the rows into a file?

A. OBJECT_CONSTRUCT_KEEP_NULL

B. OBJECT_AGG

C. OBJECT_CONSTRUCT

D. OBJECT_PICK

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #8

What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?

A. Secure view

B. External table

C. Temporary table

D. Materialized view

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #9

Where is metadata management handled in Snowflake?

A. Database Storage

B. Compute

C. Query Processing

D. Cloud Services

Discussion 0

Correct Answer: D Vote an answer

Question #10

Which Snowflake objects can be restored using Time Travel? (Select VNO).

A. Schemas

B. Virtual warehouses

C. Users

D. Databases

E. Roles

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #11

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A. The use of warehouse auto scaling

B. The ability to resize warehouses

C. The ability to scale up warehouses

D. The use of warehouse indexing

E. Use of multi-clustered warehouses

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #12

What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?

A. 0 days

B. 1 day

C. 14 days

D. 7 days

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Question #13

What data-type constructs are used to create a hierarchy when organizing semi-structured data? (Select TWO).

A. An ARRAY or OBJECT holds a value of type VARIANT.

B. An ARRAY or OBJECT holds a value of type VECTOR.

C. An ARRAY or OBJECT holds a value of type VARCHAR.

D. An ARRAY or OBJECT holds a value of type INTEGER.

E. A VARIANT can hold a value of any other data type.

Discussion 0

Correct Answer: A,E Vote an answer

Question #14

Snowflake Documentation on Resource Monitors: Managing Resource Monitors QUSTION NO:600 What is a feature of column-level security in Snowflake?

A. Role access policies

B. External tokenization

C. Network policies

D. Internal tokenization

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).

Free COF-C02 Questions for Snowflake SnowPro Core Certification COF-C02 Exam as PDF & Practice Test Engine

Download Free Snowflake COF-C02 Demo