Snowflake SnowPro Core Practice Test - Questions Answers, Page 20

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

To go back to the first version of a transient table created three days prior, one can use Time Travel if theDATA_RETENTION_TIME_IN_DAYSwas set to at least 3 days. This allows the user to access historical data within the specified retention period.Reference:[COF-C02] SnowPro Core Certification Exam Study Guide

The SQL commandSelect * from table(validate(t1, job_id => '_last'));is used to return errors from the last executed COPY command into table t1 in the current session.It checks the results of the most recent data load operation and provides details on any errors that occurred during that process1.

Snowflake supports unloading data in JSON and delimited file formats such as CSV and TSV.These formats are commonly used for data interchange and are supported by Snowflake for unloading operations

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

The Query Profile in Snowflake is used to identify performance issues with queries. Common issues that can be found using the Query Profile include identifying inefficient micro-partition pruning (D) and data spilling to a local or remote disk (E).Micro-partition pruning is related to the efficiency of query execution, and data spilling occurs when the memory is insufficient, causing the query to write data to disk, which can slow down the query performance1.

When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped .This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.

By default, the Snowflake role required to create a share is ACCOUNTADMIN (D).This role has the necessary privileges to perform administrative tasks, including creating shares for data sharing purposes

In a Snowflake role hierarchy, the top-level role is ACCOUNTADMIN.This role has the highest level of privileges and is capable of performing all administrative functions within the Snowflake account