A virtual warehouse in Snowflake is used to perform data processing tasks that require computational resources, such as queries that modify data or perform significant computation. Of the options provided:
C). INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1, ' Adam
' ,20000, ' Finance ' );This SQL statement performs a data modification operation (DML) by inserting a new record into theTBL_EMPLOYEEtable, which requires computational resources provided by a virtual warehouse to execute.
References:
Snowflake Documentation: Understanding Virtual Warehouses

To list all network policies available in an account, the correct command is SHOW NETWORK POLICIES
. Network policies in Snowflake are used to define and enforce rules for how users can connect to Snowflake, including IP whitelisting and other connection requirements. The SHOW NETWORK POLICIES command provides a list of all network policies defined within the account, along with their details.
The DESCRIBE SESSION POLICY and DESCRIBE NETWORK POLICY commands do not exist in Snowflake SQL syntax. The SHOW SESSION POLICIES command is also incorrect, as it does not pertain to the correct naming convention used by Snowflake for network policy management.
Using SHOW NETWORK POLICIES without any additional parameters will display all network policies in the account, which is useful for administrators to review and manage the security configurations pertaining to network access.
Reference: Snowflake Documentation on Network Policies (https://docs.snowflake.com/en/sql-reference/sql
/show-network-policies.html)

Snowflake supports the VARIANT and ARRAY data types for semi-structured data. VARIANT can store values of any other type, including OBJECT and ARRAY, making it suitable for semi-structured data formats like JSON. ARRAY is used to store an ordered list of elements