COF-R02 Snowflake SnowPro Core Recertification Exam Free Practice Exam Questions (2025 Updated)

https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters%20in%20the%20warehouse .

Data Size Limitations

The VARIANT data type imposes a 16 MB size limit on individual rows.

For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.

If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO <title> command to remove the outer array structure and load the records into separate table rows:

copy into <title>

from @~/<file>.json

file_format = (type = 'JSON' strip_outer_array = true);

https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

https://docs.snowflake.com/en/user-guide/privatelink-azure.html

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.

https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are &text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.

https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20used%20to,data%20within%20one%2Dminute%20intervals.

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Characteristics of a VARIANT

A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.

https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB .

https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse

Materialized views require Enterprise Edition. To inquire about upgrading, please contact Snowflake Support

https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%20Support .

Snowflake credits are used to pay for the consumption of resources on Snowflake. A Snowflake credit is a unit of measure, and it is consumed only when a customer is using resources, such as when a virtual warehouse is running, the cloud services layer is performing work, or serverless features are used.

https://docs.snowflake.com/en/user-guide/what-are-credits.html