Which of the following statements describe features of Snowflake data caching? (Choose two.)
Correct Answer: B,E
Snowflake's data caching features include the ability to clear the least-recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting called USE_METADATA_CACHE in Snowflake. References:Caching in the Snowflake Cloud Data Platform,Optimizing the warehouse cache
Question 317
Which privilege must be granted by one role to another role, and cannot be revoked?
Correct Answer: C
The OWNERSHIP privilege is unique in that it must be granted by one role to another and cannot be revoked. This ensures that the transfer of ownership is deliberate and permanent, reflecting the importance of ownership in managing access and permissions.
Question 318
True or False: A Virtual Warehouse can be resized while suspended.
Correct Answer: B
Question 319
A Snowflake practitioner is tasked with designing a data lakehouse architecture that requires: * Support for ACID transactions to ensure data consistency. * The ability to evolve schemas over time without rewriting existing data. * Efficient querying capabilities for large datasets. Which table type meets these requirements?
Correct Answer: B
Apache Iceberg tables are designed for open data-lake and lakehouse architectures. The Iceberg table format supports ACID transactions, helping concurrent operations maintain atomicity, consistency, isolation, and durability. It also supports schema evolution, allowing table definitions to change without rewriting all existing data files. Iceberg metadata, snapshots, manifests, and hidden partitioning help compatible engines locate relevant data efficiently when querying large datasets. In Snowflake, Iceberg tables combine Snowflake query semantics and performance with data stored in externally managed cloud storage, usually in Parquet format. Permanent and transient tables are native Snowflake table types, while a basic external table primarily exposes staged files through metadata and is read-only. Therefore, the Iceberg table type satisfies all three stated lakehouse requirements.
Question 320
In the Snowflake access control model, which entity owns an object by default?
Correct Answer: D
In Snowflake's access control model, the default owner of an object is the role that was used to create the object. This role has the OWNERSHIP privilege on the object and can grant access to other roles1
