* The RESULT_SCAN function returns the output of a previously executed query by referencing its query ID.
* Example:
SELECT * FROM RESULT_SCAN('query_id');
* Other functions like QUERY_HISTORY or TASK_HISTORY provide metadata about queries but do not return query results.
References:
* Snowflake Documentation: RESULT_SCAN Function

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

With the create data EXCHANGE listing privilege, a Snowflake user can modify the properties of listings and submit them for approval or publishing on the Data Exchange. This allows them to manage and share data sets with consumers effectively. Reference: Based on general data exchange practices in cloud services as of 2021.

Snowflake's architecture is designed to operate entirely on cloud infrastructure. It uses the core compute and storage services of each cloud provider, which allows it to leverage the scalability and reliability of cloud resources. Snowflake's services are deployed across multiple availability zones within a cloud provider's region to ensure high availability and fault tolerance. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide