Snowflake COF-C02 Practice Test - Questions Answers, Page 31

When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1

A characteristic of a materialized view is that the data accessed through it can be stale.This is because the data in a materialized view may not reflect the latest changes in the base tables until the view is refreshed

The stream type that can be used for tracking the records in external tables is 'External'.This type of stream is specifically designed to track changes in external tables

In the Activity section in Snowsight, Snowflake users can explore the performance of executed queries.This includes monitoring queries, viewing details about queries, including performance data, and exploring each step of an executed query in the query profile1.

The Snowflake URL type used by directory tables is the scoped URL.This type of URL provides access to files in a stage with metadata, such as the Snowflake file URL, for each file

For the ALLOWED VALUES tag property, the maximum number of possible string values for a single tag is 256.This allows for a wide range of values to be assigned to a tag when it is set on an object

Snowflake's search optimization service supports tables and views that are not protected by row access policies.It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT, and ARRAY (semi-structured) columns1.

To address query concurrency issues, a user can add additional clusters to the virtual warehouse.This allows for the distribution of queries across multiple clusters, reducing the load on any single cluster and improving overall query performance2.

A data consumer who has a pre-signed URL can access data files using Snowflake until the expiration time is exceeded.The expiration time is set when the pre-signed URL is generated and determines how long the URL remains valid3.