COF-C02 Online Practice Questions and Answers

The Snowflake Search Optimization Services supports improved performance of which kind of query?

A. Queries against large tables where frequent DML occurs

B. Queries against tables larger than 1 TB

C. Selective point lookup queries

D. Queries against a subset of columns in a table

By default, which role has privileges to create tables and views in an account?

A. PUBLIC

B. SECURITYADMIN

C. SYSADMIN

D. USERADMIN

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Choose two.)

A. GO driver

B. Node.js driver

C. ODBC driver

D. Python connector

E. Spark connector

Which account usage view in Snowflake can be used to identify the most-frequently accessed tables?

A. Access_History

B. Object_Dependencies

C. Table_Storage_Metrics

D. Tables

Which Snowflake features can be enabled by calling the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function by a user with the ORGADMIN role? (Choose two.)

A. Clustering

B. Client redirect

C. Fail-safe

D. Search optimization service

E. Account and database replication

Snowflake users can create a resource monitor at which levels? (Select TWO).

A. User level

B. Pipe level

C. Account level

D. Cloud services level

E. Virtual warehouse level

Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?

A. APPROXIMATE_SIMILARITY

B. JAROWINKLER_SIMILARITY

C. APPROXIMATE_JACCARD_INDEX

D. MINHASH_COMBINE

What is the relationship between a Query Profile and a virtual warehouse?

A. A Query Profile can help users right-size virtual warehouses.

B. A Query Profile defines the hardware specifications of the virtual warehouse.

C. A Query Profile can help determine the number of virtual warehouses available.

D. A Query Profile automatically scales the virtual warehouse based on the query complexity.

What is the MOST cost-effective way to resolve memory spillage in a virtual warehouse?

A. Enable automatic clustering.

B. Enable the query acceleration service.

C. Enable the search optimization service.

D. Convert to a Snowpark-optimized warehouse.

Which Snowflake feature improves the performance of point lookup queries?

A. Materialized views

B. Automatic clustering

C. Query acceleration service

D. Search optimization service