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

When unloading data to an external stage, the maximum file size supported is 5 GB.This limit ensures efficient data transfer and management within Snowflake's architecture

A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege.This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

The Snowflake Query Profile provides a graphic representation of the main components of the query processing.This visual aid helps users understand the execution details and performance characteristics of their queries4.

In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage.These metrics suggest that the working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk

The maximum Time Travel retention period for a transient table in Snowflake is 1 day.This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.

The query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isselect * from directory(@bronzestage).This query retrieves a list of all files on the stage along with metadata, including the Snowflake file URL for each file3.

The Snowflake edition that enables data sharing only through Snowflake Support is the Virtual Private Snowflake (VPS).By default, VPS does not permit data sharing outside of the VPS environment, but it can be enabled through Snowflake Support4.

Snowsight automatically detects if a target account is in a different region and enables cross-cloud auto-fulfillment when using a paid listing on the Snowflake Marketplace.This feature allows Snowflake to manage the replication of data products to consumer regions as needed, without manual intervention1.

User-Defined Function (UDF) handlers must be written inline for Javascript and SQL.These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.