Snowflake SnowPro Core Practice Test - Questions Answers, Page 32

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.

The Activity area of Snowsight includes the Query History page, which allows users to monitor and view details about queries executed in their account, including performance data1.It also includes the Automatic Clustering History, which provides insights into the automatic clustering operations performed on tables2.

The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table.A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

The parameter that prevents streams on tables from becoming stale is MAXDATAEXTENSIONTIMEINDAYS.This parameter specifies the maximum number of days for which Snowflake can extend the data retention period for the table to prevent streams on the table from becoming stale4.

To provide a user with the necessary access to create a materialized view in a schema, the user must be granted a role that has the CREATE MATERIALIZED VIEW privilege on that schema.First, the role is granted to the user, and then the privilege is granted to the role

In Snowflake, a namespace is comprised of a database and a schema.The combination of a database and schema uniquely identifies database objects within an account