COF-C02 Online Practice Questions and Answers

What is generally the FASTEST way to bulk load data files from a stage?

A. Specifying a list of specific files to load

B. Loading by path (internal stages) / prefix

C. Using the Snowpipe REST API

D. Using pattern matching to identify specific files by pattern

Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?

A. Directory table

B. Temporary table

C. Transient table

D. A table with a materialized view

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

A. Indefinitely

B. Until the result_cache expires

C. Until the retention_time is met

D. Until the expiration_time is exceeded

What does the LATERAL modifier for the FLATTEN function do?

A. Casts the values of the flattened data

B. Extracts the path of the flattened data

C. Joins information outside the object with the flattened data

D. Retrieves a single instance of a repeating element in the flattened data

What is one of the benefits of using a multi-cluster virtual warehouse?

A. It will speed up data loading.

B. It will reduce the cost of running the warehouse.

C. It will automatically increase the warehouse size as needed.

D. It will automatically start and stop additional clusters as needed.

How can performance be optimized for a query that returns a small amount of data from a very large base table?

A. Use clustering keys

B. Create materialized views

C. Use the search optimization service

D. Use the query acceleration service

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO