- (Topic 6)
What command is used to export or unload data from Snowflake?

1. A. PUT @mystage
2. B. GET @mystage
3. C. COPY INTO @mystage
4. D. INSERT @mystage

Correct Answer: A
The command used to export or unload data from Snowflake to a stage (such as a file in an S3 bucket, Azure Blob Storage, or Google Cloud Storage) is thePUTcommand. ThePUT command is designed to upload data files from a local file system (in the case of SnowSQL or other client) or a virtual warehouse to a specified stage. This functionality is critical for scenarios where data needs to be extracted from Snowflake for use in external systems, backups, or further processing.
The syntax for thePUTcommand follows the structure:PUT file://<local_file_path>
@<stage_name>, where<local_file_path>specifies the path to the file(s) on the local file system that you wish to upload, and<stage_name>specifies the destination stage in Snowflake.
It's important to distinguish that thePUTcommand is used for exporting data out of Snowflake, whereas theCOPY INTO <table>command is used for importing data intoSnowflake from a stage. TheGETcommand, on the other hand, is used to download files from a stage to the local file system, essentially the inverse operation of thePUT command.
References:
✑ Snowflake Documentation on Loading and Unloading Data: [Loading and Unloading Data](https://docs.snowflake.com/en/user-guide/data-load

- (Topic 2)
Which Snowflake architectural layer is responsible for a query execution plan?

1. A. Compute
2. B. Data storage
3. C. Cloud services
4. D. Cloud provider

Correct Answer: C
In Snowflake??s architecture, the Cloud Services layer is responsible for generating the query execution plan. This layer handles all the coordination, optimization, and management tasks, including query parsing, optimization, and compilation into an execution plan that can be processed by the Compute layer.

- (Topic 6)
Which table function is used to perform additional processing on the results of a previously- run query?

1. A. QUERY_HISTORY
2. B. RESULT_SCAN
3. C. DESCRIBE_RESULTS
4. D. QUERY HISTORY BY SESSION

Correct Answer: B
TheRESULT_SCANtable function is used in Snowflake to perform additional processing on the results of a previously-run query. It allows users to reference the result set of a previous query by its query ID, enabling further analysis or transformations without re-executing the original query.
References:
✑ Snowflake Documentation: RESULT_SCAN

- (Topic 1)
Which Snowflake feature is used for both querying and restoring data?

1. A. Cluster keys
2. B. Time Travel
3. C. Fail-safe
4. D. Cloning

Correct Answer: B
Snowflake??s Time Travel feature is used for both querying historical data in tables and restoring and cloning historical data in databases, schemas, and tables3. It allows users to access historical data within a defined period (1 day by default, up to 90 days for Snowflake Enterprise Edition) and is a key feature for data recovery and management. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 3)
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?

1. A. ROW_NUMBER
2. B. TABLE
3. C. TABULAR
4. D. VALUES

Correct Answer: B
In Snowflake, a tabular User-Defined Function (UDF) is defined with a return clause that includes the keyword ??TABLE.?? This indicates that the UDF will return a set of rows, which can be used in the FROM clause of a query. References: Based on my internal knowledge as of 2021.