Snowflake SnowPro Core Practice Test - Questions Answers, Page 28

The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks.Reference:Based on general programming and cloud data service knowledge as of 2021.

The maximum size limit for a record of a VARIANT data type in Snowflake is 16MB. This allows for storing semi-structured data types like JSON, Avro, ORC, Parquet, or XML within a single VARIANT column.Reference:Based on general database knowledge as of 2021.

The SnowSQL file that can store connection information is named 'config'. It is used to store user credentials and connection details for easy access to Snowflake instances.Reference:Based on general database knowledge as of 2021.

With the create data EXCHANGE listing privilege, a Snowflake user can modify the properties of listings and submit them for approval or publishing on the Data Exchange. This allows them to manage and share data sets with consumers effectively.Reference:Based on general data exchange practices in cloud services as of 2021.

Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by the Duo Security service.This service is managed completely by Snowflake, and users do not need to sign up separately with Duo1

The user property 'MINS TO BYPASS MFA' in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.

The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.

Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer.This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance

In the Admin area of Snowsight, users can analyze query performance, manage Snowflake warehouses, set up and view details about resource monitors, manage users and roles, and administer Snowflake accounts in their organization2.