Snowflake SnowPro Core Practice Test - Questions Answers, Page 33

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.

The Kafka connector stores formatted information in a single column of type VARIANT.This column type is used to store semi-structured data like JSON or Avro, which allows for flexibility in the data structure

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