What are the default Time Travel and Fail-safe retention periods for transient tables?
Correct Answer: C
Transient tables in Snowflake have a default Time Travel retention period of 1 day, which allows users to access historical data within the last 24 hours. However, transient tables do not have a Fail-safe period. Fail-safe is an additional layer of data protection that retains data beyond the Time Travel period for recovery purposes in case of extreme data loss. Since transient tables are designed for temporary or intermediate workloads with no requirement for long-term durability, they do not include a Fail-safe period by default1. References: * Snowflake Documentation on Storage Costs for Time Travel and Fail-safe
Question 732
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Correct Answer: A
Question 733
True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.
Correct Answer: B
Question 734
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
Correct Answer: A,B
Snowflake supports querying semi-structured data using specific data types that are capable of handling the flexibility and structure of such data. The data types supported for this purpose are: A . VARIANT: This is a universal data type that can store values of any other type, including structured and semi-structured types. It is particularly useful for handling JSON, Avro, ORC, Parquet, and XML data formats1. B . ARRAY: An array is a list of elements that can be of any data type, including VARIANT, and is used to handle semi-structured data that is naturally represented as a list1. These data types are part of Snowflake's built-in support for semi-structured data, allowing for the storage, querying, and analysis of data that does not fit into the traditional row-column format. Reference: Snowflake Documentation on Semi-Structured Data [COF-C02] SnowPro Core Certification Exam Study Guide
Question 735
When is the result set cache no longer available? (Select TWO)
