Snowflake COF-R02 Practice Test - Questions Answers, Page 12

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-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.

https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data

A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.

The maximum length of a VARIANT is 16 MB.

A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.

https://docs.snowflake.com/en/user-guide/intro-regions.html

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

<table> command to remove the outer array structure and load the records into separate table rows:

copy into <table>

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/data-cdp-storagecosts.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe%20period.

When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

Tables

External tables

Secure views

Secure materialized views

Secure UDFs

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.

https://docs.snowflake.com/en/user-guide/ecosystem-all.html