- (Topic 6)
What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

1. A. Repair the failed resources.
2. B. Restart failed resources.
3. C. Queue the failed resources
4. D. Provision the failed resources

Correct Answer: B
If any compute resources for a virtual warehouse fail to provision during startup, Snowflake will attempt to restart those failed resources. The system is designed to automatically handle transient issues that might occur during the provisioning of compute resources. By restarting the failed resources, Snowflake aims to ensure that the virtual warehouse has the necessarycompute capacity to handle the user's workloads without manual intervention.References:Snowflake Documentation on Virtual Warehouses

- (Topic 6)
Which function determines the kind of value stored in a VARIANT column?

1. A. CHECK_JSON
2. B. IS_ARRAY
3. C. IS_JSON
4. D. TYPEOF

Correct Answer: D
The function used to determine the kind of value stored in a VARIANT column in Snowflake is TYPEOF.
✑ Understanding VARIANT Data Type:
✑ Using TYPEOF Function:
✑ Example Usage:
SELECT TYPEOF(variant_column) FROM my_table;
✑ uk.co.certification.simulator.questionpool.PList@4255ce8d
✑ Benefits:
References:
✑ Snowflake Documentation: TYPEOF
✑ Snowflake Documentation: VARIANT Data Type

- (Topic 3)
Which file format will keep floating-point numbers from being truncated when data is unloaded?

1. A. CSV
2. B. JSON
3. C. ORC
4. D. Parquet

Correct Answer: D
The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.

- (Topic 6)
What optional properties can a Snowflake user set when creating a virtual warehouse?
(Select TWO).

1. A. Auto-suspend
2. B. Cache size
3. C. Default role
4. D. Resource monitor
5. E. Storage size

Correct Answer: AD
When creating a virtual warehouse in Snowflake, users have the option to set several properties to manage its behavior and resource usage. Two of these optional properties are Auto-suspend and Resource monitor.
✑ Auto-suspend:This property defines the period of inactivity after which the warehouse will automatically suspend. This helps in managing costs by stopping the warehouse when it is not in use.
CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL'
AUTO_SUSPEND = 300; -- Auto-suspend after 5 minutes of inactivity
✑ Resource monitor:Users can assign a resource monitor to a warehouse to control and limit the amount of credit usage. Resource monitors help in setting quotas and alerts for warehouse usage.
CREATE WAREHOUSE my_warehouse WITH WAREHOUSE_SIZE = 'XSMALL'
RESOURCE_MONITOR = 'my_resource_monitor';
References:
✑ Snowflake Documentation: Creating Warehouses
✑ Snowflake Documentation: Resource Monitors

- (Topic 4)
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

1. A. DATA_RETENTION_TIME_IN_DAYS
2. B. MAX_DATA_EXTENSION_TIME_IN_DAYS
3. C. MIN_DATA_RETENTION_TIME_IN_DAYS
4. D. MAX CONCURRENCY LEVEL

Correct Answer: A
The parameter DATA_RETENTION_TIME_IN_DAYS can be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.