Snowflake SnowPro Core Practice Test - Questions Answers, Page 37

SnowCD is a connectivity diagnostic tool that helps users troubleshoot network connections to Snowflake.It performs a series of checks to evaluate the network connection and provides suggestions for resolving any issues4.

A user with the OWNERSHIP privilege on a user object or the CREATE USER privilege on the account can create or manage other users in a Snowflake account56.

Unstructured data stored in Snowflake can be retrieved by using SQL functions to generate URLs that point to the data.These URLs can then be used to download the data directly to a client

TheACCESS_HISTORYview in Snowflake is utilized to support compliance auditing. It provides detailed information on data access within Snowflake, including reads and writes by user queries.This view is essential for regulatory compliance auditing as it offers insights into the usage of tables and columns, and maintains a direct link between the user, the query, and the accessed data1.

TheSTRIP NULL_VALUESfile format option, when set toTRUE, removes object or array elements that contain null values during the loading process of semi-structured data files into Snowflake.This ensures that the data loaded into Snowflake tables does not contain these null elements, which can be useful when the ''null'' values in files indicate missing values and have no other special meaning2.

Snowflake supports the storage of semi-structured data using theARRAYandVARIANTdata types. TheARRAYdata type can directly containVARIANT, and thus indirectly contain any other data type, including itself.TheVARIANTdata type can store a value of any other type, includingOBJECTandARRAY, and is often used to represent semi-structured data formats like JSON, Avro, ORC, Parquet, or XML34.

APre-signed URLshould be used to access files stored in a Snowflake stage without requiring authentication into Snowflake. Pre-signed URLs are simple HTTPS URLs that provide temporary access to a file via a web browser, using a pre-signed access token.The expiration time for the access token is configurable, and this type of URL allows users or applications to directly access or download the files without needing to authenticate into Snowflake5.

The Notify & Suspend action for a resource monitor in Snowflake sends a notification to all account administrators who have notifications enabled and suspends all assigned warehouses.However, the suspension only occurs after all currently running statements in the warehouses have been completed1.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

The query acceleration service in Snowflake is designed to benefit queries that involve large scans and selective filters.This service can offload portions of the query processing work to shared compute resources, which can handle these types of workloads more efficiently by performing more work in parallel and reducing the wall-clock time spent in scanning and filtering2.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide