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

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

Snowflake recommends creating separate warehouses for each workload to resolve performance issues caused by shared virtual warehouses.This ensures that the resources are not being overutilized by one user's activities, thereby affecting the performance of another user's activities4.

Snowflake retains information in the ACCESS HISTORY view for 365 days.This allows users to query the access history of Snowflake objects within the last year1.

When a view is defined on a permanent table, and a temporary table with the same name is created in the same schema, the query from the view will return the data from the permanent table.Temporary tables are session-specific and do not affect the data returned by views defined on permanent tables2.

SnowCD (Snowflake Connectivity Diagnostic Tool) is used to diagnose and troubleshoot network connections to Snowflake.It runs a series of connection checks to evaluate the network connection to Snowflake

The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.