Snowflake SnowPro Core Practice Test - Questions Answers, Page 29
Related questions
Question 281

How can a Snowflake user optimize query performance in Snowflake? (Select TWO).
Explanation:
To optimize query performance in Snowflake, users can cluster a table, which organizes the data in a way that minimizes the amount of data scanned during queries.Additionally, enabling the search optimization service can improve the performance of selective point lookup queries on large tables34.
Question 282

What can a Snowflake user do with the information included in the details section of a Query Profile?
Explanation:
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
Question 283

How many network policies can be assigned to an account or specific user at a time?
Explanation:
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.
Question 284

A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
Explanation:
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.
Question 285

What is the recommended way to change the existing file format type in my format from CSV to JSON?
Explanation:
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.
Question 286

What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
Explanation:
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.
Question 287

Which command is used to unload files from an internal or external stage to a local file system?
Explanation:
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.
Question 288

Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?
Explanation:
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.
Question 289

If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
Explanation:
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
Question 290

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
Explanation:
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.
Question