SnowPro Advanced, Architect SnowPro-Advanced-Architect Exam Questions

AUTO Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use BROTLI instead of AUTO. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv 

General Limitations for Shared Databases Shared databases have the following limitations for consumers: Shared databases are read-only. Users in a consumer account can view/query data, but cannot insert or update data, or create any objects in the database. The following actions are not supported: Creating a clone of a shared database or any schemas/tables in the database Time Travel for a shared database or any schemas/tables in the database. Editing the comments for a shared database. Shared databases and all the objects in the database cannot be forwarded (i.e. re-shared with other accounts). https://docs.snowflake.com/en/user-guide/data-share-consumers.html#general-limitations-for- shareddatabases

Materialized views are automatically and transparently maintained by Snowflake. A background service updates the materialized view after changes are made to the base table. This is more efficient and less error-prone than manually maintaining the equivalent of a materialized view at the application level. https://docs.snowflake.com/en/user-guide/views-materialized.html#when-to-use-materialized-views

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