In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as soon as they are available in a cloud storage location. Pipes use Snowflake's COPY command to load data and can be associated with a Stage object to monitor for new files. When new data files appear in the stage, the pipe automatically loads the data into the target table.
Reference:
Snowflake Documentation on Pipes
SnowPro Core Certification Study Guide
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

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 the TBL_EMPLOYEE table, which requires computational resources provided by a virtual warehouse to execute.
References:
* Snowflake Documentation: Understanding Virtual Warehouses