Snowflake SnowPro Core Practice Test - Questions Answers, Page 40

Virtual warehouses in Snowflake can be started and stopped at any time, providing flexibility in managing compute resources.They can also be resized at any time, even while running, to accommodate varying workloads910.

Reference: [COF-C02] SnowPro Core Certification Exam Study Guide

The parameterDATA_RETENTION_TIME_IN_DAYScan be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.

When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.

Dynamic Data Masking in Snowflake supportstables and views.These objects can have masking policies applied to their columns to dynamically mask data at query time3.

When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

TheSTRIP_NULL_VALUEfunction in Snowflake is used to convert a JSON null value into a SQL NULL value1.

TheBUILD_STAGE_FILE_URLfunction generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

AStreamobject in Snowflake is used for change data capture (CDC), which records data manipulation language (DML) changes made to tables, including inserts, updates, and deletes3.

TheCOPY INTO <table>command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.