Snowflake SnowPro Core Practice Test - Questions Answers, Page 34

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.

The semi-structured data function that interprets an input string as a JSON document and produces a VARIANT value is PARSE_JSON.This function is used to parse a JSON formatted string and return it as a VARIANT data type, which can then be used for further processing within Snowflake3.

In Snowflake, schema objects include Pipes and File formats.Pipes are used for continuous data loading, and File formats specify the format of data files used in loading and unloading operations within Snowflake

Snowpark is designed to bring the data programmability to Snowflake, enabling developers to write code in familiar languages like Scala, Java, and Python. It allows for the execution of these codes directly within Snowflake's virtual warehouses, eliminating the need for a separate cluster.Additionally, Snowpark's compatibility with Spark allows users to leverage their existing Spark code with minimal changes1.

Snowflake's billing for virtual warehouses is per-second, with a minimum of 60 seconds for each time the warehouse is started or resumed. Therefore, if a warehouse runs for 61 seconds, it is billed for 61 seconds.If it is then shut down and restarted, running for an additional 30 seconds, it is billed for another 60 seconds (the minimum charge for a restart), totaling 121 seconds2

The COPY INTO <table> command in Snowflake supports transformations such as casting using a SELECT statement.This allows for the transformation of data types as the data is being loaded into the table, which can be particularly useful when the data types in the source files do not match the data types in the target table