Best practices for using the ACCOUNTADMIN role include ensuring that all users with this role use Multi-factor Authentication (MFA) for added security.  Additionally, it is recommended to assign the ACCOUNTADMIN role to at least two users to avoid delays in case of password recovery issues, but to as few users as possible to maintain strict control over account-level operations 4 .

The ResultSet cache is leveraged to quickly return results for repeated queries. Actions that prevent leveraging this cache include stopping the virtual warehouse that the query is running against (B) and executing the RESULTS_SCAN() table function (D).  Stopping the warehouse clears the local disk cache, including the ResultSet cache 1 . The RESULTS_SCAN() function is used to retrieve the result of a previously executed query, which bypasses the need for the ResultSet cache.

 The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake.  References:  [COF-C02] SnowPro Core Certification Exam Study Guide

The Search Optimization Service significantly improves the performance of selective point lookup queries on tables by creating and maintaining a persistent data structure called a search access path, which allows some micro-partitions to be skipped when scanning the table

When loading data into Snowflake, it is recommended to organize the data into single files with 100-250 MB of compressed data per file. This size range is optimal for parallel processing and can help in achieving better performance during data loading operations.  References:  [COF-C02] SnowPro Core Certification Exam Study Guide

 The COPY INTO SQL command with the option  SINGLE=FALSE  is used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.  References:   SnowPro Core Certification COPY INTO SQL command unload multiple files

 In an auto-scaling multi-cluster virtual warehouse with the SCALING_POLICY set to ECONOMY, another cluster is started when the system has enough load for 2 minutes (A).  This policy is designed to optimize the balance between performance and cost, starting additional clusters only when the sustained load justifies it 2 .

Operations that do not require compute resources are typically those that can leverage previously cached results. However, if no queries have been executed previously, all the given operations would require compute to execute.  It’s important to note that certain operations like DDL statements and queries that hit the result cache do not consume compute credits 2 .

The Snowflake Search Optimization Service is designed to support improved performance for selective point lookup queries.  These are queries that retrieve specific records from a database, often based on a unique identifier or a small set of criteria 3 .

 When cloning a database in Snowflake, the clone includes all privileges on the database as well as existing child objects within the database, such as schemas, tables, views, etc.  However, it does not include future child objects or privileges on schemas within the database 2 .

References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation

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 Support 2 .

Network policies in Snowflake are defined as a set of rules that manage the network-level access to Snowflake accounts. These rules specify which IP addresses or IP ranges are permitted to connect to Snowflake, enhancing the security of Snowflake accounts by preventing unauthorized access. Network policies are an essential aspect of Snowflake ' s security model, allowing administrators to enforce access controls based on network locations.

References:

Snowflake Documentation: Network Policies

The TABLE_STORAGE_METRICS view can be used to determine if a table has frequent row updates or deletes. This view provides detailed metrics on the storage utilization of tables within Snowflake, including metrics that reflect the impact of DML operations such as updates and deletes on table storage. For example, metrics related to the num ber of active and deleted rows can help identify tables that experience high levels of row modifications, indicating frequent updates or deletions.

References:

Snowflake Documentation: TABLE_STORAGE_METRICS View

The parameter  STATEMENT_QUEUED_TIMEOUT_IN_SECONDS  sets the limit for a query to wait in the queue in order to get its chance of running on the warehouse. The query will quit after reaching this limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the waiting queue

https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-Timeout-Parameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%20the,indefinitely%20in%20the%20waiting%20queue .

 The  Result cache  is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance by storing the results of queries for a period of time. When the same or similar query is executed again, Snowflake can retrieve the result from this cache instead of re-computing the result, which saves time and computational resources.

References:

Snowflake Documentation on Query Results Cache

SnowPro® Core Certification Study Guide