- (Topic 2)
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?

Correct Answer:B
The error ??Max LOB size (16777216) exceeded?? indicates that the size of the parsed column exceeds the maximum size allowed for a single column value in Snowflake, which is 16 MB. To resolve this issue, the file should be split into multiple smaller files that are within the recommended size range of 100 MB to 250 MB. This will ensure that each JSON document within the files is smaller than the maximum LOB size allowed. Compressing the file, using a larger-sized warehouse, or setting STRIP_OUTER_ARRAY=TRUE will not resolve the issue of the column size exceeding the maximum allowed. References: COPY INTO Error during Structured Data Load: ??Max LOB size (16777216) exceeded????

- (Topic 4)
Which metadata table will store the storage utilization information even for dropped tables?

Correct Answer:B
The TABLE_STORAGE_METRICS metadata table stores the storage utilization information, including for tables that have been dropped but are still incurring storage costs2.

- (Topic 6)
If a virtual warehouse is suspended, what happens to the warehouse cache?

Correct Answer:A
When a virtual warehouse in Snowflake is suspended,the cache is dropped and is no longer available upon restart. This means that all cached data, including results and temporary data, are cleared from memory. The purpose of this behavior is to conserve resources while the warehouse is not active. Upon restarting the warehouse, it will need to reload any data required for queries from storage, which may result in a slower initial performance until the cache is repopulated. This is a critical consideration for managing performance and cost in Snowflake.

- (Topic 3)
For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Correct Answer:B
In the Information Schema and Account Usage, the column that identifies whether a view is secure or not is IS_SECURE2.

- (Topic 6)
The property mins_to_bypass_network_policy is set at which level?

Correct Answer:C
The propertymins_to_bypass_network_policyis set at the account level in Snowflake. This setting allows administrators to specify a time frame during which users can bypass network policies that have been set on their account. It is particularly useful in scenarios where temporary access needs to be granted from IPs not covered by the existing network policies. By adjusting this property at the account level, Snowflake administrators can manage and enforce network access controls efficiently across the entire account. References:
✑ Snowflake Documentation on Network Policies: Network Policies

- (Topic 4)
Which type of loop requires a BREAK statement to stop executing?

Correct Answer:B
The LOOP type of loop in Snowflake Scripting does not have a built-in termination condition and requires a BREAK statement to stop executing4.