SOL-C01 Exam Dumps : SnowPro Associate: Platform Certification Exam

The default Time Travel retention period for most objects in Snowflake is1 day(24 hours). Time Travel enables access to historical versions of data after updates, deletes, or drops. It also allows cloning databases, schemas, and tables at previous points in time, and recovering dropped objects.

While Snowflake Enterprise Edition and higher tiers allow retention periods up to 90 days, this extended window is not the default—administrators must explicitly configure it for each table, schema, or database.

Retention periods of 7, 45, or 90 days are possible only with higher service editions; the default for all accounts and objects remains 1 day unless explicitly overridden.

==================

The central difference between aStandard Warehouseand aMulti-cluster Warehouselies inhorizontal scalability and concurrency handling. A Standard Warehouse consists of one compute cluster. Though it can scaleup or down vertically(e.g., Small → Medium), it cannot automatically add more clusters during periods of heavy workload. This means that under peak concurrency, queries can queue until compute resources are available.

AMulti-cluster Warehouse, by contrast, supportsautomatic horizontal scaling, allowing Snowflake to add or remove clusters dynamically based on query demand. This ensures consistent performance under simultaneous workloads, making it essential for high-concurrency analytical environments or BI dashboards.

Both warehouse types share characteristics such as auto-resume, auto-suspend, and compatibility with all query workloads. They differ only in concurrency scaling. Multi-cluster warehouses can still auto-suspend at the warehouse level; the belief they cannot is incorrect. Standard Warehouses are fully functional for all workloads—they are not restricted to loading tasks.

====================================================

TheGRANTcommand is used in Snowflake to assign privileges to a role. GRANT allows administrators to authorize roles to perform actions on objects such as tables, warehouses, schemas, or databases. The REVOKE command removes privileges, CREATE creates objects, and ASSIGN is not a valid Snowflake command. Therefore, GRANT is the correct command for privilege assignment.

=======================================