Snowflake SnowPro Core Practice Test - Questions Answers, Page 29

The details section of a Query Profile in Snowflake provides users with various statistics and information about the execution of a query. One of the key pieces of information that can be determined from this section is the total duration of the query, which helps in understanding the performance and identifying potential bottlenecks.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

According to my knowledge, a security administrator can create multiple network policies, but only one network policy can be active for an account or specific user at any given time. This ensures that there is a clear and consistent policy being applied without conflicts.Reference:Based on my internal knowledge as of 2021.

In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword ''TABLE.'' This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query.Reference:Based on my internal knowledge as of 2021.

To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV.Reference:Based on my internal knowledge as of 2021.

Snowflake uses a technique called pruning to limit the number of micro-partitions scanned by each query.Pruning effectively filters out unnecessary micro-partitions based on the query's filter conditions, which can significantly improve query performance by reducing the amount of data scanned1.

The command used to unload files from an internal or external stage to a local file system in Snowflake is the GET command.This command allows users to download data files that have been staged, making them available on the local file system for further use23.

Snowflake integrates Duo Security to support Multi-Factor Authentication (MFA).This feature provides increased login security for users connecting to Snowflake, and it is managed completely by Snowflake without the need for users to sign up separately with Duo4.

In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode.This mode allows Snowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases

The Snowflake object that helps evaluate virtual warehouse performance impacted by query queuing is the Information_schema.warehouse_load_history.This view provides historical data about the load on a warehouse, including the average number of queries that were running or queued within a specific interval, which can be used to assess performance and identify potential issues with query queuing3.