Comprehensive and Detailed Explanation From Exact Extract:
* Why B (Settings of = 0 or = NULL indicate that the warehouses will remain active indefinitely) is correct:According to the official Snowflake Documentation on Virtual Warehouses, the AUTO_SUSPEND parameter specifies the number of seconds of inactivity after which a warehouse is automatically suspended.
The documentation states:
"If AUTO_SUSPEND is set to NULL or 0, automatic suspension is disabled. The warehouse will never automatically suspend and will remain active until it is explicitly suspended by the user." Therefore:
* AUTO_SUSPEND = 0 # disables automatic suspension (warehouse runs indefinitely).
* AUTO_SUSPEND = NULL # same behavior; auto-suspend is disabled (warehouse remains active indefinitely).
This means both settings have the same outcome - the warehouse will not auto-suspend regardless of idleness.
* Why A is incorrect:A setting of AUTO_SUSPEND = 0 does not mean the warehouse stops immediately. It actually means the auto-suspend feature is disabled, so the warehouse continues running indefinitely until manually suspended.
* Why C is incorrect:Neither 0 nor NULL cause immediate suspension. The warehouse continues to run until manually suspended.
* Why D is incorrect:There is no default period of 600 seconds when AUTO_SUSPEND is set to NULL. The 600-second (10-minute) value is a common configuration example, but not a default value for NULL.
References (Snowflake SnowPro Core / Study Guide / Official Documentation):
* Snowflake Documentation - Virtual Warehouses > Parameters > AUTO_SUSPEND:"Specifies the number of seconds of inactivity after which a warehouse is automatically suspended. A value of NULL or 0 disables automatic suspension."
* Snowflake Study Guide - Account and Resource Management:Describes AUTO_SUSPEND behavior for resource optimization and billing control, clarifying that disabling this feature (0 or NULL) causes warehouses to stay active indefinitely until manually suspended.

When the retention period for an object ends in Snowflake, Time Travel on the historical data is dropped
. This means that the ability to access historical data via Time Travel is no longer available once the retention period has expired2.

The Snowflake URL type used by directory tables is the scoped URL. This type of URL provides access to files in a stage with metadata, such as the Snowflake file URL, for each file

Snowflake automatically rotates the Account and Table master keys when they are more than 30 days old. Active keys are retired, and new keys are created, ensuring robust security through frequent key changes1

A Directory Table stores metadata about unstructured data files in a stage, such as size, last-modified timestamp, and file URL. This metadata helps query or track files without ingesting them into a table.
Reference:
Snowflake Docs: Directory Tables for Unstructured Data