Snowflake SnowPro Core Practice Test - Questions Answers, Page 36

TheTABLE_STORAGE_METRICSmetadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.

A masking policy in Snowflake consists of a single data type, with one or more conditions, and one or more masking functions.These components define how the data is masked based on the specified conditions3.

Snowflake's Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.

Storing JSON data in a table with a VARIANT data type is optimal for querying because it allows Snowflake to leverage its semi-structured data capabilities.This approach enables efficient storage and querying without the need for flattening the data, which can be performance-intensive1.

The minimum privilege required on an external stage for any role to access unstructured data files using a file URL in the GET REST API is READ. This allows the role to retrieve or download data files from the stage.

The search optimization service and automatic clustering are features that can improve the performance of queries returning a small subset of rows from a large table. The search optimization service is designed for low-latency point lookup queries, while automatic clustering organizes data in micro-partitions based on specific dimensions to reduce the amount of data scanned during queries.

The pre-signed URL type allows users or applications to download or access files directly from a Snowflake stage without authentication. This URL type is open and can be used without needing to authenticate into Snowflake or pass an authorization token.

Resource monitors in Snowflake can be configured at the account and virtual warehouse levels. They are used to track credit usage and control costs associated with running virtual warehouses. When certain thresholds are reached, resource monitors can trigger actions such as sending alerts or suspending warehouses to prevent excessive credit consumption.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

Snowflake data providers can share data residing in different databases through secure views. Secure views allow for the referencing of objects such as schemas, tables, and other views contained in one or more databases, as long as those databases belong to the same account. This enables providers to share data securely and efficiently with consumers.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide