Snowflake SnowPro Core Practice Test - Questions Answers, Page 19

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 operations4.

Row level security in Snowflake is available starting with the Enterprise edition.This feature allows for the creation of row access policies that can control access to data at the row level within tables and views

Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days.This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables

When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized.Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data

The credit consumption for maintaining a materialized view is impacted by how often the base table changes and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view's maintenance.Reference:SnowPro Core Certification materialized view credit consumption

The COPY INTO SQL command with the optionSINGLE=FALSEis used to unload data into multiple files. This option allows the data to be split into multiple files during the unload process.Reference:SnowPro Core Certification COPY INTO SQL command unload multiple files

When cloning a database containing stored procedures and regular views with fully qualified table references, the cloned views and stored procedures will reference the cloned tables in the cloned database (A). This ensures that the cloned database is a self-contained copy of the original, with all references pointing to objects within the same cloned database.Reference:SnowPro Core Certification cloning database stored procedures views

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.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

The UNDROP command in Snowflake can be used to directly restore Views and Tables. These objects, when dropped, are moved to a 'Recycle Bin' where they can be restored within a time limit before they are permanently deleted.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide