SnowPro Core Certification COF-C03 Book

Use COPY INTO < external stage > followed by a GET command to download the file.

Use COPY INTO < internal stage > followed by a put command to download the file.

Use COPY INTO < internal stage > with SINGLE = TRUE followed by a GET command to download the file.

Use COPY INTO < external stage > with SINGLE = TRUE followed by a PUT command to download the file.

CREATE TABLE < table_name > LIKE TABLE_A;

CREATE VIEW < view_name > AS SELECT * FROM TABLE_A;

CREATE TABLE < table_name > AS SELECT * FROM TABLE_A;

CREATE MATERIALIZED VIEW < view name > AS SELECT * FROM TABLE A;

Manually re-cluster the table regularly.

Choose one high cardinality column as the clustering key.

Use the column that is most-frequently used in query select clauses as the clustering key.

Assess the average table depth to identify how clustering is impacting the query.

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.